Building an Offline AI Interview Coach with Foundry Local, RAG, and SQLite | Microsoft Community Hub How to build a 100% offline, AI-powered interview preparation tool using Microsoft Foundry Local, Retrieval-Augmented Generation, and nothing but...

Building an Offline AI Interview Coach with Foundry Local, RAG, and SQLite | by Lee Stott

buff.ly/iLB1SCI

#ai #sqlite #foundrylocal #aimodels #rag #foundry

DotGhostBoard v1.3.0 "Wraith" — Tags, Collections, Multi-Select & Export 👻 A deep dive into every feature shipped in the Wraith release of my open-source PyQt6 clipboard...

DotGhostBoard v1.3.0 "Wraith" — Tags, Collections, Multi-Select & Export 👻 A deep dive into every feature shipped in the Wraith release of my open-source PyQt6 clipboard manager ...

#python #sqlite #opensource #linux

Origin | Interest | Match

SQLite MCP Servers — 3.5/5

15+ servers, no clear leader. Anthropic's archived. sqlite-explorer 104★ read-only. jparkerweb 93★ best CRUD. db-mcp 139 tools but 1★. DBHub 2.4k★ may be best option.

chatforest.com/reviews/sqlite-mcp-servers/

#MCP #SQLite #AI #MCPServers #Database

Zero-Ceremony Identity: Why I Built a Single-Binary OIDC Provider in Go When I set out to build Auténtico, my primary goal was to create a fully-featured OpenID Connect...

Zero-Ceremony Identity: Why I Built a Single-Binary OIDC Provider in Go When I set out to build Auténtico , my primary goal was to create a fully-featured OpenID Connect Identity Provider where op...

#identity #idp #go #sqlite

Origin | Interest | Match

Sauvegarde et restauration SQLite multiservices Protégez vos bases de données SQLite avec un LXC dédié nommé sqlite-backup. Une solution maison pour automatiser vos sauvegardes Vaultwarden sans coupure et garantir une restauration fiable à 100%.

Découvrez comment mettre ça en place sur le wiki :
👉 wiki.blablalinux.be/fr/sauvegard...

#SelfHosted #Proxmox #SQLite #BlablaLinux #Backup #Linux #SysAdmin

3D Dungeon in linux console

https://github.com/mtatton/dungeona

#Ansi #Python #Curses #Dungeon #Game

Use SQL triggers to prevent overwriting a value #database #postgresql #reading-list #sql #sqlite

🔗 Use SQL triggers to prevent overwriting a value

#database #postgresql #reading-list #sql #sqlite

The Database Choice You Made in Week One Comes Back in Month Six. Picking a local database for a Flutter app feels like a low-stakes decision early on. It isn’t. The wrong choice means rewriting…

I just published The Database Choice You Made
in Week One Comes Back in Month Six. medium.com/p/the-databa...
#Flutter #FlutterDev #Dart #FlutterDatabase #drift #Isar #Hive #SQLite #FlutterOffline #LocalStorage #FlutterInterview #MobileDevelopment #TechInterview #SoftwareEngineering

Release v0.7.0 · oliverandrich/burrow Breaking Changes Uploads: flag names renamed — --upload-dir → --uploads-dir, --upload-url-prefix → --uploads-url-prefix, --upload-allowed-types → --uploads-allowed-types. Environment variables cha...

Tagged version 0.7.0 of burrow. Today I added SSE functionality. I am always impressed how easy to implement and deploy SSE is in #golang. And I also succeeded to implement the "per user one database"-pattern with burrow and #sqlite so easily.

github.com/oliverandric...

Original post on social.tchncs.de

Tagged version 0.7.0 of burrow. Today I added SSE functionality. I am always impressed how easy to implement and deploy SSE is in #golang. And I also succeeded to implement the "per user one database"-pattern with burrow and #sqlite so easily […]

Zvec-the SQLite of vector databases?
Zvec is an open-source, lightweight, in-process vector database developed by the AlibabaGroup research team,
positioned as "the #SQLite of vector databases". How does it compare?
On IProgrammer: nikosvg.short.gy/ECO8IC

#vectordatabase #zvec #database

Bypassing 2FA in Web Scraping: Why iMessage is a Local SQL Database and How That Changes Everything The Problem Two-factor authentication kills web scraping. Every automated login flow hits...

