Elektrine
Log in Register

#sqlite

30 posts · Last used 8d

Back to Timeline
upscene
Upscene Productions @upscene@mstdn.business · Jul 30, 2026
Database Workbench 7.0.5 released ✅ #AI Assistant improvements ✅ Improved XML data export ✅ Much faster ODS and XLS data import ✅ Improved Welcome Window Read more ➡️ https://www.upscene.com/news/item/20260722 #Firebird #MySQL #MariaDB #Oracle #PostgreSQL #SQLServer #InterBase #SQLite #NexusDB #databasedevelopment #DatabaseWorkbench #AIDevelopment
0
0
0
toflar
Yanick Witschi @toflar@phpc.social · Jul 30, 2026
🎉 Loupe 1.0 is here! Production-proven full-text search for PHP, powered by SQLite - no containers, daemons or external services. Now with compound-word search and better result excerpts! https://github.com/loupe-php/loupe/releases/tag/1.0.0 #php #sqlite #loupe #search
0
0
0
upscene
Upscene Productions @upscene@mstdn.business · Jul 29, 2026
"Using #AI to Update Audit Triggers After Schema Changes" Generating an audit trigger is only the beginning. As a database evolves, tables change, new columns are added, and existing audit triggers need to evolve with them. This is another area where AI can save developers valuable time. https://www.upscene.com/articles/article/8/ai-to-update-triggers-after-database-schema-changes #databasedevelopment #DatabaseWorkbench #sql #AIDevelopment #sqlite #sqlserver #PostgreSQL #FirebirdSQL #mysql #MariaDB #sqlserver #oracle #InterBase
0
0
0
mort
mort @mort@floss.social · Jul 15, 2026
I wrote a blog post about various annoyances I have with SQLite's defaults, and a suggestion about how it could be fixed: https://mort.coffee/home/sqlite-editions/ TL;DR: SQLite should have a Rust-style edition system which lets us set a whole suite of more sensible defaults with a single 'PRAGMA edition = 2026'. #sqlite #databases #rdbms #embedded
5
0
4
hasamba
hasamba @hasamba@infosec.exchange · Jul 12, 2026
---------------- 🛠️ Tool =================== Third Street Bookmarks is a local-first X/Twitter bookmark reader that keeps your data under your control. The tool runs on your machine, storing read/favorite/label/note state in an app-owned SQLite database at ~/.tsb/state.db. No sync source can reset your personal state, and you can switch between sync providers freely. Key Features The tool provides a dark, X-styled UI for browsing bookmarks with sort, filter, and pagination. Filtering supports multi-select categories, author voice, read/unread status, a "Forgotten Gems" mode, multi-folder favourites, and 7-color labels for visual triage. AI Chat lets you ask natural language questions about your bookmark collection, powered by Claude Code CLI (claude -p) or Codex CLI (codex --full-auto) running locally. No API key is required. Bookmark Podcast generates AI audio digests from your collection, organized by topic, recent bookmarks, or custom prompts, with a real-time waveform visualizer. Voice playback offers three tiers: free browser SpeechSynthesis, ElevenLabs, and Sarvam AI, with a per-card speaker button. Stats provides scrollable analytics including KPIs, timeline charts, category growth by tweet date, engagement leaders, posting hour heatmaps, and top domains. Per-bookmark notes are included in search. Quoted tweets display inline. Sync and Classification Pluggable sync: pull bookmarks from Field Theory CLI (ft sync) or birdclaw (birdclaw sync bookmarks), switchable in the UI. birdclaw unlocks Liked Tweets, Inbox Triage, and AI Digests. Classification runs through classify.py, supporting regex (offline), OpenAI, Claude CLI, or Codex CLI as backends. The content cache lives in bookmarks.json (never committed). The app-owned SQLite at ~/.tsb/state.db is the source of truth for all user actions. Stack: React 18 + Vite frontend, Express.js on port 3456 with better-sqlite3, Python for classification, local CLIs for AI features. Requires Node.js 20+ and Python 3.10+. Note: haven't tested personally. 🔹 tool #bookmarks #localfirst #sqlite #twitter 🔗 Source: https://github.com/mayanksagar26/third-street-bookmarks
0
0
0
upscene
Upscene Productions @upscene@mstdn.business · Jul 08, 2026
Using #AI to speed up your #SQL development: here's how AI can help you. ✨ "The Future of SQL Development Is Database-Aware AI" ✨ https://www.upscene.com/articles/article/4/ai-chatbot-speeds-up-sql-development #DatabaseWorkbench #databasedevelopment #databasetools #MySQL #MariaDB #Firebird #SQLite #PostgreSQL #SQLServer #Oracle #InterBase #NexusDB
0
0
0
upscene
Upscene Productions @upscene@mstdn.business · Jul 06, 2026
Database Workbench 7, now available! ✅ AI powered SQL development ✨ ✅ user interface improvements including a "dark mode" & new Welcome Window ✅ new data import and export features, including templates ✅ ability to export custom reports to file ✅ new and improved database backup functionality Supports #MySQL #MariaDB #Firebird, #SQLite #PostgreSQL #SQLServer #Oracle #InterBase #NexusDB, all from one consistent user interface! https://www.upscene.com/database-workbench/whatsnew
0
0
0