Best of SQLite — 2024

1
Article
Collections·2y
Databases In-Depth – Complete Course
A comprehensive course on database architecture and optimization, designed by Keerti Purswani and available on freeCodeCamp.org's YouTube channel. It covers transaction management, storage engines, advanced indexing techniques, an in-depth look at SQLite, and understanding MongoDB and PostgreSQL. Suitable for both beginners and experienced engineers, the course aims to equip learners with the skills to manage and optimize data systems efficiently.
237
2
2
Article
Hacker News·1y
outerbase/studio: A lightweight Database GUI in your browser. It supports connecting to Postgres, MySQL, and SQLite.
Outerbase Studio is a lightweight, browser-based GUI for managing SQL databases, initially built for LibSQL and SQLite but now supporting a range of databases including MySQL and PostgreSQL. It features a user-friendly query editor, a powerful data editor, a schema editor, and a flexible connection manager. The desktop apps for Windows and Mac offer additional support for drivers not feasible in a browser environment.
220
3
3
Article
Laravel News·2y
Access your database right inside VS Code!
DevDb is a lightweight VS Code extension that provides a database GUI client and displays the data and schema details directly in the editor. It supports SQLite, MySQL, and PostgreSQL, including a zero-config option for easy setup.
183
6
4
Article
Hacker News·1y
Introducing Limbo: A complete rewrite of SQLite in Rust
Turso has announced Limbo, a complete rewrite of SQLite in Rust, aiming for robust memory safety and modern architecture while maintaining full compatibility with SQLite's language and file format. Limbo leverages deterministic simulation testing for higher reliability and ensures asynchronous operations from the ground up. Initial benchmarks show promising performance improvements, and the project continues to grow with community contributions.
178
10
5
Article
Supabase·2y
The Open Source Firebase Alternative
FerretDB is an open source document database that adds MongoDB compatibility to other database backends like Postgres and SQLite. This post explains how to run FerretDB locally via Docker, test it with mongosh, and deploy it on Fly.io for production.
175
10
6
Article
Lobsters·1y
7 Databases in 7 Weeks for 2025
This post discusses seven databases that are worth exploring in 2025, each offering unique capabilities and use cases. It covers PostgreSQL, SQLite, DuckDB, ClickHouse, FoundationDB, TigerBeetle, and CockroachDB, highlighting their key features and suggesting practical experiments to deepen understanding. This mix includes both well-established and emerging technologies, offering insights into client-server models, embedded databases, analytics, financial transaction processing, and globally distributed databases.
126
1
7
Article
Supabase·2y
Building offline-first mobile apps with Supabase, Flutter and Brick
Building offline-first mobile apps improves user experience by ensuring app usability in areas with poor connectivity. Using Supabase and Brick with Flutter allows data to be cached locally, minimizing round trip times and enabling apps to function smoothly offline. Brick manages local and remote state synchronization, providing code generation for serialization/deserialization and handling migrations automatically.
116
5
8
Article
Laravel News·2y
SQLite Studio is a SQLite Database Explorer
SQLite Studio is a lightweight, single-command database explorer for SQLite databases, which also supports connections to local SQLite databases, remote libSQL Servers, and PostgreSQL Servers. It features an intuitive interface with an overview of metadata, infinite scroll for rows view, and a custom query page. The backend is built with Rust while the frontend leverages TypeScript, React, Tailwind CSS, and Vite. SQLite Studio is open-source and available on GitHub.
100
2
9
Article
Hacker News·1y
trailbaseio/trailbase: A blazingly fast, single-file, open-source application server with type-safe APIs, Auth, and Admin UI built on Rust+SQLite.
TrailBase is an open-source, single-file application server known for its speed and type-safe APIs. Built on Rust and SQLite, it includes built-in authentication, an admin UI, and supports sub-millisecond latencies. The server is highly extensible, supporting mobile, web, and desktop applications, and boasts simple self-hosting. Pre-built binaries are available, and it is easy to build from source. Contributions are welcome, though licensing under OSL-3.0 with certain conditions applies.
94
10
Article
Laravel·2y
Laravel 11 Now Available
Laravel 11 introduces a minimal application structure, Laravel Reverb provides real-time WebSocket communication, and new Laravel applications use SQLite as the default database.
82
1
11
Article
Hacker News·2y
35% Faster Than The Filesystem
SQLite can read and write small blobs roughly 35% faster than directly accessing individual files on disk. SQLite also uses about 20% less disk space due to its more efficient storage format. The performance gains come from reduced system call overhead and efficient data packing. Tests have shown SQLite's competitive latency with direct file I/O, with some systems exhibiting higher SQLite performance. Variations in performance are observed across different operating systems and hardware.
80
1
12
Article
Engineer’s Codex·2y
5 Non-LLM Software Trends To Be Excited About
Innovations in software engineering outside the AI spotlight include local-first software improving user experience and data processing locally, advancements in WebAssembly allowing for near-native speed in the browser, a renewed interest in SQLite for its simplicity and performance, significant improvements in cross-platform mobile development with React Native and Flutter, and the use of automated reasoning for improving system reliability and security. These trends are shaping the future of software development through better performance, user experience, and reliability.
79
4
13
Article
Hacker News·2y
mayneyao/eidos: Offline alternative to Notion. Eidos is an extensible framework for managing your personal data throughout your lifetime in one place.
Eidos is an offline, extensible framework designed to manage your personal data throughout your lifetime. It operates entirely within your browser with PWA support, offering local data storage for high performance without an internet connection. The platform integrates AI features, accessible even in offline mode, and allows extensive customization via JavaScript and TypeScript, among other tools. Eidos supports developer-friendly features such as API & SDK and SQLite standardization. The project leverages various open-source components and is licensed under AGPL.
78
2
14
Article
Quastor Daily·2y
How Notion Decreased Latency by 20% with Caching
Notion achieved a 20% improvement in page navigation speeds by implementing SQLite for client-side caching in their browser application. They used a 'SharedWorker' architecture with WebAssembly to overcome issues like SQLite corruption and slow disk reads/writes. The solution included utilizing web locks to prevent multiple writers and a SharedWorker to manage active tab writes, resulting in optimized caching performance.
66
1
15
Article
Hacker News·2y
Just use Postgres
When developing a new application requiring persistent data storage, Postgres should be the default choice, especially for web applications. SQLite is suitable for desktop or mobile apps but not ideal for websites. NoSQL databases like DynamoDB, MongoDB, Cassandra, and others offer performance benefits if the access patterns are well-defined beforehand but are less flexible when handling evolving access needs. Redis is efficient for caching but can be used as a primary database with some trade-offs. Datomic and XTDB present innovative approaches with specific benefits and challenges. While advanced databases like Kafka and ElasticSearch excel in niche tasks, Postgres often suffices for general needs, potentially complemented by simpler built-in search functions.
62
13
16
Article
Hacker News·1y
blackcandy-org/blackcandy: A self hosted music streaming server
Black Candy is a self-hosted music streaming server that can be easily installed using Docker. It supports both SQLite and PostgreSQL databases, with SQLite being the default. Features include mounting media files, using environment variables for configuration, and logging control via Docker options. The server can also be proxied through Nginx for improved performance. Mobile apps are available for Android, and a demo can be accessed with limited privileges. Upgrading involves careful steps due to potential breaking changes in major versions.
60
3
17
Article
LogRocket·2y
Using the built-in SQLite module in Node js
Node.js v22.5.0 has introduced a native SQLite module, albeit in an experimental phase. This module allows developers to create databases either in memory or in a specified file without requiring external dependencies. The post provides a comprehensive guide to using this built-in SQLite module, including building a simple to-do app with Express.js, bcrypt, and nanoid. While the module offers a lightweight, embedded database solution, it currently supports only synchronous queries and lacks custom build options and extensions. It highlights the module's ease of use compared to third-party packages like node-sqlite3 and better-sqlite3.
58
18
Video
ThePrimeTime·2y
Sqlite Is Getting So Good
The post dives into a new multi-tenant architecture and issues a scalability challenge for a serverless database based on a fork of SQLite. It emphasizes the advantages of deterministic simulation testing (DST) and highlights the importance of not reinventing the wheel unless mission-critical. It also discusses the application of Rust and its borrow checker for improved safety and performance, the implementation of DST for bug detection, and the decision-making process behind choosing Rust over Zig for the rewrite project.
51
1
19
Article
Anton Zhiyanov·2y
Funding my projects
Anton is looking for financial support for his open-source projects. He maintains projects like redkaRedis, codapi, and sqlean. Anton has also written interactive guides like Curl by example and Git by example.
51
1
20
Article
Community Picks·2y
The Tiny Stack (Astro, SQLite, Litestream)
Explore the concept of the Tiny Stack, a simple yet powerful stack for building web applications. Learn about Astro, SQLite, and Litestream, the core components of this stack.
50
2
21
Article
Lobsters·1y
Collection of insane and fun facts about SQLite
SQLite is the world's most deployed and used database, maintained by just three people without outside contributions. It originated from a need for a serverless database on a US warship. SQLite is in the public domain and has an extensive test suite, partly proprietary, ensuring reliability. It has unique traits such as a single writer model, weak typing, and no foreign keys by default. Despite its quirks, SQLite has strong backward compatibility and diverse applications, even outperforming filesystems in some cases.
49
1
22
Video
Fireship·2y
SQLite and its weird new fork “libSQL”
SQLite, originally created for the US Navy, is a widely deployed, serverless SQL database. Its open-source nature has led to the fork named libSQL, which adds server mode and enhanced features like replication, encryption, and WebAssembly triggers. These improvements support unique databases per user, offering better performance and scalability, particularly in serverless environments.
46
2
23
Article
FREEK.DEV·2y
Is it time to ditch MySQL and PostgreSQL for SQLite?
Evaluate the potential of SQLite as a replacement for MySQL and PostgreSQL in production web applications.
43
5
24
Article
Community Picks·2y
How Notion uses SQLite for Caching
Notion uses SQLite for client-side caching to enhance performance in its apps across various platforms. Initially implemented in 2021, this approach significantly speeds up initial page loads and navigation. Notion employs WebAssembly to use SQLite in browsers and addresses challenges like database corruption, slow disk reads, and asynchronous loading to optimize the user experience.
42
25
Article
Quastor Daily·2y
How Notion Decreased Latency by 20% with Caching
Notion boosted page navigation speed by 20% on its website by implementing client-side caching using SQLite and WebAssembly. They utilized a 'SharedWorker' architecture to handle data writing, resolving issues related to database corruption and slow disk reads. This approach significantly improved user experience without regressing other performance metrics.
42
1

See all SQLite archives