#sqlite — Public Fediverse posts

Local-first web dnes neznamená jednu architekturu, ale několik různých kompromisů: lokální databázi v prohlížeči, repliku čtení z PostgreSQL nebo CRDT model pro souběžné úpravy. Každý přístup posouvá data blíž k uživateli, ale zároveň přidává nové otázky kolem persistence, konfliktů, autorizace a provozu.

Эволюция Telegram‑бота на C++: от «лапши» в main() до ООП, in‑memory кэша и мутов по Фибоначчи

Привет, Хабр! В этой статье я расскажу об эволюции моего проекта — GroupModerBot , бота для модерации Telegram‑групп. Я покажу, как проект прошел путь от первой версии «всё в одном файле» до продуманной архитектуры с ООП, in‑memory кэшированием, безопасным выполнением команд и нестандартными алгоритмами наказаний пользователей.

https://habr.com/ru/articles/1039564/

#c++ #c++20 #sqlite #telegram #telegram_bot #кэширование #модерирование #рефакторинг #бот #open_source

Эволюция Telegram‑бота на C++: от «лапши» в main() до ООП, in‑memory кэша и мутов по Фибоначчи

Привет, Хабр! В этой статье я расскажу об эволюции моего проекта — GroupModerBot , бота для модерации Telegram‑групп. Я покажу, как проект прошел путь от первой версии «всё в одном файле» до продуманной архитектуры с ООП, in‑memory кэшированием, безопасным выполнением команд и нестандартными алгоритмами наказаний пользователей.

https://habr.com/ru/articles/1039564/

#c++ #c++20 #sqlite #telegram #telegram_bot #кэширование #модерирование #рефакторинг #бот #open_source

Эволюция Telegram‑бота на C++: от «лапши» в main() до ООП, in‑memory кэша и мутов по Фибоначчи

Привет, Хабр! В этой статье я расскажу об эволюции моего проекта — GroupModerBot , бота для модерации Telegram‑групп. Я покажу, как проект прошел путь от первой версии «всё в одном файле» до продуманной архитектуры с ООП, in‑memory кэшированием, безопасным выполнением команд и нестандартными алгоритмами наказаний пользователей.

https://habr.com/ru/articles/1039564/

#c++ #c++20 #sqlite #telegram #telegram_bot #кэширование #модерирование #рефакторинг #бот #open_source

Эволюция Telegram‑бота на C++: от «лапши» в main() до ООП, in‑memory кэша и мутов по Фибоначчи

Привет, Хабр! В этой статье я расскажу об эволюции моего проекта — GroupModerBot , бота для модерации Telegram‑групп. Я покажу, как проект прошел путь от первой версии «всё в одном файле» до продуманной архитектуры с ООП, in‑memory кэшированием, безопасным выполнением команд и нестандартными алгоритмами наказаний пользователей.

https://habr.com/ru/articles/1039564/

#c++ #c++20 #sqlite #telegram #telegram_bot #кэширование #модерирование #рефакторинг #бот #open_source

Hi folks! ✌️

Here's a little app that I've made for this one day.

👉 https://codeberg.org/xolatgames/BYSU

It will help you to create backups of your games' saves.

It has ugly, but workable GUI, and let you create a "backups' list" for multiple games.

Then you will need to push "Create backups!" button, and then your backups was be made.

Thanks for reading, and I will see you in the next time! 😉👋✌️

#backups #imgui #sdl #sdl3 #cpp #cplusplus #cmake #opensource #sqlite #sqlite3 #app #apps #soft #software

Hi folks! ✌️

Here's a little app that I've made for this one day.

👉 https://codeberg.org/xolatgames/BYSU

It will help you to create backups of your games' saves.

It has ugly, but workable GUI, and let you create a "backups' list" for multiple games.

Then you will need to push "Create backups!" button, and then your backups was be made.

Thanks for reading, and I will see you in the next time! 😉👋✌️

