rusqlite-model
sqlite-readers-writers
rusqlite-model | sqlite-readers-writers | |
---|---|---|
1 | 1 | |
11 | 1 | |
- | - | |
0.0 | 10.0 | |
over 1 year ago | over 1 year ago | |
Rust | Rust | |
- | - |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
rusqlite-model
-
Show HN: Write universally accessible SQL, not library-specific ORM wrapper APIs
I'm quite anti-ORM, though I've never not used one professionally (just because it's already been there / not my decision), so that might be different if I did for a while. I do think something's necessary though, and it maybe is a bit arbitrary where we draw the line for what's an 'ORM'?
For example, I really enjoyed using rusqlite for a little side project/personal thing, but found apart from anything else just the repetition of `(?,?,?,?,?,?)` any time I wanted to insert something was annoying, for example. I started working a bit on [0] .. I don't know if I'd call it an ORM, just so I didn't have to do that, and could write `Model { ... }.insert(&conn)` instead. But still write plain SQL queries, I just want easy mapping between db table and language 'model' struct/class; column and field/attr.
[0] - https://github.com/OJFord/rusqlite-model
sqlite-readers-writers
-
In pursuit of the best value US cloud provider
This has been posted and reposted continuously for a year and I still don’t understand the comparisons in the article. Either use SQLite across the board or use MySQL/Postgres across the board. Or do both. You can even model a self-managed rdbms install on the clouds that don’t have that turnkey offering. But mixing and matching makes no sense.
I’m a huge fan of SQLite and have open sourced some .NET stuff around it (eg https://github.com/neosmart/AspSqliteCache ) but learned a very expensive mistake in using it for an ASP.NET Core Project with the default pattern (i.e. with EF Core).
SQLite locks (tables or the entire db depending on configuration) upon write. If you use shared cache mode and WAL you can get very far with one write thread and many competing reads - depending on shared cache mode, WAL, and other options. I benchmarked the different configurations with one or more writing threads here to show how it scales: https://github.com/mqudsi/sqlite-readers-writers
But this approach is hard to model with EF Core. If you use the default request-scoped DI injected connection, you risk any writes upgrading the read lock to a write lock for the duration of the request. The better approach is to use the default request-scoped connection for RO operations and then request a scoped/transient DI connection for any write ops, but copying internal EF entity tracking state from one EF instance to another is tedious and fraught with issues. You’re at least able to work around this if you try to always keep in mind write transaction lifetimes, though.
The problem comes as soon as you need a “background service” in the sense of “an operation running independently of requests and parallel to them.” If that service needs a write lock for any amount of time, you’re suddenly going to be seeing write timeouts (since default behavior is to poll repeatedly until a write lock is obtained) and that is pretty much impossible to fix.
As one of the biggest advantages of using a resident executor like .NET or Java vs a per-request stateless option like PHP is that you can do stuff independent of requests, SQLite is tricky to use correctly in prod in this model.
The good news is that if you use the SQLite EF provider and run into this, it’s usually not too hard to switch to a real DB provider as a lot of the work is abstracted.
What are some alternatives?
diesel - A safe, extensible ORM and Query Builder for Rust
vfsstat.rs - Example sqlite3 Dynamic Loadable Extension in Rust - vfs and vtab modules - port of vfsstat.c
pure-orm - A pure ORM for writing native SQL queries yielding pure business objects
rsqlite3 - sqlite3 Rewritten in RiiR Rust 🦀🦀🦀 /s
pgdbf - Convert XBase / FoxPro databases to PostgreSQL
SqliteCache for ASP.NET Core - An ASP.NET Core IDistributedCache provider backed by SQLite
mammoth - A type-safe Postgres query builder for TypeScript.
sea-query - 🔱 A dynamic SQL query builder for MySQL, Postgres and SQLite
Norm - The SQL generation library you already know how to use.
doteur - Tool to automate the visualisation of SQL schemas from a SQL file
Hangfire - An easy way to perform background job processing in .NET and .NET Core applications. No Windows Service or separate process required
rbatis - Rust Compile Time ORM robustness,async, pure Rust Dynamic SQL