Articles by Tag #sqlite
Browse our collection of articles on various topics related to IT technologies. Dive in and explore something new!
Building a RESTful API with Laravel 11, A Complete Guide
Laravel is a popular PHP framework known for its simplicity and power. It allows developers to create...
Tauri 2.0 - Sqlite DB - React
I’m currently building my first Tauri app and needed a persistent data storage solution. After some...
Implementing OpenDAL with Filesystem (FS) In Rust
Introduction to OpenDAL with SQLite Virtual Tables OpenDAL is a powerful and unified data...
How to Create ER Diagrams for SQLite with a Free Tool
If you're working with a SQLite database, one of the best ways to understand how it's built is to...
Streamlining Your Rails 8 App: Migrating from Postgres to SQLite
Originally published on my blog: Streamlining Your Rails 8 App: Migrating from Postgres to...
Cloudflare D1 + Drizzle ORM Setup Guide
Cloudflare D1 + Drizzle ORM Setup Guide This guide explains how to set up Cloudflare D1...
I still prefer SQLite for little things you know.
I still can't express enough how useful SQLite is, when i need a db for small and experiments stuff,...
Mastering Database Migrations in Go with golang-migrate and SQLite
Managing database changes is critical for any software project. This guide walks you through using...
An Introduction to PHP and SQLite
Introduction PHP and SQLite are a powerful combination for lightweight web applications...
How to Build Lightweight GraphRAG with SQLite
This blog post demonstrates how to create a lightweight GraphRAG system using SQLite, combining document processing with graph-based retrieval. Learn how to extract and manage entities and relationships in SQLite, use centrality measures to enhance query accuracy, and visualize your graph data with D3.js. This tutorial is ideal for intermediate developers seeking a scalable solution for small-to-medium datasets.
Cloudflare D1 and Prisma: Not a Good Combination (For Now)
Recently, I started migrating my monolith project to a Cloudflare Worker. At the same time, I decided...
MySQL vs SQLite أيهما أفضل ؟
في مجال قواعد البيانات يوجد هناك نوعان لنظم إدارة قواعد البيانات (DBMS)...
Mastering SQLite: Efficient Database Management Tips
SQLite is the unsung hero of lightweight databases. It’s embedded in everything from mobile apps and...
How to use sqlite-vec to store and query vector embeddings
Vector search is a game-changer for LLM-based applications, but what if you could do it without...
The definitive guide to using Django with SQLite in production 💡
I have been running Django sites in production under heavy load for over 10 years at my day job. We...
🚀 Building a User Management API with FastAPI and SQLite
FastAPI has become one of the most popular Python web frameworks, thanks to its speed, simplicity,...
Java JDBC + IntelliJ + SQLite - A Beginner's Walkthrough
IntelliJ Community + JDBC + SQLITE (or any other database) no build tool required (Maven...
Docker Compose with Rails 8, Tailwind and SQLite
Hello, long time no see! In this guide I'm going to show you how to use Docker Compose to setup and...
Self-Host Your Own URL Shortener with Zero Database Setup
Self-hosting shouldn't require a PhD in DevOps. After trying various URL shorteners that demanded...
Build your own SQLite, Part 2: Scanning large tables
In the previous post, we discovered the SQLite file format and implemented a toy version of the...
Remember to set the frequency for replication to Litestream!
Curious about how I ended up with an invoice nearing $100 for conducting over 20 million Class A...
A Tale of Two Databases
Sqlite vs Postgresql Sqlite is one of the most deployed database in the world. Its...
Best SQLite NuGet Packages for .NET Applications
SQLite is a lightweight and powerful database engine widely used in .NET applications. Choosing the...
Can You Create a Product That Makes Money with Wasm?
Hello! I’m what you might call a technology enthusiast. When I see a new trend in the tech world, I...
Building a Simple SQLite Library Manager in Python
Building a Simple SQLite Library Manager in Python Managing data efficiently is a key part...
Injecting Real-Time WebSocket Streams into SQLite Using Python and WAL Hooking
SQLite isn't the first database that comes to mind for real-time streaming — but with Python and a...
SQLite Database Recovery
SQLite databases can be prone to corruption like any other database file, with varying degrees of...
In-Memory Database with SQLite
Wolf Fact: With 200M+ olfactory cells housed in the nose, a wolf’s sense of smell is their...
Spark Augmented Reality (AR) Filter Engagement Metrics
I recently completed an SQL challenge on the interviewmaster.ai platform involving a scenario where I...
Deploy FastAPI application with SQLite on Fly.io
Cloud solutions are good for medium and large projects, but too heavy for small personal projects. If...