#backups #imgui #sdl #sdl3 #cpp #cplusplus #cmake #opensource #sqlite #sqlite3 #app #apps #soft #software

I've discovered LaurieWired's great Youtube channel, and I wish she was here on the #fediverse. There's a bot account which mirrors her posts on x.com (@lauriewired), but that's not the same.
My fav vid of hers, which I 100% agree with (it's the sort of video I'd make myself):
"Your iPhone is Lying to You About Files...":
https://www.youtube.com/watch?v=tnPAhVxsPHE
Her jailbroken #iPad was especially awesome, with the cute Hatsune Mikus. 😊
#Apple #iPhone #iOS #iPadOS #sqlite

Today I worked on my pet project a little more, a custom (DIY) air quality sensor network with no internet access

I added several wishlist items (features) recently to the project but that list is growing too fast, so today was about making a dent in them

So, I changed how my web page summarizes a day of metrics. Attached to this post is the before/after in screenshots.

I’m really impressed that SQLite can handle all of this

See here at v2.1.7:
https://github.com/GuillaumeRossolini/griotte

#DiyAirQualityMonitor #sqlite #mesh #arduino #RaspberryPi

#Roundcube 1.6.16 ( #LTS ) has been released ( #Webmail / #Mail / #IMAP / #SMTP / #LDAP / #Managesieve / #PHP / #MariaDB / #MySQL / #PostgreSQL / #SQLite / #OracleDB / #MSSQL / #LongTermSupport / #CVE / #SecurityVulnerability ) https://roundcube.net/

#Roundcube 1.6.16 ( #LTS ) has been released ( #Webmail / #Mail / #IMAP / #SMTP / #LDAP / #Managesieve / #PHP / #MariaDB / #MySQL / #PostgreSQL / #SQLite / #OracleDB / #MSSQL / #LongTermSupport / #CVE / #SecurityVulnerability ) https://roundcube.net/

#Roundcube 1.6.16 ( #LTS ) has been released ( #Webmail / #Mail / #IMAP / #SMTP / #LDAP / #Managesieve / #PHP / #MariaDB / #MySQL / #PostgreSQL / #SQLite / #OracleDB / #MSSQL / #LongTermSupport / #CVE / #SecurityVulnerability ) https://roundcube.net/

#Roundcube 1.6.16 ( #LTS ) has been released ( #Webmail / #Mail / #IMAP / #SMTP / #LDAP / #Managesieve / #PHP / #MariaDB / #MySQL / #PostgreSQL / #SQLite / #OracleDB / #MSSQL / #LongTermSupport / #CVE / #SecurityVulnerability ) https://roundcube.net/

#Roundcube 1.7.1 (stable) has been released ( #Webmail / #Mail / #IMAP / #SMTP / #LDAP / #Managesieve / #PHP / #MariaDB / #MySQL / #PostgreSQL / #SQLite / #OracleDB / #MSSQL / #CVE / #SecurityVulnerability ) https://roundcube.net/

#Roundcube 1.7.1 (stable) has been released ( #Webmail / #Mail / #IMAP / #SMTP / #LDAP / #Managesieve / #PHP / #MariaDB / #MySQL / #PostgreSQL / #SQLite / #OracleDB / #MSSQL / #CVE / #SecurityVulnerability ) https://roundcube.net/

#Roundcube 1.7.1 (stable) has been released ( #Webmail / #Mail / #IMAP / #SMTP / #LDAP / #Managesieve / #PHP / #MariaDB / #MySQL / #PostgreSQL / #SQLite / #OracleDB / #MSSQL / #CVE / #SecurityVulnerability ) https://roundcube.net/

#Roundcube 1.7.1 (stable) has been released ( #Webmail / #Mail / #IMAP / #SMTP / #LDAP / #Managesieve / #PHP / #MariaDB / #MySQL / #PostgreSQL / #SQLite / #OracleDB / #MSSQL / #CVE / #SecurityVulnerability ) https://roundcube.net/

