Kev built his own microblog using WordPress and iOS shortcuts to separate his long and short posts. It sounds like this is a better alternative for him than micro.blog. Maybe with SQLite as the database he can even simplify this setup. ⌘ Read more

WordPress with SQLite
Philipp’s recent post on WordPress with SQLite reminded me to give the migration of a site I maintain for someone else a second try. ⌘ Read more

WordPress with SQLite
Philipp’s recent post on WordPress with SQLite reminded me to give the migration of a site I maintain for someone else a second try. ⌘ Read more

Tests usually cannot prove absence of defects. But they can show presence of defects I found a bug in SQLite | Hacker News

WordPress implemented SQLite support! 😱 (Not merged into Core yet, but you’re able to test it.) ⌘ Read more

WordPress implemented SQLite support! 😱 (Not merged into Core yet, but you’re able to test it.) ⌘ Read more

https://emacsconf.org/2022/talks/sqlite/ database

All the scripts on my Gemini capsule (except chess) have now been rewritten using Python and storing data in a SQLite database. This is the first time I’ve ever worked with database in a “production” environment, and I’m inordinately excited.

sqlite3 fiddle
With all my SQL and SQLite posts, this link is probably also quite interesting: sqlite3 fiddle. ⌘ Read more

“Friendlier SQL with DuckDB”
I come into contact with SQL almost every day, be it at work (Oracle Database) or while developing my blog software (SQLite). I don’t find SQL as bad as some others might, but sometimes SQL could be better. ⌘ Read more

Containerize go and sqlite with docker
3 points posted by kenny ⌘ Read more

“Consider SQLite”
I am convinced of SQLite. For many use cases where other databases like MySQL, MariaDB or PostgreSQL are often used, SQLite would suffice, given the right design and architecture. ⌘ Read more

rewrite of getwtxt (as getwtxt-ng) is going okay. i’m much happier with sqlite for storage.

GoCN 每日新闻（2021-12-22）

1. 使用 Go 和 SQLite 构建生产应用程序
   
2. 使用 context.Context 模拟 API 客户端https://incident.io/blog/golang-client-mocks
   
3. 一种可嵌入的 Go 脚本语言,实现了逻辑编程语言 Prologhttps://github.com/ichiban/prolog
   
4. SSA：终于知道编译器偷摸做了哪些事[https://mp.weixin.qq.com/s/nOhMsMeP1pUFEXKAMUzbWg](https://mp.weixin.qq.com/ … ⌘ Read more

[WIP] Query any data source using SQL, building Presto or AWS Athena alternative
xyr is a very lightweight, simple, and powerful data ETL platform that helps you to query available data sources using SQL.

• Simple Presto Alternative.
  
• Simple AWS Athena Alternative.
  
• Convert your JSON documents into a SQL DB.
  
• Query your CSV files easily and join them with other data.
  

internaly xyr utilizes SQLite as an embeded sql datastore (it may be changed in future and we c … ⌘ Read more

Considering putting my log entries in a SQLite db. Will it fit? I average around 100K of content a month. That gives me a little more than 83 thousand years before I’m even up to a GB… Yeah, it’ll fit.

https://github.com/coleifer/sqlite-web DB python sqlite

https://www.linuxtricks.fr/wiki/sqlite-l-essentiel-sur-cette-base-de-donnees-cli-sql-php BDD sqlite

https://www.sqlitetutorial.net/ bdd documentation sqlite

https://litecli.com/ cli sqlite

https://zestedesavoir.com/tutoriels/1294/des-bases-de-donnees-en-python-avec-sqlite3/ BDD documentation python sqlite

https://sql.sh/ DB documentation sql sqlite

https://www.youtube.com/watch?v=COfSeLoFNH8&feature=youtu.be DB python sqlite

https://dev.to/wsvincent/database-design-tutorial-for-beginners-33p2 DB sql sqlite

https://medium.com/analytics-vidhya/programming-with-databases-in-python-using-sqlite-4cecbef51ab9 numpy pandas python sqlite

https://dgl.cx/2020/06/sqlite-json-support sqlite sqlite

http://www.sqlfacile.com/ DB documentation sqlite

https://pynative.com/python-sqlite/ python sqlite

https://github.com/jisha17/Python-Tkinter-Employee-Management-using-SQLite management python sqlite tkinter

a decentralized community !zet. individual zet feeds could be managed using something like git/git submodules, then built locally into self-contained SQLite files. zet items would be referenced by their zet nickname and UUID. #halfbakedideas

litestream - Streaming S3 replication for SQLite. ⌘ Read more…

user-defined order in SQL [[https://begriffs.com/posts/2018-03-20-user-defined-order.html]] #sql #links maybe something that can be adapted to !sqlite?

huh. it seems that dumping + gzipping a SQLite database can sometimes have better compression than gzipping the SQLite database directly. cool. #sqlite

A fragment of my !monolith program has been woven to a !weewiki from !worgle using !sqlite. Find it for now at [[/proj/monolith/wiki/][the monolith project page]].

!worgle -> !sqlite -> !worgmap -> !weewiki is kinda working?

It turns out that fts5 is enabled by default on SQLite! My twtxt2sqlite generator has been updated to use fts5. Now I can do full text search on all my twtxt tweets. I have implemented a related-tweets box in the !twtxt_playground as a proof-of-concept. More info on fts5 can be found at [[https://www.sqlite.org/fts5.html]].

here is the script I use to convert my twtxt feed into a SQLite database: !twtxt_sqlite

a unique thing I do with my twtxt feed is convert it to a SQLite database. This, combined with the Janet + SQLite scripting abilities available in SQLite, could provide interesting metrics and insights over time.

Posted to Entropy Arbitrage: Small Technology Notes https://john.colagioia.net/blog/2020/02/05/recutils.html #techtips #recutils #linux #sqlite #export

While certainly not a solution to everything, I find I’m using temporary SQLITE database a bunch to solve problems with a few lines of sql and less then 50 lines of code (to insert data into the SQLITE DB) instead of several hundred of lines of code and a bunch of arrays.

Okay, the plan for txtio: Use sqlite to store followings, tweets and config and use ncurses for the ui. Let’s see how that works out.

a nice side effect of all this is that you can reconstruct the data instantly, so my sqlite database can actually be quite volatile