Menu

#Sqlite

98 posts

Feed·
20 of 98 posts
How I Slashed LLM Costs by 80% with a Semantic Caching Proxy in Python & FastAPI
📰
0Read More

How I Slashed LLM Costs by 80% with a Semantic Caching Proxy in Python & FastAPI

DEV Community: fastapi·Ruesch Manny·3 days ago
#fXu5eWYh
#devtofastapi#devto#dev#fastapi#sqlite

Learn how to build a production-ready Semantic LLM Caching Proxy using Python 3.10+ and FastAPI to cut OpenAI costs, track tokens, and reduc

15s
node:sqlite: The Database That Already Ships With Node
🖼️
0Read More

node:sqlite: The Database That Already Ships With Node

DEV Community: node·Danny Holloran·3 days ago
#YHdZjvxI
#devtonodejs#devto#dev#node#sqlite

Node has a built-in SQLite module. Here's how node:sqlite works, where its synchronous API fits, and what changed in Node 26 before reaching for better-sqlite3.

15s
Making a React Native app agent-ready: what happens when Siri calls and your JavaScript isn't running
🖼️
0Read More

Making a React Native app agent-ready: what happens when Siri calls and your JavaScript isn't running

DEV Community: reactnative·Praveen Singh·5 days ago
#dvRQ3ZaC
#devtoreactnative#devto#dev#sqlite#expo

At a glance Problem: Siri or Gemini calls your React Native app while its JavaScript isn't...

15s
0Read More

Recommendations For Data Warehouse RDBMS on Laptop?

I am creating a data warehouse for my personal infotainment using Python. My original plan was to use SQLite since it is embedded in Python and super easy to use. My design got off to a great start, but SQLite did not scale when loading data.…

15s
We benchmarked SQLite, ObjectBox, and ToStore for On-Device RAG in Flutter: 5-dimension results & architecture comparison
🖼️
0Read More

We benchmarked SQLite, ObjectBox, and ToStore for On-Device RAG in Flutter: 5-dimension results & architecture comparison

DEV Community: flutter·QuantumVoid·8 days ago
#jmewW4lq
#devtoflutter#devto#dev#tostore#vector

Flutter On-Device RAG and Vector Search Deep Dive: SQLite, ObjectBox, or ToStore? A...

15s
How to add AI memory in Hermes Agent | SQLite Memory
📰
0Read More

How to add AI memory in Hermes Agent | SQLite Memory

DEV Community: tutorial·Mahesh·14 days ago
#OtBG6Nkm
#devtotutorial#devto#dev#hermes#agent

Hermes agent has support for multiple AI memory providers. I have covered a lot of services which are...

15s
SQLite 3.54 stops rewriting an expression index when the indexed value hasn't changed
📰
0Read More

SQLite 3.54 stops rewriting an expression index when the indexed value hasn't changed

DEV Community: database·Alex Georgiev·16 days ago
#7KsfIDIb
#devtodatabase#devto#dev#index#sqlite

SQLite 3.54.1 cut a 50,000-row no-op UPDATE from 2,143 WAL pages to 511, exactly matching a table with no expression index at all. Once the indexed value actually changes, the saving disappears entirely.

15s
SQLite Says 'database is locked' at 4 Writers: WAL, busy_timeout and BEGIN IMMEDIATE
🖼️
0Read More

SQLite Says 'database is locked' at 4 Writers: WAL, busy_timeout and BEGIN IMMEDIATE

DEV Community: tutorial·Gabriel Anhaia·19 days ago
#xsJ1r6HJ
#devtotutorial#devto#dev#timeout#sqlite

A runnable Node script that forks 4 SQLite writers and counts SQLITE_BUSY under 4 setups, plus why busy_timeout can't save a deferred transaction.

15s
Rust solved the compatibility trap with editions
📰
0Read More

Rust solved the compatibility trap with editions

DEV Community: rust·RC·20 days ago
#JKFmysgu
#devtorust#devto#dev#sqlite#author

Delete a user from a stock SQLite database, forget to delete their posts, and nothing complains....

15s