🛢️ #usql — універсальний інтерфейс командного рядка для #PostgreSQL, #MySQL, #Oracle, #SQLite3, #MicrosoftSQLServer та інших баз даних, включаючи #NoSQL та нереляційні бази даних.
usql підтримує більшість основних функцій psql, а також має додаткові функції, яких немає в psql.
🔗 github.com/xo/usql
Better SQLite3 12.6: Fast and Simple #SQLite3 Library || #NodeJS #JavaScript #SQLite bit.ly/4qbkW6o
If you want to use SQLite3 with Spatialite in Go, check out github.com/watchedsky-s... that I just pushed up. #golang #sqlite3 #spatialite
🛢️ FilesSQL - драйвер #SQL для прямих запитів до файлів даних без попереднього імпорту. Підтримує CSV, TSV, LTSV, Parquet та Excel файли з використанням синтаксису #SQLite3.
🔗 github.com/nao1215/file...
Well, the update to #sqlite3 3.49.0 has been a real dumpster fire. Someone decided libtool was no longer needed. Total carnage for all packages linked against libsqlite3.dylib ensued. Lots of manual tweaking/patching to get things working again.
Just for pain and testing fun. I just tested #SMR + #btrfs + #SQLite3 with 64 #threads making (only) small updates as fast as possible. Sure it was insanely slow, but nothing got corrupted so it was all good after all.
"The second advantage of WAL-mode is that writers do not block readers and readers to do not block writers. This is mostly true" - coming to you live from the part where this is not true. #sqlite3 sqlite.org/wal.html
"The second advantage of WAL-mode is that writers do not block readers and readers to do not block writers. This is mostly true" - coming to you live from the part where this is not true. #sqlite3 https://sqlite.org/wal.html
🔍 / #software / #app
@AntaresSQL
by @akela86
🐱🔗 https://laravista.altervista.org/CatLink/links/272
#catlink #SoftwareApp #electron #javascript #mysql #DesktopApp #client #typescript #sql #database #vue #sqlite #postgresql #mariadb #ElectronApp #sqlite3 #LinuxApp #WindowsApp #antares […]
Exciting news for @flutter.dev: Simon Binder, the creator of #drift & #sqlite3 in #Dart, is joining the PowerSync team!
Discover how this move will supercharge the Flutter SQLite ecosystem and our sync engine. Read his post 👇
www.powersync.com/blog/simon-...
SQLite's ATTACH DATABASE command lets you work with multiple database files at once - yet surprisingly few people know about it. Super handy when joining user-specific data with a global database for instance. #sqlite3
sqlite.org/lang_attach....
Choose 20 Ruby gems that you've used time and time again, or have inspired you in some way. #20DayGemChallenge
One gem per day for 20 days, in no particular order.
Will create a post at notepad.onghu.com on Day 20 to explain my choices.
Day 19/20: github.com/sparklemotio...
#ruby #rails #sqlite3
Obtener información de log de Pi-hole desde su BD sqlite3: proyectoa.com/obtener-info...
Cómo obtener información adicional de log del servidor DNS Pi-hole
#pihole #dns #sqlite3 #bd #basededatos #sqlite #linux #ProyectoA #ajpdsoft
Dive deeper into working with dates in SQLite3 using the strftime function and learn how to handle date and time data effectively in Lazarus.
#SQLite3 #PascalProgramming #LazarusIDE #DatabaseDevelopment #strftime #FreePascal #SQLTips #DateHandling #ProgrammingTutorial
youtu.be/QR2arjyb6YM
Step 2: Just build it. I slapped my #jetstream consumer go code with some #sqlite3. Put the algorithm in a SQL view,
Looks like it works...
It's time for bed, lazily I SCP'd the binary over to my server and going to let it run in a screen session.
Hopefully I can get my trending feed of #lka
