Turso SQLite Offline Sync Public Beta
turso.techOffline Sync Public Beta
#sqlite
12 posts11 participants0 posts today
Turso SQLite Offline Sync Public Beta
turso.techOffline Sync Public Beta
Дистанционное управление шлагбаумом с помощью MTC Exolve и GSM модуля
Несмотря на то, что я системный аналитик, проклятие, которое начинается с фразы «тыж программист…», иногда преследует и меня. Недавно у меня спросили совета, как сделать так, чтобы для нужных людей шлагбаум удаленно открывался без транспондера и сложных систем. К сожалению, сходу я не придумал ответа на вопрос, но задачка показалась мне любопытной, и я немного изучил вопрос. Решение нашёл быстро — в качестве аппаратной части можно использовать GSM-реле, а контроль доступа реализовать с помощью микро сервиса для переадресации вызова. И поскольку у меня наличествовал тестовый доступ к
ХабрДистанционное управление шлагбаумом с помощью MTC Exolve и GSM модуляНесмотря на то, что я системный аналитик, проклятие, которое начинается с фразы «тыж программист…», иногда преследует и меня. Недавно у меня спросили совета, как сделать так, чтобы для нужных...
Continued thread
I updated a bunch of stuff in the project, especially split the single database that was getting way too big for SQLite + microSD to handle gracefully (more than 30s) and I updated the README with new screenshots
I’m now storing my sensor readings in two database files:
- the big one that I’ve been using from the start, but not using any more
- a new one that gets created each day, and that’s the one that the graphs are now using
This way, the daily databases are kept small, which makes querying them fast (mostly for the pretty graphs), and I also still have a giant single database for offline statistics (should I need that)
TIL that #SQLite provides virtual columns (computed from othercolumns) and right now that's a lifesaver.
GitHub - splitbrain/meh: Meh... another comment system https://github.com/splitbrain/meh #alternative #integration #OpenSource #comments #mastodon #node.js #website #GitHub #sqlite #static #blog #PHP
GitHubGitHub - splitbrain/meh: Meh... another comment systemMeh... another comment system. Contribute to splitbrain/meh development by creating an account on GitHub.
Anyone know if it’s possible to migrate a #SQLite @forgejo #forgejo database to #PostgreSQL or #MySQL?
I always knew #SQLite was kind of unhinged, but I had *no idea how much* until I read this list.
"14. SQLite is so fast, they compete with fopen. For some use cases, you can use SQLite instead of a filesystem, that can be 35% faster."
avi.imCollection of insane and fun facts about SQLite - blagSome of the interesting and insane facts I learned about SQLite
DBeaver — Universal Database Tool — https://dbeaver.io/ #mysql #mariadb #sql #sqlite #erd #postgresql #database
dbeaver.ioDBeaver Community | Free Universal Database Tool
Leanpub book LAUNCH! Northwind Elixir Traders: Learn Elixir and database modeling with Ecto and SQLite, all in one project by Isaak Tsalicoglou https://youtu.be/LtzBS9hb1Go #books #leanpublishing #selfpublishing #booklaunch #ElixirLang #FunctionalProgramming #IndieHacker #Ecto #SQLite #SoftwareDevelopment #OpenSource #FullStackDev #LearnToCode #LeanpubPodcast
NEW! A Leanpub Frontmatter Podcast Interview with Isaak Tsalicoglou, Author of Northwind Elixir Traders: Learn Elixir and database modeling with Ecto and SQLite, all in one project | Watch here: https://youtu.be/zeUVFt82UG4 #books #ElixirLang #FunctionalProgramming #IndieHacker #Ecto #SQLite #SoftwareDevelopment #OpenSource #FullStackDev #LearnToCode #LeanpubPodcast
Today I hate #SQLite deeply. The idea of having a single point of failure for your entire data is absurd. This marks the third time I have to configure from scratch my endpoints in #UptimeKuma
The #turso implementation of #sqlite keeps getting better. I've built sync engines before. Very much know the complexity enough to choosing NOT do it all myself. 
https://turso.tech/blog/local-first-cloud-connected-sqlite-with-turso-embedded-replicas
turso.techLocal-First SQLite, Cloud-Connected with Turso Embedded ReplicasDiscover how Turso's Embedded Replicas deliver microsecond SQLite reads with cloud sync. Build faster, more resilient applications for mobile, edge, and AI with zero-latency local access and automatic data sync - no complex caching required.
Performing group_concat queries over distinct values, with a custom delimiter, with SQLite
How to avoid SQLite's `DISTINCT aggregates must have exactly one argument` error when performing a `group_concat(distinct ...)` with a custom delimiter.https://fed.brid.gy/r/https://www.jvt.me/posts/2025/03/25/sqlite-distinct-group-concat/
I'm a database extremist. I default to #SQLite for pretty much anything.
As an independent software consultant, I need time tracking and CRM like anyone else. Guess what? It's just a single SQLite database file. :D Has worked wonderfully for years using just a database viewer app. (Tableplus, if you're wondering.)
But now, with this wonderful tool from Rune Kaagaard, I can hook up my database to Anthropic's Claude, and get insights into my time spent as well as my connections, just by chatting with Claude Sonnet 3.7.
Wild! :D
GitHubGitHub - runekaagaard/mcp-alchemy: A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL. - runekaagaard/mcp-alchemy
I know I should have used #sqlite instead of #postgresql it's just overkill for my needs my instance is going to be single user anyways
Video: Creating an #SQLite database with tables and foreign key relationships.
https://www.youtube.com/watch?v=w88NySp6Ydk
#MySQL
#MariaDB
#SQLServer
#Oracle
#Firebird
#InterBase
#PostgreSQL
#NexusDB
#databasetools #databasedevelopment #DatabaseWorkbench
Replied in thread
Anyone using #litestream for an #sqlite DB
I have a 3GB database, and Litestream is replicating it to another server. However, it seems to be running out of control with disk space. On the original server (where the live DB is) is a generations folder under the hidden litestream folder. It is full of WAL files. Currently over 37,000 files consuming 118GB of disk space.
My config includes retention: 24h and retention-check-interval: 1h with a snapshot-interval: 4h. I understood it would delete anything older than 24 hours. Am I doing something wrong? These wal files go back to the day I started using litestream
#GoToSocial #gts @gotosocial@thefedi.forum
Which can actually give some performance improvements on postgres.