GitHub - sqliteai/sqlite-js: Create custom SQLite functions in JavaScript. Extend your database with scalars, aggregates, window functions, and collations directly in JavaScript.You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
We will rewrite SQLite. And we are going all-in
Jan 21, 2025 We will rewrite SQLite. And we are going all-in Two years ago, we made a bet: SQLite, the most successful database in history, could be even better. Not just marginally better – fundamentally better. We believed that the missing piece wasn't technical, but human: SQLite needed an open contribution model that would give developers everywhere a seat at the table. This vision led us to f
Cloud Run + Litestream で RDB を使いつつ費用を格安に抑える
前から気になっていた Litestream を Cloud Run で使ってみたので、そのメモです。 Litestream とは？ サンプルコード 手順 動作確認してみる 制限事項 おまけ まとめ 参考 Litestream とは？ Litestream は、 SQLite のデータベースファイルを Amazon S3 や Google Cloud Storage などのオブジェクトストレージにリアルタイムでレプリケートすることができるオープンソースのツールです。 例えば通常 Cloud Run で DB エンジンとして SQLite を使用しようとしても、コンテナが破棄されると同時に毎回 SQLite のデータベースファイルも消えてしまうため、データを永続化することができません。 しかし Litestream を使用すれば、 SQLite のデータベースファイルをオブジェクトストレージに
CI for performance: Reliable benchmarking in noisy environments
CI for performance: Reliable benchmarking in noisy environments by Itamar Turner-Trauring Last updated 07 Dec 2023, originally created 02 Dec 2020 You have some code—whether it’s Python, Rust, Java, or some other language—whose speed you want to measure over time. Ideally you want it to get faster, but at the very least you don’t want to get any slower. So you write a benchmark, and now you need t
Skip the API, Ship Your Database
Skip the API, Ship Your Database Author Name Ben Johnson @benbjohnson @benbjohnson Image by Annie Ruygt With Fly.io, you can get your app running globally in a matter of minutes, and with LiteFS, you can run SQLite alongside your app! Now we’re introducing LiteFS Cloud: managed backups and point-in-time restores for LiteFS. Try it out for yourself! My favorite part about building tools is discover
LiteFS - Distributed SQLite
Docs Index Get Started with LiteFS Toggle Get Started with LiteFS section LiteFS overview Speedrun: Adding LiteFS to your app Getting Started with LiteFS on Fly.io Getting Started with LiteFS in Docker How LiteFS Works FAQ LiteFS Cloud Toggle LiteFS Cloud section Using LiteFS Cloud for Backups Restoring from a LiteFS Cloud Backup Disaster Recovery from LiteFS Cloud Using LiteFS Toggle Using LiteFS
Using LiteFS with Bun on Fly.io
A picture of delicious food by me, 30 minutes ago (at the time of writing)UpdateThere is a repository to fork and try that simplifies this whole post, specially after latest development with Fly and Bun. As neither Bun nor LiteFS are recommended for production yet, I’ve decided it was obviously a good idea to deploy “their synergy” on fly.io 😇 “… but why?” … well, this is why! What’s Bun very goo
Building data-centric apps with a reactive relational database
Building apps is too hard. Even skilled programmers who don’t specialize in app development struggle to build simple interactive tools. We think that a lot of what makes app development hard is managing state: reacting and propagating changes as the user takes actions. We’re exploring a new way to manage data in apps by storing all app state—including the state of the UI—in a single reactive datab
About the sqlite3 WASM/JS Subproject
WebAssembly, a.k.a. WASM, is a standard defining a low-level programming language suitable (A) as a target for cross-compilation from many other languages and (B) for running via a virtual machine in a browser. Designed with scriptability via JavaScript in mind, it provides a way to compile C code (among others) to WASM and script it via JavaScript with relatively little friction despite the vast
🦆🦆🦆🦆🦆🦆DuckDB入門🦆🦆🦆🦆🦆🦆
tl;dr SQLiteのOLAP版だよ OLAP系のクエリにおいて、PandasやSQLiteより早いらしいよ CSV・Parquet・Pandas DataFrameの読み書きできて便利だよ 背景 ポジション・競合 一言で言うとSQLiteのOLAP版です。位置づけとしては、論文(DuckDB: an Embeddable Analytical Database (SIGMOD 2019 Demo))記載のSystem Landscapeがわかりやすいです。 （DuckDB: an Embeddable Analytical Database (SIGMOD 2019 Demo)より） このLandscapeでは、データベースを Standalone（クライアント・サーバモデル）か、組み込み（シングルマシン・インプロセス）か OLTPかOLAPか の二軸に分割しています。その上で、 ク
Running WordPress in the Browser
Do you know it is possible to run WordPress entirely in your browser? This is possible because of WebAssembly, also known as Wasm: an exciting and rapidly growing technology that allows you to compile many different programming languages into portable binaries. These binaries can run in most modern browsers as well as many other platforms, including cloud and edge computing. At VMware's OCTO Wasm
Arc Note: Datasette - Simon Willison
I am very happy to introduce our first Arc Note with Simon Willison who is going to be talking about Datasette, SQLite and the challenges of building a server-side web application that also works in both Electron and WebAssembly. Its a great read — I hope you enjoy and hopefully learn a little something. 💡 Simon is the creator of Datasette and co-creator of Django web framework. Formerly he was a
Write-Ahead Logging
1. Overview The default method by which SQLite implements atomic commit and rollback is a rollback journal. Beginning with version 3.7.0 (2010-07-21), a new "Write-Ahead Log" option (hereafter referred to as "WAL") is available. There are advantages and disadvantages to using WAL instead of a rollback journal. Advantages include: WAL is significantly faster in most scenarios. WAL provides more con
リリース、障害情報などのサービスのお知らせ
最新の人気エントリーの配信
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
lib,src,test,doc: add node:sqlite module by cjihrig · Pull Request #53752 · nodejs/node
GitHub - tconbeer/harlequin: The SQL IDE for Your Terminal.
GitHub - aerotoad/neboa: Type-safe NoSQL with Node & SQLite. 🌫️💽
Turso - Databases for All
GitHub - asg017/sqlite-http: A SQLite extension for making HTTP requests purely in SQL
GitHub - thebinarysearchtree/flyweight: An ORM for SQLite
GitHub - litements/s3sqlite: Query SQLite files in S3 using s3fs