@vkc This is awesome stuff!! Guess I've been using a ""writerDeck"" for years and never knew it. On my main work computer that I use on the road nearly every day, I run #tmux in #termux with #vim, #nnn, #sqlite, #syncthing, and a (perty sweet) custom amber glow colourscheme on my phone mounted on the visor in my car with a split-36 keyboard which sits on my knees.

\m/ Outstanding video, thank you! We all need more of this sorta stuff to inspire us.

@vkc This is awesome stuff!! Guess I've been using a ""writerDeck"" for years and never knew it. On my main work computer that I use on the road nearly every day, I run #tmux in #termux with #vim, #nnn, #sqlite, #syncthing, and a (perty sweet) custom amber glow colourscheme on my phone mounted on the visor in my car with a split-36 keyboard which sits on my knees.

\m/ Outstanding video, thank you! We all need more of this sorta stuff to inspire us.

@vkc This is awesome stuff!! Guess I've been using a ""writerDeck"" for years and never knew it. On my main work computer that I use on the road nearly every day, I run #tmux in #termux with #vim, #nnn, #sqlite, #syncthing, and a (perty sweet) custom amber glow colourscheme on my phone mounted on the visor in my car with a split-36 keyboard which sits on my knees.

\m/ Outstanding video, thank you! We all need more of this sorta stuff to inspire us.

@vkc This is awesome stuff!! Guess I've been using a ""writerDeck"" for years and never knew it. On my main work computer that I use on the road nearly every day, I run #tmux in #termux with #vim, #nnn, #sqlite, #syncthing, and a (perty sweet) custom amber glow colourscheme on my phone mounted on the visor in my car with a split-36 keyboard which sits on my knees.

\m/ Outstanding video, thank you! We all need more of this sorta stuff to inspire us.

@vkc This is awesome stuff!! Guess I've been using a ""writerDeck"" for years and never knew it. On my main work computer that I use on the road nearly every day, I run #tmux in #termux with #vim, #nnn, #sqlite, #syncthing, and a (perty sweet) custom amber glow colourscheme on my phone mounted on the visor in my car with a split-36 keyboard which sits on my knees.

\m/ Outstanding video, thank you! We all need more of this sorta stuff to inspire us.

CodeGraph: граф кода для Claude Code вместо grep по файлам. Разбираю архитектуру и проверяю бенчмарки

Если вы работаете с Claude Code на больших проектах, знаете картину: задаёшь вопрос “как устроена авторизация” — и агент рекурсивно бегает по файлам через grep, жжёт токены и время. Я уже разбирал SocratiCode, который решает это через векторный поиск. CodeGraph идёт другим путём — строит граф символов через tree-sitter и хранит в SQLite. Разобрал архитектуру, проверил бенчмарки (92% меньше вызовов — правда, но с нюансами) и сравнил с альтернативами. Заодно поправил телеграм-маркетинг про выдуманного “агента Hermes”.

https://habr.com/ru/articles/1038474/

#Claude_Code #MCP #AIагенты #treesitter #SQLite #индексация_кода #CodeGraph #граф_кода

CodeGraph: граф кода для Claude Code вместо grep по файлам. Разбираю архитектуру и проверяю бенчмарки

Если вы работаете с Claude Code на больших проектах, знаете картину: задаёшь вопрос “как устроена авторизация” — и агент рекурсивно бегает по файлам через grep, жжёт токены и время. Я уже разбирал SocratiCode, который решает это через векторный поиск. CodeGraph идёт другим путём — строит граф символов через tree-sitter и хранит в SQLite. Разобрал архитектуру, проверил бенчмарки (92% меньше вызовов — правда, но с нюансами) и сравнил с альтернативами. Заодно поправил телеграм-маркетинг про выдуманного “агента Hermes”.

