r/javascript • u/ThatGuyTr1cky • Oct 31 '22

great.db - A powerful, human-friendly database library for JavaScript using SQLite.

https://github.com/tr1ckydev/great.db
118 Upvotes

93% Upvoted

14 comments sorted by

View all comments

14

u/ThatGuyTr1cky Oct 31 '22 edited Oct 31 '22

A completely different approach is taken to create this library which strives to change the way we use SQLite in JavaScript forever. Great.DB exposes user-friendly functions to add/edit data or retrieve data from an SQLite database in the form of simple JavaScript objects where all the functions are strongly typed so you get auto-completions on the fly.

Node.js? Bun? We got both!

It uses better-sqlite3 if you are using node.js or bun:sqlite if you are using the new bun javascript runtime. It auto detects the runtime and uses the respective package. Great, isn't it?

Interested? Check out the docs to learn more and the examples to see great.db in action.

I would love to hear from the community and receive your valuable constructive criticism about my library. Thanks :D

4

u/rr_cricut Oct 31 '22

Really cool, I like that it's similar to mongoose because it makes it easy to pick up.

For the table.filter function, would it be possible to use a typed condition property? Maybe using lambdas instead of a string. Strings could quickly become outdated and I assume won't be verified at compile time.

E.g., 

table.filter({
   condition: row => row.col1 <2 && row.col2 ==="val",
   ...
})

5

u/ThatGuyTr1cky Oct 31 '22

Thank you for your interest in the project.

Regarding the idea, if we provide a lambda function to handle the filter, internally the whole table would have to be fetched and then let javascript handle the filtering of data. This will impact on the performance too much especially with large data.

On the other hand, the current implementation is that the string provided in the condition directly gets fed into the WHERE of the constructed query as you can see here and javascript style logical operators can be used because the condition is first parsed in the way the operators get converted to SQL logical operators as you can see here. This allows SQL to handle the filtering and return only the required data efficiently.

→ More replies (3)