@cybertailor
Очень рекомендую эту статью:
https://remusao.github.io/posts/few-tips-sqlite-perf.html

#SQLite3 #Python

More Perl hacking to analyse the gopher log files - gotta love SQLite! Anyways, early analysis of February this year (so far) reflects what's on peoples' minds. In case you're wondering Epstein-related stuff is at 49 visits... I'm developing the reporting as we speak...

#gopher #gopherprotocol #Perl #sqlite3

Is there a good sql query builder library for #ruby for chainable wheres?

I've got a ~1000 line toy project that I spurted out this week as an exercise in building a web application with minimal dependencies, and right now it's just #rack, #puma, and #sqlite3...

I've spent too much time database wrangling, and I don't _mind_ that but would like something light-and-tight that is small enough I can read most of the code in an afternoon...

Mostly what I really want is something to make chainable where statements 😅

I started looking at both #ROM and #Sequel both do A Lot.

#RubyLang #Programming #AskFedi

One Open-source Project Daily

a Disqus alternative

https://github.com/isso-comments/isso

#1ospd #opensource #commenting #disqus #javascript #selfhosted #sqlite3

Gotosocial有点傻福了，Apple也是傻福，我更是傻福

已解决 Solved

https://docs.gotosocial.org/configuration/

我开启注册后，决定尝试申请注册admin@gts.feddit.social，第一个蠢事来了。

1. iCloud过期，收不到邮件
   我的apple icloud早就爆满了，5G的空间大小塞了47GB的图片视频（icloud+订阅过期了），所以自从11月16号，我的icloud就没有接受过邮件了。
   当我清理完图片，又发现邮件没有像deepseek所说那样在存储恢复后受到邮件，好，白清空了，所以我需要去清理admin和我的xxx@icloud.com邮件。

2. 通过清理数据库来删除admin和xxx@icloud.com邮件
   因为我没有办法验证这个邮件地址，所以就算我接受了这个账户，也无法登陆它。
   我需要完全清除，再重新注册。

cd data
sudo apt update && apt install sqlite3
cp sqlite.db sqlite.db.bak
sqlite3 sqlite.db

SELECT id, username FROM accounts WHERE username = 'admin';

# 查看这三个 admin 账户的完整信息
SELECT a.id, a.username, a.created_at, a.uri, 
       u.id as user_id, u.email, u.admin, u.moderator, u.disabled
FROM accounts a 
LEFT JOIN users u ON u.account_id = a.id 
WHERE a.username = 'admin';
# 找到本地admin而不是其他实例的admin，要一起执行

DELETE FROM users WHERE account_id = 'xxx';
DELETE FROM accounts WHERE id = 'xxx';

SELECT id, username FROM accounts WHERE username = 'admin';

.quit

docker compse down
docker compose up -d

再次注册，然后在Mail上验证邮件，管理员批准admin

1. 更傻福的来了

在那个批准界面，approve后，我看见suspended的提示，我也没多想就直接确实suspended了，然后才发现suspended让账户不可登陆，不可撤销。
我就需要用./gotosocial CLI去取消suspended，目前发现好像就算取消suspended了，只会有个gts.feddit.social/@admin，后段管理和webui是无法登陆的，我是个傻福，我需要再次进行第二步操作了。

等我好消息。

#gotosocial #mastodon #admin #sysadmin #icloud #apple #socialmedia #db #sqlite #ssh #mail #suspend #sqlite3

Пишем Telegram-бота на Python: прикручиваем оплату Telegram Stars, систему промокодов и OpenAI

Привет, Хабр! В качестве пет-проекта для работы с API и базами данных решил написать своего бота-ассистента. Идея простая: прокси к OpenAI, но с нюансами: хотел разобраться, как работать с относительно новой внутренней валютой Telegram Stars, реализовать собственную систему промокодов и админку без использования громоздких фреймворков, оставаясь на библиотеке telebot (pyTelegramBotAPI).

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

#python #openai_api #telegram_bot #api #telegram_stars #github #sqlite3

I built a side-project. I used #PostgreSQL to preserve state. I'm coming to regret that decision. When I deployed, I had to boot up a PG cluster, and now I have to worry about backups (the data is important).

My only worry is full-text search and storing XML in the database (less structured data).

I should have just used #sqlite3.

Luckily, I deployed to bare-metal, so I can change my mind quite quickly.

