{"repo":"JuliaAPlavin/SQLCollections.jl","free":true,"listed":false,"github":"https://github.com/JuliaAPlavin/SQLCollections.jl","clone":"git clone https://github.com/JuliaAPlavin/SQLCollections.jl.git","description":"Use the same code to manipulate both Julia collections and SQL databases with transparent function-based interface.","language":"Julia","stars":12,"topics":["data-manipulation","sql","tabular-data","collections","database","unified-interface"],"license":"MIT","category":"databases-storage","readme_excerpt":"SQLCollections.jl [!IMPORTANT] Imagine using the same code to manipulate both regular Julia collections and SQL databases... The SQLCollections.jl package makes this a reality! While many Julia packages offer convenient interfaces for querying databases (see the comparison below), SQLCollections.jl is unique. It allows you to reuse the same code and functions, without any modification, for both in-memory collections and databases. SQLCollections.jl avoids macros, relying instead on a fundamentally function-based interface. There are no special parsing or interpolation rules to memorize, resulting in less implicit behavior. This design also allows SQLCollections.jl to integrate seamlessly with convenience macros from other packages, most notably Accessors.jl and DataPipes.jl. Here are some simple examples illustrating how the same code can operate on either a regular Julia collection or an SQLCollection : More examples are available in the tests (and more documentation is coming later). SQLCollections.jl leverages FunSQL.jl and works with any database supported by it (SQLite, DuckDB, Postgres, MySQL, and more). A wide range of operations are already supported by SQLCollections.jl:f - Base: map , filter , sort , Iterators.drop , first , and others. - DataManipulation.jl: group and others. - Modifications: push! , append! , copy! . Coming Soon: - FlexiJoins.jl: join . - Support for nested structures within SQL tables. SQLCollections.jl acts as a very thin layer, translating Juli","default_branch":null,"files":null,"tree":[],"storefront":"/r/JuliaAPlavin","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/JuliaAPlavin/SQLCollections.jl/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}