Julia Wrapper Package for Working with httpserver

[TheCedarPrince]

I created a small Julia wrapper package for working with httpserver DuckDB Databases called DuckDBServer.jl. It isn't too featureful at the moment; here is a working demo:

julia> using DuckDBServer

julia> host = "http://10.0.0.121:8080/"; # Raspberry Pi running httpserver

julia> body = "SELECT * FROM dbt_synthea_dev.person LIMIT 3;"; # SQL Query

julia> df = execute(host, body); # DataFrame output

julia> df
3×18 DataFrame
 Row │ person_id  gender_concept_id  year_of_birth  month_of_birth  day_of_birth  birth_datetime  race_con
     │ Int64      Int64              Int64          Int64           Int64         Union…          Int64   
─────┼────────────────────────────────────────────────────────────────────────────────────────────────────
   1 │         1               8532           1955               4            17                          
   2 │         2               8507           1940               6             3                          
   3 │         3               8532           1986              11            14                          

This was based off the discussion and demo from BlueSky!

P.S. If you want to try this from within your own Julia REPL, you have to add the package as follows: pkg> add https://github.com/TheCedarPrince/DuckDBServer.jl.

[lmangani]

🎉 Thank you so much for creating and sharing this @TheCedarPrince 👏 👏 👏 👏 👏 👏
I'll add this integration to the documentation somewhere and update this discussion once I find the proper place

[TheCedarPrince]

Sounds great! Glad you like it @lmangani! I'll probably do a bit more cleaning up of the package and add a test suite for coverage in the meantime. Let me know if you have any questions!