gracias al tecnologico de cuautla, les comparti el curso de yii2 y base de datos, diseño de base de datos en diferentes motores de bd, todo con software libre y linux, durante cinco dias ... #tecnm #dia #parsediasql #postgresql #sqlite3 #mariadb https://vt.tiktok.com/ZSf12m9b2/

🛢️ FilesSQL - драйвер #SQL для прямих запитів до файлів даних без попереднього імпорту. Підтримує CSV, TSV, LTSV, Parquet та Excel файли з використанням синтаксису #SQLite3.

🔗 https://github.com/nao1215/filesql

Second new: I decided to fully recode "Crisps Chat 🍟" On my opinion - that was a dirty code.

It's a long story, alas...

The recoded version is located here 👉 https://codeberg.org/xolatgames/Crisps-Chat-Recoding

I wish you a nice, and a cool day! ✌️😜

#cpp #cplusplus #app #apps #soft #software #imgui #sdl #sdl2 #messaging #sqlite #sqlite3 #communication #opensource #codeberg #git #cmake #make #makefile #application #applications #linux #DearImGui #messages #chat #chatting #chats

#Golang is elegant

also: #sqlite3

yes, I'm an engineer

EDIT: this problem was fixed using trim() on the variable.

Need a little help with SQLITE3 and PHP.

When I use the following code:
$statement = $db->prepare('SELECT * FROM programme WHERE progchanname = :progchanname');

$statement->bindValue(':progchanname', $channel);

$res = $statement->execute();

Nothing is returned.
But if I substitute the variable $channel with 'HGTV' I get results.

Why is the variable not being accepted?

#Code #PHP #SQLITE3

Hi, folks! 👋 How are you? ✌️

I've already publish the executable of Crisps Chat 🍟

And now you can download then test it! But only for Linux 🐧

Why test it? Because it's an early version of the app, and it has few features and a lot of bugs 🐞🐞🐞

You can download it freely from it Codeberg page 👉 https://codeberg.org/xolatgames/crisps-chat/releases/tag/0.1.0

#codeberg #opensource #communication #app #apps #soft #software #chat #application #sdl #sdl2 #sqlite #sqlite3 #imgui #development #devlog #chatting #messaging #cpp #cplusplus

Turns out adding a new unique column to a #sqlite3 database is one heck of a chore.

And yet someone must have figured this out already... who figured it out?

It is so cool that likely one of the fastest (especially compared to `better-sqlite3`) sqlite bindings for Node.js out there is the one we use for Signal Desktop client.

https://github.com/signalapp/node-sqlcipher

I should find motivation to upstream my ideas to back to Node.js core (JS level parameter binding and row parsing through a compiled function), but I’m… too lazy for that. Happy to explain how it all works to anyone interested, though!

#NodeJS #JavaScript #sqlite3

The things I learn, even at my age, simply by reading documentation are WILD!

Today: #SQLite3

"In addition to reading and writing SQLite database files, the sqlite3 program will also read and write ZIP archives."

https://sqlite.org/cli.html

Man, it'd be so nice if #sqlite3 actually had case insensitive text.

No, no, I hear you typing, "COLLATE NOCASE exi-" and you should stop, right now: that's ASCII only. No, not that 8 bit bullshit, ASCII was never 8 bit: *actual ASCII*. 26 characters. US English only.

Hey, remember when the world only used ASCII? No you don't, because there is no period in history where that was true. Remember IBM code pages? Exactly.

So yeah, it'd be so nice if sqlite3 actually had case insensitive text.

Ik ben echt een hele slechte #hacker.

Ik probeer een #sql injectie te doen (lokaal) op een #sqlite3 :sqlite: database, maar het lukt niet.

Er wordt geen tabel gewist ... :confused:

Now I have German airspace data in a database.

Ho. Ho. Ho.

#AIXM uses a #GML subset to define surfaces and curves. Arbitrary sets of primitives don't go well with relational databases, imo. Thus I converted the GML structures to semicolon-separated command strings (arc, circle, geodesic, line, curve).

#aviationnerd #python #sqlite3

Work in progress: declaring #AIXM objects in my #Python class structure. Most AIXM features (like aixm:AirportHeliport) of the datasets at https://aip.dfs.de/datasets are already defined.

Added a global linker set as class variable to the abstract object class, so that all links (like aixm:onRunway) can be collected and stored in one #sqlite3 helper table.

#aviationnerd