CSV file is being uploaded (multipart/form-data) to my HTTP service. My task is to read content of that file and store it in PostgreSQL table. HTTP request body contains raw data (content of CSV file/files). How to parse & store it in the database table the most efficient way? julia> using HTTP jul…

You can use the write_table! function from https://github.com/lungben/TableIO.jl It implements the COPY FROM STDIN functionality using CSV.jl and LibPQ.jl. https://github.com/lungben/TableIO.jl/blob/ce1f205053cee0270ae2b53c0787d576f70e0c4e/src/postgresql.jl#L32

HTTP request body -> PostgreSQL

New to Julia

Jan_Dolinsky February 9, 2021, 2:54pm 4

This is also a useful read: Upload of DataFrame data to databases - #5 by mmiller

1 Like

Topic		Replies	Views
Parsing multipart data using HTTP.jl New to Julia	3	883	February 19, 2021
Send multipart request from julia using HTTP.jl New to Julia	8	1543	September 27, 2021
HTTP.post() Exceptions.StatusError(400, ...) New to Julia http	3	222	November 15, 2023
How to serialize data to, and deserialize from, postgres? General Usage serialization	9	3077	September 25, 2023
Upload of DataFrame data to databases Data	6	2393	October 19, 2020

HTTP request body -> PostgreSQL

Related topics