Wrote up the full implementation with code, architecture decisions, and how I keep PII out of the LLM context.

dev.to/mparker25/by...

#macOS #sqlite #2FA #webscraping #ai

Hey hey #sqlite and/or any #dba peeps.

Can someone help me look over my proposal for a database structure? It's for an image gallery.

I have no dev friends and I'd like a second set of eyes.
#programming #dev #webdev #database #sysadmin

Daily cron works for me on most setups, but I've seen weekly be enough for simple log rotation. Storage constraints and compliance needs really dictate this. Currently I use SQLite with a 7-day TTL for debug logs. What's your use case? #SQLite #LocalAI #DevOps

Emacs window with split view of the python script to in progress and csv file.

Productive yesterday building my own Lorcana db for my use case. This is a screenshot of my work in the middle of making the script to import my card counts. #python #sqlite #emacs

For the search algorithm: #webscraping #python #macOS #sqlite #automation

I love FTS5 so much. It is easy to use, and so far I don't have a single issue wit 10.000.000 entries in database. #sqlite

Original post on simonwillison.net

Coding agents for data analysis Coding agents for data analysis Here's the handout I prepared for my NICAR 2026 workshop "Coding agents for data analysis" - a three hour session aimed a...

#data-journalism #python #speaking #sqlite #ai #datasette #generative-ai #llms #github-codespaces #nicar […]

Coding agents for data analysis Coding agents for data analysis Here's the handout I prepared for my NICAR 2026 workshop "Coding agents for data analysis" - a three hour session aimed a...

#data-journalism #geospatial #python #speaking #sqlite #ai […]

[Original post on simonwillison.net]

Original post on simonwillison.net

Coding agents for data analysis Coding agents for data analysis Here's the handout I prepared for my NICAR 2026 workshop "Coding agents for data analysis" - a three hour session aimed a...

#data-journalism #geospatial #python #speaking #sqlite #ai #datasette #generative-ai #llms […]

A sufficiently thought out deployment of #sqlite is indistinguishable from “the usual prod databases”. - simplespuns 10th rule

PocketBase - Open Source backend in 1 file Open Source backend in 1 file with realtime database, authentication, file storage and admin dashboard

Just going to put it out there.
POCKETBASE FUCKING ROCKS.

/end-psa

pocketbase.io
#pocketbase #sqlite

A Safety Parachute for Your Symfony Migrations: Introducing Migration Backup Bundle Fear of doctrine:migrations:migrate during development?

🛡️ Stop breaking your DB with doctrine:migrations:migrate!

Migration Backup Bundle for #Symfony automatically backs up your #MySQL, #PGSQL, or #SQLite right before migrations run.

✅ Auto-backup via --backup flag
✅ Gzip & rotation

🔗 github.com/tito10047/mi...

