menu

Recent posts tagged sqlite

Level UI • 21 hours • in Articles • 9 min read
An MCP server is not a new API. It is a thin layer over the one you already have
Somewhere in the last year, "do we need an MCP server?" joined the list of questions that arrive in a brief before anyone has said what the thing is for. It is usually framed as MCP vs API, as though the Model Context Protocol were a newer kind of AP...
post-cover-33074
  • ai
  • api
  • webdev
  • security
7 Reactions 7 Comments
Alok kumar singh • 5 days • in Articles • 13 min read
Offline-First Bible Reader on iOS: Bundled SQLite, Full-Text Search and iCloud-Synced Notes
Originally published at https://bestlatestapps.com/blog/building-an-offline-first-bible-reader-on-ios/https://bestlatestapps.com/blog/building-an-offline-first-bible-reader-on-ios/ How I'd structure a scripture app that works on a plane: a read-only...
  • ios
  • sqlite
  • swift
  • icloud
2 Reactions 1 Comments
Tom Smithverified • Sep 15 • in Articles • 4 min read
SQLite's Two-Person Team Just Passed Its First AI Stress Test
This spring, open source maintainers across the internet started noticing the same strange thing at the same time: a flood of bug reports that no human had written. Not spam. Not malicious. Just confidently wrong, at a scale nobody had planned for. D...
post-cover-27308
  • sqlite
  • ai
  • opensource
  • devtools
1 Reactions 0 Comments
boazleleina • Sep 9 • in Articles • 11 min read
Alembic in Practice: Structure, Revisions, and the Traps SQLite Sets
What those hex filenames mean, why migrations silently applied to the wrong database for two months, and how to widen a CHECK constraint without quietly breaking it. Alembic is the migration tool for SQLAlchemy. Most tutorials get you as far as ale...
  • python
  • database
  • sqlite
  • tutorial
3 Reactions 1 Comments
Iko Uchiha • Sep 8 • in Articles • 1 min read
Shrinking a Materials Science Dataset
Shrinking datasets is quite contextual. It depends on how the dataset is going to be used. Its the same concept as optimizing databases, based on the read/write patterns. PACLEC and Traffic Patterns are the key determining factors. Hosted on fly.io...
  • sqlite
4 Reactions 1 Comments
AIAppsAPI • Aug 23 • in Articles • 2 min read
Ranking New Papers By Meaning Instead Of Keywords, In One PHP App
Most of us have built some version of a scheduled job that watches a feed and mails out a summary, and it almost never fails on the plumbing. It fails on relevance, and this is a writeup of a small PHP and SQLite project that puts a model scoring ste...
  • php
  • sqlite
  • ai
  • automation
0 Reactions 0 Comments
AIAppsAPI • Aug 14 • in Articles • 2 min read
One PHP App and One SQLite File: A Self Hosted Workflow Engine
Most of us here have written the same glue script more than once, the one that catches a form submission and pushes it somewhere else, then quietly rots in a cron job nobody documented. This is a look at an open source engine that gives that glue a p...
  • php
  • sqlite
  • automation
  • open-source
0 Reactions 0 Comments
Tom Smithverified • 17 hours • in Articles • 9 min read
Developer Weekly Briefing — October 30, 2026
Security dominated this week, but not in the usual way. Two active campaigns turned GitHub configuration files into attack surfaces. Researchers demonstrated that the built-in browsers inside AI coding tools can read your SSH keys. And at Oracle AI ...
post-cover-33104
  • agenticai
  • devsecops
  • github
  • localai
6 Reactions 3 Comments
YasirAwan4831 • Aug 8 • in Articles • 4 min read
From GitHub Repositories to a Professional Data Analytics Portfolio Website
Building More Than Just Projects — Building My Professional Identity Completing my Data Analyst Internship1 at Logic Stack was a significant milestone. Over four weeks, I worked on real-world business problems using Excel, Power BI, Python and SQL,...
post-cover-24288
  • dataanalytics
  • sql
  • sqlite
  • python
4 Reactions 0 Comments
YasirAwan4831 • Aug 7 • in Articles • 7 min read
Continuing My Data Analyst Journey: Week 3, 4 and Challenges I Faced During My Data Analyst Intern
In my previous blog, I shared my journey through Week 1 and Week 2, where I worked on Excel-based data cleaning, sales analysis, Pivot Tables and Power BI dashboards. As the internship progressed, the learning curve became much steeper. The focus sh...
post-cover-24267
  • dataanalytics
  • sql
  • sqlite
  • powerbi
3 Reactions 0 Comments
Ken W. Algerverified • Jun 16 • in Articles • 4 min read
Expanding the Sovereign AI Stack: Moving the Specification from Gateway to Local Silicon
When I first introduced the Sovereign Systems Specificationhttps://kenwalger.github.io/sovereign-system-spec/ and released the initial foundation of the SDK, sovereign-core and its accompanying sovereign-fastapi integration layer see announcement pos...
post-cover-20724
  • ai
  • python
  • sqlite
  • architecture
6 Reactions 2 Comments
lovestaco • Apr 4 • in Articles • 6 min read
How SQLite Turns Hardware Chaos into Correctness
Hello, I'm Maneshwar. I'm building git-lrc, an AI code reviewer that runs on every commit. It is free, unlimited, and source-available on Github. Star Us to help devs discover the project. Do give it a try and share your feedback for improving the pr...
  • sqlite
  • webdev
  • programming
  • database
4 Reactions 8 Comments
Methodox • Jun 24, 2025 • in Articles • 4 min read
SQLite - High-Level Introduction
SQLite SQLite is a self-contained, serverless, zero-configuration relational database engine. Unlike traditional database servers, SQLite is distributed as a simple library that you embed directly into your applications. This guide will introduce y...
  • database
  • sql
  • sqlite
  • divooka
4 Reactions 1 Comments
Muzzamil Abbas • Mar 19, 2025 • in Tutorials • 7 min read
Database Interaction using Python: Introduction to SQLite/MySQL/PostgreSQL
The article covers POSTGRESQL, MySQL, and SQLITE3—three major database management systems. They provide unique features and benefits and are essential to software development. Let's explore their features so that you can make better selections that w...
  • python
  • database
  • mysql
  • sqlite
  • postgresql
22 Reactions 9 Comments
To see more, click for the full list of posts or popular tags.
chevron_left
🔥 12 posts • 👩‍💻 10 active writers
✨ Want to write in this topic?
Share your learning. Get discovered. Build your profile.
Join CoderLegion
💡 Why developers use CoderLegion
Track learning • Share posts • Get ranked publicly
Create your profile