Best of SQLite — June 2024

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

   Community Picks·2y

   orbitinghail/sqlsync: SQLSync is a collaborative offline-first wrapper around SQLite. It is designed to synchronize web application state between users, devices, and the edge.

   SQLSync is a collaborative offline-first wrapper around SQLite. It synchronizes web application state between users, devices, and the edge. It supports real-time collaboration, optimistic mutations, and cross-tab sync. To use SQLSync, you can join the Discord community and follow the guide to add it to your application. You can debug SQLSync in Google Chrome by accessing the special URL: chrome://inspect/#workers. The underlying library used by SQLSync is rusqlite. To run multiple SQL statements with SQLSync, it is recommended to execute them individually. Contributions to SQLSync are welcome and can be discussed in the Discord community.

   42

   1