litestack | SQLite3 | |
---|---|---|
16 | 5 | |
898 | 745 | |
- | 2.3% | |
9.0 | 9.4 | |
4 days ago | 6 days ago | |
Ruby | Ruby | |
MIT License | BSD 3-clause "New" or "Revised" License |
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.
litestack
-
Speed Up Your Ruby on Rails Application with LiteCache
The benchmarks for LiteCache are impressive, with a small caveat. While LiteCache outperforms a local Redis installation for every read operation, it seems like there's still room for improvement, especially for large write payloads.
-
Stream Updates to Your Users with LiteCable for Ruby on Rails
Luckily, the official LiteStack benchmarks include measurements for LiteCable against Redis, which I am going to quote here.
-
Handle Incoming Webhooks with LiteJob for Ruby on Rails
Let's quickly look into how LiteJob uses SQLite to implement a job queueing system. In essence, the class Litequeue interfaces with the SQLite queue table. This table's columns, like id, name, fire_at, value, and created_at, store and manage job details.
- All-in-one Ruby gem for webapp data infrastructure
-
An Introduction to LiteStack for Ruby on Rails
Next, we install LiteStack using the shipped generator:
-
I'm All-In on Server-Side SQLite
Related: I wrote a piece last week on deploying Rails apps to production on Fly.io at https://fly.io/ruby-dispatch/sqlite-and-rails-in-production/
The work that’s made this possible is:
1. Litestack - https://github.com/oldmoe/litestack
2. Fly.io’s work on the dockerfile-rails generator detecting Sqlite and Litestack in a Rails project, then setting up sane defaults for where that data is stored and persisted in production. This is all done behind the scenes with no intervention required from the person deploying.
3. Servers are overall faster and more powerful
I hope more Rails hosts make it easier and safer to deploy Sqlite to production. It will lower costs and reduce complexity for folks deploying apps.
-
Extralite 2.0 has been released!
Didn't know that one! The litestack.gemspec shows it's a wrapper around the sqlite3 gem. So, not really comparable...
-
LiteFS Cloud: Distributed SQLite with Managed Backups
I’m working on this for Rails apps at https://github.com/oldmoe/litestack/pull/12
The idea is that people with small-to-medium size Rails Turbo apps should be able to deploy them without needing Redis or Postgres.
I’ve gotten as far as deploying this stack _without_ LiteFS and it works great. The only downside is the application queues requests on deploy, but for some smaller apps it’s acceptable to have the client wait for a few seconds while the app restarts.
When I get that PR merged I’ll write about how it works on Fly and publish it to https://fly.io/ruby-dispatch/.
-
Ask HN: What's the fastest and simplest way to prototype a web app in 2023?
Rails is the way to go. The productivity of the Ruby language is insane. It's battle tested for decades and you can easily scale your prototype.
If you want a simple app served on a single host you can try LiteStack [0] so you don't need a Redis/Postgres/Sidekiq instance, just SQLite.
Laravel is also good if you like PHP language.
[0] https://github.com/oldmoe/litestack
- Litestack: A Ruby gem that provides an all-in-one solution for web application
SQLite3
- Working with SQLite in Ruby
-
Extralite 2.0 has been released!
Extralite is a gem for working with SQLite databases. It is blazing fast (up to 11x the performance of the sqlite3 gem), and provides a rich API for accessing database data in a variety of formats.
-
Understanding Clean Architecture with small Ruby libraries
DB: sparklemotion/sqlite3-ruby: Ruby bindings for the SQLite3 embedded database
-
Sharing my exp so far with using SQLite in Production
# This configure_connection is run when each new connection is created. # see https://github.com/rails/rails/blob/main/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb#L1112 def configure_connection super puts "Configuring DB connection with app-specific PRAGMA statements" conn = self.raw_connection # see https://github.com/sparklemotion/sqlite3-ruby/blob/master/lib/sqlite3/pragmas.rb conn.synchronous = 1 # normal # this is a permanent pragma but in case DB is brand new, no harm is invoking it conn.journal_mode = 'wal' # this is unnecssary b/c rails' sqlite3adapter turns it on by default conn.foreign_keys = true # this is not yet supported with convenience method #conn.analysis_limit = 400 # PRAGMA temp_store = 'memory' # hold temporary indices and tables in memory # conn.temp_store = 2 end
-
Resources for learning environment related things?/Help getting sqlite3 working with ruby on WSL ubuntu
That looks like you're missing the ruby module, not the OS package. If you're using bundler to manage your dependencies, add gem 'sqlite3', '~> 1.3', '>= 1.3.11' to your Gemfile. For reference, I got that line from this page: https://rubygems.org/gems/sqlite3/versions/1.3.11
What are some alternatives?
extralite - Ruby on SQLite
mysql2 - A modern, simple and very fast Mysql library for Ruby - binding to libmysql
sqld - LibSQL with extended capabilities like HTTP protocol, replication, and more.
TinyTDS - TinyTDS - Simple and fast FreeTDS bindings for Ruby using DB-Library.
corrosion - Gossip-based service discovery (and more) for large distributed systems.
SQL Server - SQL Server Adapter For Rails
sqlite-y-crdt - Y-CRDT extension for SQLite
Clickhouse - A Ruby database driver for Clickhouse
mycelite - Mycelite is a SQLite extension that allows you to synchronize changes from one instance of SQLite to another.
DataObjects
replicate-rails - Replicate gem for Rails
Redic - Lightweight Redis Client