A Love Letter to Grist My previous company was called Opvia. It was basically Notion, but with stronger guarantees around audit logging and version management, so it was easier to sell into regulated industries. I was pretty proud of a lot of the things I built there, but I wasn’t so okay with the perverse incentives that come with being a SaaS system of record company. Specifically, I was haunted by the question “are we sticky with our customers because we make their lives better than using excel, or are we sticky because once you’ve spent all this time getting data into the system in a nice relational way, and it’s a massive pain to get the data out again?” After leaving Opvia, I wanted to make something that did all of the same stuff but without the data lock-in and perverse incentives that we had. I had stumbled across the local-first movement, and all the crazy things people were doing with SQLite. In my vision, I wanted something that worked like Excel from my childhood (where you pass around .xls files) but each file contained the whole database. I decided that I would solve the multiplayer story using something like cr-sqlite, and was blissfully naive about the conflict resolution piece. I suppose what I was building in my head was Microsoft Access. Recently, I was browsing around the EMF Camp site and stumbled upon Grist. It is open source and uses sqlite as the file format. I think this is basically what I would have built at the end of that summer, if I was not in danger of running out of money. I suddenly became really excited about this, and told everyone who would listen. It is basically Airtable, but open source and with data sovereignty. Each column directly maps to a column in an sqlite database, and each row to a row. There are a few reserved metadata tables for configuring widgets and views, but if you fetch the .grist file from the cloud server (or grist-static) then you can open it in the sqlite3 CLI and `select * from mytable` will do exactly what you expect. In the last few years I have gone all in on sqlite and local-first (including going to Local-First Conf in Berlin and the local-first devroom at FOSDEM, and even joining the D1 managed sqlite database team at Cloudflare). I was surprised not to see more hype from Grist around local-first. I had stumbled across grist-static (which is a fully in-browser version of Grist that can be hosted on GitHub Pages). I assumed that they were probably doing pretty well against most of the local-first ideals from the paper: ### 1. No spinners: your work at your fingertips If grist-static exists then surely everything can be done in the browser completely offline, right? The future looks like it could be pulled in this direction, but unfortunately that is not the primary architecture right now. As it stands, when you open a Grist document, it fetches the sqlite file from S3 into a server and starts a Python sandbox to serve the backend for your database. If you lose connection then it will show a toast for a second telling you it is in read-only mode before it reconnects. 10 out of 10 for grist-static, but 0 out of 10 for grist-proper. ### 2. Your work is not trapped on one device Everything is done on the server, but you can access it from anywhere and the format that the server stores your work in is the same sqlite .grist file format that you are given when you download the database for local use. 10 out of 10. ### 3. The network is optional 8 out of 10 for grist-static but 0 out of 10 for grist-proper. See point 1. ### 4. Seamless collaboration with your colleagues I haven’t been using grist to collaborate with anyone so far, but it has public projects and you can invite people to your team. They even have a fork and merge ui, which I’m looking for an excuse to play with. Grist also got a bunch of contributions from the French government, so I expect it to work reasonably well for government department sized teams. If I could change anything here, I would make it easier to export a .grist file, edit it in some external program and then use the fork and merge ui to compare changes before overwriting the original on the server. It currently defaults to creating a new document, which is _technically_ nondestructive, but not very satisfying if you have public links that point into the original and you don’t want to break them by archiving it. I get that this kind of reconciliation problem is _extremely hard_ , and an area of ongoing research. I also understand that getting it wrong can be _disastrous_ , so I understand why they’ve done it like they have. A boy can dream though, right? 0 out of 10 for grist-static but 9 out of 10 for grist-proper. ### 5. The Long Now This is the whole fucking deal. I can’t emphasize this enough. This is important especially right now, and especially for people who paid attention in history class. When I got bitten by the local-first bug during my summer after Opvia, it felt like going back to my Freedesktop roots. People were taking principled stances on things, and talking about certain ideals in the same way that Free Software people talk about certain freedoms. This ideal is the place where the two communities overlap. So how does Grist do here? Grist’s backing store and interchange format are .grist files. These are sqlite databases under the hood, which is what your browser uses, and also most iphone and android apps. The sqlite file format is basically infrastructure at this point, and grist uses it in a way that I would have never dreamed of when I was working at Opvia. A .grist file’s database structure closely mirrors what you see in the UI (with some extra book-keeping tables off on the side). Whenever you make a change to your table structure, grist runs ALTER TABLE on the sqlite database to make the change. This means that you can drop into the sqlite3 cli or tableplus and do _whatever you want_ to the underlying data without any grist-specific tooling in sight, and without any fear of data getting silently omitted in the export process. For a multi-tenant system running on top of postgres, this would be unheard of. Really nice. To give another comparison, the other local-first Notion clone that I tried out in my summer off was AFFiNE. It can also run entirely in the browser, and has an offline-capable CRDT-based sync engine. On the surface of it, .grist files and .affine files are both sqlite databases, but .affine’s tables are just a bunch of opaque binary CRDT nonsense. I would not expect to be able to edit a .affine file in any tool other than affine itself. AFFiNE is AGPL licensed, so in theory you can keep it going in the long now. I don’t expect anyone to build a hosting business around it if affine folds though. When I tried to contribute to it, their issue tracker was in a closed linear project, and it was an uphill struggle because I couldn’t see whether my contributions were aligned with their vision at all. It seems like their github issue tracker is more active now, so maybe that changed since then. Grist’s core is Apache licensed. This is a solid license that smells like Internet Infrastructure. Issues are public, and there are a bunch of contributions from external organisations, including the french government. 10 out of 10. ### 6. Security and privacy by default I was in the radical openness camp until Facebook made that deeply unfashionable. I used to keep a public trello board of all of my project ideas (which at some point got moved to airtable and then maybe affine before being abandoned). I’m now I’m starting to build that up again in grist (one day I will build a kanban view that I actually like, I promise). I also have a private database for tracking house things that I share only with people I live with. I do not expect to be served adverts about the contents of either of these databases. Grist also has some fancy row level security things that are enforced server-side, but fundamentally the server needs to be able to read the whole database, and retrofitting end to end encryption into the thing would be quite tricky. [Note: when I shared this post with folks on the grist discord, they mentioned that grist started out as a desktop app with end-to-end encrypted sync. You can still feel those roots in a bunch of places, even though the architecture has changed a lot since then.] 7 out of 10? ### 7. You retain ultimate ownership and control I fundamentally trust Grist to act in my interests more than I trust Airtable or Notion. The fact that a self hosted version is just a single docker command away, and the statically hosted version is so capable, gives me confidence that I will be able to eject onto fly.io if I need to. I would love to say Durable Objects here, but the lack of ability to fetch/post the underlying sqlite backing store for a Durable Object makes some things hard. One thing to note is that widgets are basically iframes, and can point basically anywhere. I didn’t mention it in The Long Now, but I wonder if there might be some scope for golang-style caching proxies, or even a system for vendoring widgets into your .grist file (grist has a jsfiddle-like UI for authoring widgets if you want, and they do get stored in the .grist file). Honestly though, if I lose a couple of widgets over the decades, but my data is in the shape that **I** specified in the UI, it won’t be much work to build replacements. Bonus: if you consider Grist widgets to be apps and Grist to be some data infrastructure/container then maybe it is already approaching the vision that Orion Reed is describing in this post. 10 out of 10 again. ## Conclusion I would not say that Grist has all of the local-first ideals nailed. I don’t think anyone does. I realised as I was using it that the data sovereignty piece is the one that I really care about though, and that is why I am all in on Grist at the moment. I would much rather have Grist with its long-now-proof sqlite storage than AFFiNE with its magical real time sync engine and no trust that I will be able to get my data out in 10 years time.

