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	863	February 19, 2021
Send multipart request from julia using HTTP.jl New to Julia	8	1527	September 27, 2021
HTTP.post() Exceptions.StatusError(400, ...) New to Julia http	3	216	November 15, 2023
PostgreSQL in Julia: LibPQ.jl Data package , data	9	5830	July 5, 2018
Uploading Multi-part files in julia General Usage question , http	5	902	February 24, 2021

HTTP request body -> PostgreSQL

Related topics