Since SQLite supports importing CSV, here's a one-liner to convert a CSV file from stdin into a Markdown table:
sqlite3 :memory: -cmd ".mode csv" -cmd ".import /dev/stdin t" -cmd ".mode markdown" "SELECT * FROM t;"
Bobby 50.0.0 is out!
just some small fixes: bumped the runtime to #GNOME 50. added a keyboard shortcut for Copy Row (Ctrl+C) and fixed the missing border between title and table.
https://flathub.org/en/apps/studio.planetpeanut.Bobby
#linux #gnome #flatpak #flathub #sql #sqlite #database #OpenSource
БАЗЫ ДАННЫХ db. SQL, REDIS, СУБД
Если серьезно, то сегодня мы поговорим про БАЗЫ данных. Как-то один мой друг разработчик сказал, что программирование можно понимать как
JavaScript/TypeScript ecosystem has a huge problem with database connectors and typing.
Is Bigserial bigint, string or number? Is string "2026-04-13" allowed to `Date` field? How about should the `timestamptz` return +03 or UTC result? Your guess is as good as mine, and each version seems to have whole new ideas.
Duckdb and SQLite adapters seems to be most flakiest.
Postgres is most stable.
[pgmicro - SQLite 기반으로 만든 인-프로세스 PostgreSQL
pgmicro는 SQLite 바이트코드 위에서 동작하는 인-프로세스 PostgreSQL로, PostgreSQL SQL을 SQLite 기반으로 직접 컴파일해 인메모리 임베디드 DB로 제공한다. AI 에이전트 환경에서 늘어나는 짧은 수명·소규모 데이터베이스 수요를 겨냥했으며, Turso의 SQLite 재구현체와 PostgreSQL 파서(libpg_query)를 사용해 구문 호환성을 확보했다. 생성 결과는 표준 SQLite .db 형식으로 저장되어 기존 SQLite 도구로도 다룰 수 있고, 연결 수준에서 PostgreSQL/SQLite 문법을 동적으로 전환할 수 있다.
I finally finished writing my blog post on using Dapper for handling Vector data types. But I also had a flash of inspiration so I also went off down a rabbit hole a bit with FluentMigrator and sqlite-vec
But, I had fun writing it, which I've been missing for a while, so this I'm happy
It’s been a while since I did something a little bit more fun with C# and DotNet (DROP THE DOT ✊), so I wanted to look at something I’d come across recently with one of the applications I help build, maintain, and deploy at work, lovingly named “Vogon” (because Hitchhiker’s Guide to the Galaxy is everything). I’m not normally one for using Object Relational Mappers (ORMs), mostly because I know what SQL I want to write and tools like Entity Framework don’t let me customise as much as I want to, or at least not without jumping through lots of hoops and wasting time. But… the application does do a lot of reading and writing data, and then mapping the results to and from C# classes. So I relented a little and went half-way by using the Micro-ORM Dapper.
(more Linux and FOSS news in previous posts of thread)
Zed Editor launches Agent Metrics, offering public AI agent usage data:
https://alternativeto.net/news/2026/4/zed-editor-launches-agent-metrics-offering-public-ai-agent-usage-data/
Immich 2.7 adds duplicate resolution, editor shortcuts, new web actions, and much more:
https://alternativeto.net/news/2026/4/immich-2-7-adds-duplicate-resolution-editor-shortcuts-new-web-actions-and-much-more/
SQLite 3.53 fixes WAL-reset bug, adds QRF library, new SQL features, improved CLI and more:
https://alternativeto.net/news/2026/4/sqlite-3-53-fixes-wal-reset-bug-adds-qrf-library-new-sql-features-improved-cli-and-more/
GNU nano 9.0 CLI Text Editor Released with New Features and Improvements:
https://9to5linux.com/gnu-nano-9-0-cli-text-editor-released-with-new-features-and-improvements
Microsoft has terminated developer accounts of VeraCrypt, WireGuard & Windscribe software:
https://alternativeto.net/news/2026/4/microsoft-has-terminated-developer-accounts-of-veracrypt-wireguard-and-windscribe-software/
(It was only by accident, right, Microsoft? RIGHT??)
FosseryWeb progress report:
I regenerated the HTML cheatsheets using the new page-builders tool, and fixed a lot of bugs/mistakes. Now I'm working on regenerating the JavaScript cheatsheets.
https://fosseryweb.codeberg.page/@beta/cheatsheets/
https://fosseryweb-min.codeberg.page/@beta/cheatsheets/
Vulkan 1.4.349 Released With Data Graph Optical Flow Extension:
https://www.phoronix.com/news/Vulkan-1.4.349
Hugging Face Contributes Safetensors To PyTorch Foundation To Secure AI Model Execution:
https://www.phoronix.com/news/PyTorch-Safetensors
Godot gets a funding boost from Slay the Spire 2 devs Mega Crit:
https://www.gamingonlinux.com/2026/04/godot-gets-a-funding-boost-from-slay-the-spire-2-devs-mega-crit/
Legendary, the free and open source Epic Games Launcher, has moved to a new organisation:
https://www.gamingonlinux.com/2026/04/legendary-the-free-and-open-source-epic-games-launcher-has-moved-to-a-new-organisation/
Raspberry Pi Imager 2.0.8 Released with Fastboot Improvements, Bug Fixes:
https://9to5linux.com/raspberry-pi-imager-2-0-8-released-with-fastboot-improvements-bug-fixes
Redox OS Establishes AI Policy To Forbid Contributions Made Using LLMs:
https://www.phoronix.com/news/Redox-OS-March-2026
NetBSD 11.0 Nears Release With RC3 Released For Testing:
https://www.phoronix.com/news/NetBSD-11.0-RC3
Intel Releases OpenVINO 2026.1 With Backend For Llama.cpp, New Hardware Support:
https://www.phoronix.com/news/OpenVINO-2026.1-Released
#WeeklyNews #OpenSource #FOSSNews #OpenSourceNews #FOSS #News #Zed #Immich #SQLite #GNUNano #FosseryWeb #FosseryWebMin #Vulkan #AI #ArtificialIntelligence #HuggingFace #GodotEngine #Godot #RaspberryPIImager #RedoxOS #NetBSD #OpenVINO #Llamacpp #PyTorch #DBMS #SelfHosting #Development #IDE #CodeEditor #TextEditor #Programming #Dev #BSD #FosseryTech
Episode 12 of Dark Blue Weekly released
https://darkblueproject.com/sites/news/dbw-e12.php
#darkblueweekly #darkblueproject #linux #opensource #freesoftware #trisquel #gparted #debian #nanoeditor #sqlite
Я собрал все медицинские данные семьи в одном сервисе и подключил Claude Opus. Рассказываю что из этого вышло
У каждого из нас лежат где-то результаты анализов, выписки, заключения врачей. У кого-то в папке, у кого-то фотками на телефоне, у кого-то вообще потеряны. Мы их сдаём, получаем и забываем. А потом приходим к новому врачу и не можем ответить на простой вопрос: «Когда последний раз проверяли щитовидку?» Я собрал всё в одном месте и дал нейросети посмотреть на это целиком. Она нашла анализы которые не назначали годами, противоречия между врачами и составила план чекапа на 35 пунктов, который полностью покрылся моим ДМС. Внутри: как это устроено, сколько стоит ($0.60 за полный анализ), и почему я теперь не пойду к врачу без подготовки. Как устроен сервис
https://habr.com/ru/articles/1022450/
#AI #Claude #медицина #PWA #SQLite #React #WebAuthn #petproject #здоровье #open_source
Привет, Хабр. В прошлых статьях рассказывал про Telegram-бота на Gemini и внедрение AI во все поля ввода Windows . Сегодня история другая: личная, экспериментальная. Я написал медицинский сервис для...
New version of #SQLite released:
https://www.sqlite.org/releaselog/3_53_0.html
Looking forward to trying out the new Query Result Formatter. Plus, the ALTER TABLE changes look useful.
I stand by my personal theory that this, and #PostgreSQL, are the only databases you'll ever need for anything.
Dmitry Chestnykh ☮️
Hylke Bons 🥜
Habr
Jari Pennanen
sayzard
dazfuller 
Fossery Tech 
Dark Blue Project
Nigel Small