I finally got around to picking up the blog again: alsuren.github.io/2026/03/09/a-love-letter...

#grist #localfirst #sqlite

Future self - how to corrupt #sqlite

Mount .db, -wal and -shm as separate files. SQLite recreates the WAL on checkpoint - new inode. #docker still points to the old deleted one. Container & host silently drift apart.

Result: corrupted database.

Fix: - /host/db:/container/db
No fix: stress level

Под капотом Beetroot: как я написал менеджер буфера обмена на Tauri v2 и Rust с установщиком 6 МБ Переезд с macOS на Windows для разработчика часто сопровождается болью от потери привычного инструментария. В моем случае решающим стимулом свитчнуться на ПК стала мощная видеокарта. Сейчас мой верный...

Под капотом Beetroot: как я написал менеджер буфера обмена на Tauri v2 и Rust с установщиком 6 МБ Переезд с macOS на Windows д...

#Rust #Tauri #буфер #обмена #SQLite #Windows #API #архитектура #пет-проект

Origin | Interest | Match

Original post on hachyderm.io

Brewlog: Coffee & Agents

My latest #blog outlines how I built a super-niche application for tracking my specialty #coffee brewing and consumption, but also marks some of the most complex work I've done with an agent to date.

Built in #Rust with Axum, backed by #SQlite and with a #TailwindCSS […]

Awakari App

Production query plans without production data Production query plans without production data Radim Marek describes the new pg_restore_relation_stats() and pg_restore_attribute_stats() functions th...

#databases #postgresql #sql #sqlite #d-richard-hipp

Origin | Interest | Match

Гит в Телеграм? На своем тг-канале я предлагаю подписчикам выбор, какую бредовую идею запилить следующей. На...

#Telegram #бот #Git #Python #aiogram #SQLite #git #в #telegram #.gitignore

Origin | Interest | Match

メモ参照制限機能の勉強をしていて、とりあえず何とか正常モードは動いたものの、エラー画面の検証をするとNotFoundになってしまい、自分が作成した404エラー画面が出てきませんでした。

色々調べた結果、本と異なるプログラムを追加して正常に動作するように。

SQLiteもデータにゴミが入ると、色々初期化などをしないといけないので、こちらも本ではMiniConda前提なので、コマンドプロンプト用に覚え直してメモにまとめます。

#Python
#Flask
#SQLite
#非エンジニア
#プログラム初心者