Best of SQLite — October 2024

1. 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. 2
   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
3. 3
   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
4. 4
   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
5. 5
   Article

   Real Python·2y

   Build a Contact Book App With Python, Textual, and SQLite – Real Python

   Learn how to build a contact book application with a text-based interface (TUI) using Python and Textual, while managing and storing contact data with an SQLite database. This hands-on project helps in applying various coding skills simultaneously, covering the creation of TUI, handling database operations, and connecting the TUI with database code for functionality. The tutorial also emphasizes best practices including setting up a project structure and using a virtual environment.

   31

   1
6. 6
   Article

   Community Picks·2y

   High Performance SQLite

   High Performance SQLite is a comprehensive video course by database educator @aarondfrancis designed to teach users how to effectively use SQLite in production environments. The course covers all essential aspects to ensure reliability, speed, and efficiency.

   29