https://habr.com/ru/articles/1038474/

#Claude_Code #MCP #AIагенты #treesitter #SQLite #индексация_кода #CodeGraph #граф_кода

CodeGraph: граф кода для Claude Code вместо grep по файлам. Разбираю архитектуру и проверяю бенчмарки

Если вы работаете с Claude Code на больших проектах, знаете картину: задаёшь вопрос “как устроена авторизация” — и агент рекурсивно бегает по файлам через grep, жжёт токены и время. Я уже разбирал SocratiCode, который решает это через векторный поиск. CodeGraph идёт другим путём — строит граф символов через tree-sitter и хранит в SQLite. Разобрал архитектуру, проверил бенчмарки (92% меньше вызовов — правда, но с нюансами) и сравнил с альтернативами. Заодно поправил телеграм-маркетинг про выдуманного “агента Hermes”.

https://habr.com/ru/articles/1038474/

#Claude_Code #MCP #AIагенты #treesitter #SQLite #индексация_кода #CodeGraph #граф_кода

CodeGraph: граф кода для Claude Code вместо grep по файлам. Разбираю архитектуру и проверяю бенчмарки

Если вы работаете с Claude Code на больших проектах, знаете картину: задаёшь вопрос “как устроена авторизация” — и агент рекурсивно бегает по файлам через grep, жжёт токены и время. Я уже разбирал SocratiCode, который решает это через векторный поиск. CodeGraph идёт другим путём — строит граф символов через tree-sitter и хранит в SQLite. Разобрал архитектуру, проверил бенчмарки (92% меньше вызовов — правда, но с нюансами) и сравнил с альтернативами. Заодно поправил телеграм-маркетинг про выдуманного “агента Hermes”.

https://habr.com/ru/articles/1038474/

#Claude_Code #MCP #AIагенты #treesitter #SQLite #индексация_кода #CodeGraph #граф_кода

sqlite with its totally normal code of ethics

https://sqlite.org/codeofethics.html

#sqlite #sql

sqlite with its totally normal code of ethics

https://sqlite.org/codeofethics.html

#sqlite #sql

sqlite with its totally normal code of ethics

https://sqlite.org/codeofethics.html

#sqlite #sql

sqlite with its totally normal code of ethics

https://sqlite.org/codeofethics.html

#sqlite #sql

sqlite with its totally normal code of ethics

https://sqlite.org/codeofethics.html

#sqlite #sql

Started learning #rust using the #anki card provided by this repo

he also has flash cards for #c, #sqlite, #lua and few more

https://github.com/ad-si/Coding-Flashcards

Started learning #rust using the #anki card provided by this repo

he also has flash cards for #c, #sqlite, #lua and few more

https://github.com/ad-si/Coding-Flashcards

Started learning #rust using the #anki card provided by this repo

he also has flash cards for #c, #sqlite, #lua and few more

https://github.com/ad-si/Coding-Flashcards

Started learning #rust using the #anki card provided by this repo

he also has flash cards for #c, #sqlite, #lua and few more

https://github.com/ad-si/Coding-Flashcards

Datasette Agent: Database exploration tool now has a thoughtful AI integration with SQL-aware agent tools
https://agent.datasette.io/
#datasette #sqlite #simonw #agent #rag #ai #+

Datasette Agent: Database exploration tool now has a thoughtful AI integration with SQL-aware agent tools
https://agent.datasette.io/
#datasette #sqlite #simonw #agent #rag #ai #+

Datasette Agent: Database exploration tool now has a thoughtful AI integration with SQL-aware agent tools
https://agent.datasette.io/
#datasette #sqlite #simonw #agent #rag #ai #+

Datasette Agent: Database exploration tool now has a thoughtful AI integration with SQL-aware agent tools
https://agent.datasette.io/
#datasette #sqlite #simonw #agent #rag #ai #+

