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...
Introducing Scenestamps: The Movie Scene Database
Remember that scene in The Dark Knight where the Joker makes a pencil disappear? Or that...
Tauri 2.0 - Sqlite DB - React
I’m currently building my first Tauri app and needed a persistent data storage solution. After some...
Use SQLite as a Celery broker in Django
Run an SQLite-powered Celery broker in your Django application.
Fundamentos para Web APIs com .NET: Uma Introdução ao Essencial com Entity Framework
Desenvolva a API DessaVezEuNaoEsqueco. No meio desse desenvolvimento, vamos mergulhar nos conceitos...
Streamlining Your Rails 8 App: Migrating from Postgres to SQLite
Originally published on my blog: Streamlining Your Rails 8 App: Migrating from Postgres to...
Build your own SQLite, Part 1: Listing tables
As developers, we use databases all the time. But how do they work? In this series, we'll try to...
How To Install SQLite On Windows
Howdy, In This Article We Will See How To Install Sqlite On Windows OS. Installing...
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,...
Cloudflare D1 + Drizzle ORM Setup Guide
Cloudflare D1 + Drizzle ORM Setup Guide This guide explains how to set up Cloudflare D1...
An Introduction to PHP and SQLite
Introduction PHP and SQLite are a powerful combination for lightweight web applications...
Multitenant Database Schemas
I recently got to hang with Jamie Barton (@notrab) from the Turso team. We discussed Multitenant...
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...
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.
Using Python to Dump Data into Django Models for Testing Frontend or API Endpoints:A Complete Django REST API Tutorial
As a developer working on APIs or front-end applications, you need data in your database to test API...
🚀 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,...
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...
Introducing vectorlite: A Fast and Tunable Vector Search Extension for SQLite
Introduction With the rise of LLMs(Large Language Models) and RAG(Retrieval-Augmented...
Mastering SQLite: Efficient Database Management Tips
SQLite is the unsung hero of lightweight databases. It’s embedded in everything from mobile apps and...
MySQL vs SQLite أيهما أفضل ؟
في مجال قواعد البيانات يوجد هناك نوعان لنظم إدارة قواعد البيانات (DBMS)...
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...
Hosting a simple Laravel application using Turso on Laravel Forge
Introduction After learning that Turso made a Laravel driver for LibSQL I just knew I had...
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...
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...
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...
A Tale of Two Databases
Sqlite vs Postgresql Sqlite is one of the most deployed database in the world. Its...
Spark Augmented Reality (AR) Filter Engagement Metrics
I recently completed an SQL challenge on the interviewmaster.ai platform involving a scenario where I...
Building a Simple SQLite Library Manager in Python
Building a Simple SQLite Library Manager in Python Managing data efficiently is a key part...
SQLite Database Recovery
SQLite databases can be prone to corruption like any other database file, with varying degrees of...
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...