{"repo":"lpil/sqlight","free":true,"listed":false,"github":"https://github.com/lpil/sqlight","clone":"git clone https://github.com/lpil/sqlight.git","description":"💡 Use SQLite from Gleam!","language":"Gleam","stars":155,"topics":["database-client","gleam","sqlite"],"license":null,"category":"databases-storage","readme_excerpt":"sqlight Use SQLite from Gleam! Works on Erlang and on JavaScript runtimes that support node:sqlite , like NodeJS, and NodeJS. Documentation can be found at . Why SQLite? SQLite is a implementation of SQL as a library. This means that you don't run a separate SQL server that your program communicates with, but you embed the SQL implementation directly in your program. SQLite stores its data in a single file. The file format is portable between different machine architectures. It supports atomic transactions and it is possible to access the file by multiple processes and different programs. You can also use in-memory databases with SQLite, which may be useful for testing. Implementation When running on Erlang it is a library wrapper around the excellent Erlang library esqlite, which in turn is a wrapper around the SQLite C library. It is implemented as a NIF, which means that the SQLite database engine is linked to the erlang virtual machine. When running on JavaScript it is a wrapper around the node:sqlite module that is built-in to the most common runtimes. On using Bool with SQLite SQLite does not have a native boolean type. Instead, it uses ints, where 0 is False and 1 is True. Because of this the Gleam stdlib decoder for bools will not work, instead the sqlight.decode bool function should be used as it supports both ints and bools.","default_branch":null,"files":null,"tree":[],"storefront":"/r/lpil","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/lpil/sqlight/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."}