Released 0.2.0 of dj-lite-tenant, a way to automatically create and use multi-tenant #SQLite databases with #Django.

This release doesn't change anything fundamental, it was more focused on stability. Added benchmarks, load tests, and concurrency tests to ensure that multi-tenant databases are isolated and performant.

https://pypi.org/project/dj-lite-tenant/
https://github.com/adamghill/dj-lite-tenant

Released 0.2.0 of dj-lite-tenant, a way to automatically create and use multi-tenant #SQLite databases with #Django.

This release doesn't change anything fundamental, it was more focused on stability. Added benchmarks, load tests, and concurrency tests to ensure that multi-tenant databases are isolated and performant.

https://pypi.org/project/dj-lite-tenant/
https://github.com/adamghill/dj-lite-tenant

Released 0.2.0 of dj-lite-tenant, a way to automatically create and use multi-tenant #SQLite databases with #Django.

This release doesn't change anything fundamental, it was more focused on stability. Added benchmarks, load tests, and concurrency tests to ensure that multi-tenant databases are isolated and performant.

https://pypi.org/project/dj-lite-tenant/
https://github.com/adamghill/dj-lite-tenant

Released 0.2.0 of dj-lite-tenant, a way to automatically create and use multi-tenant #SQLite databases with #Django.

This release doesn't change anything fundamental, it was more focused on stability. Added benchmarks, load tests, and concurrency tests to ensure that multi-tenant databases are isolated and performant.

https://pypi.org/project/dj-lite-tenant/
https://github.com/adamghill/dj-lite-tenant

Released 0.2.0 of dj-lite-tenant, a way to automatically create and use multi-tenant #SQLite databases with #Django.

This release doesn't change anything fundamental, it was more focused on stability. Added benchmarks, load tests, and concurrency tests to ensure that multi-tenant databases are isolated and performant.

https://pypi.org/project/dj-lite-tenant/
https://github.com/adamghill/dj-lite-tenant

My backup includes the #HomeAssistant DB.

On the one hand, I don't want to lose it in case of an accident - it contains a lot of state, history, and configuration.

On the other, it's the largest daily churn and not really suitable to incremental backup.

Has anyone build better backup/restore for #SQLite, perhaps with #kopia?

My backup includes the #HomeAssistant DB.

On the one hand, I don't want to lose it in case of an accident - it contains a lot of state, history, and configuration.

On the other, it's the largest daily churn and not really suitable to incremental backup.

Has anyone build better backup/restore for #SQLite, perhaps with #kopia?

My backup includes the #HomeAssistant DB.

On the one hand, I don't want to lose it in case of an accident - it contains a lot of state, history, and configuration.

On the other, it's the largest daily churn and not really suitable to incremental backup.

Has anyone build better backup/restore for #SQLite, perhaps with #kopia?

My backup includes the #HomeAssistant DB.

On the one hand, I don't want to lose it in case of an accident - it contains a lot of state, history, and configuration.

On the other, it's the largest daily churn and not really suitable to incremental backup.

Has anyone build better backup/restore for #SQLite, perhaps with #kopia?

My backup includes the #HomeAssistant DB.

On the one hand, I don't want to lose it in case of an accident - it contains a lot of state, history, and configuration.

On the other, it's the largest daily churn and not really suitable to incremental backup.

Has anyone build better backup/restore for #SQLite, perhaps with #kopia?

Ex Google CEO #EricSchmidt: "the era of 'writing code' line by line is officially over"

http://timesofindia.indiatimes.com/articleshow/131120614.cms?utm_source=contentofinterest&utm_medium=text&utm_campaign=cppst

I'm using ChatGPT as a high level architect and Codex as the coder to migrate a #Reticulum Bluetooth interface from Python to C++. I'm just the middle manager providing apparatus and machines for testing. Using #Forgejo and #Sqlite to track and document. This is really fun and productive as all get-out! Maybe I should not have ducked the management career path at Oracle?