Recent searches
Search options
#sqlite3
"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
Codeforterra : mODIFICATION DE LA FENETRE D’AFFICHAGE DES PLANTES…
Note : 1 sur 5.
- Two #DOjS releases and a #win32 port
- A new release of #jSH
- Contributed #DJGPP patches to #mbedTLS and #jasper
- Updated my #BuildRoot GeodeLX repo
- Updated DOSQLite (#SQLite for MS-DOS)
- 11 Updates to #DOStodon (#MastodonClient for MS-DOS)
To connect to a database in Python, use a database-specific library such as Pyodbc for Microsoft Access and SQL Server, Psycopg2 for PostgreSQL, mysql-connector-python for MySQL, or sqlite3 for SQLite. You will need to execute a database query to retrieve the data after establishing the connection.
#python #Pyodbc #Psycopg2 #PostgreSQL #mysql-connector-python #MySQL #sqlite3 #SQLite #database #db #sql
Using R, Shiny and SQLite3 to host online stats assignments is a load of fun.
Until you accidentally swap out the SQL-data file with an empty one
No worries, the swap-out command saves the existing data, just in case.
A fun evening, writing R code to read the SQL, combining data accumulated in the "empty" file with the existing data, writing it out to Stata (where sane people do their complex data manipulation), reading it back into R to write to SQL.
RFID gate access control system. Advanced integration with Raspberry Pi and Telegram
#breadboard,#database,#datalogger,#dictionary,#digital,#digitalelectronics,#Dupontcables,#Flask,#internetofthings,#iot,#json,#led,#LEDdiode,#library,#linux,#Postman,#Python,#Raspberry,#redLED,#relay,#resistor,#RESTAPI,#rfid,#sensor,#sensors,#soldering,#solderingiron,#sqlite3,#telegram,#tutorial,#wifi
Leute. Proof of concept.
Character database:
Mein SQL: Okay.
Mein Python? Ich lerne erst seit gestern.
Mein GUI: Wird das packen!
https://mastodon.social/@gvwilson/111868487927825439 just taught me that #sqlite3 has .mode markdown - although I did have to go check https://www.sqlite.org/changes.html as it's only since 2020-08-14 (3.33.0)
Thanks @gvwilson
#SQLite is pretty neat. I'm used to working with large scale databases on mission critical data, but I needed something lightweight for a personal project. Something I could shunt around and not keep on a server. I settled on #SQLite3
However. I wasted a lot of time harking back to the turn of the millennium and trying to find a nice tool for forms to use with it. I tried lots of things including #LibreOffice Base with odbc and even #Kexi, which seemed promising at first but proved frustrating. I ended up just creating a web interface.
Reader, I do that for a living. I wanted a ready made solution for my personal project and just couldn't find one.
But, here's the thing. SQLite makes everything so easy to access that I'm sure I could write a set of #PHP scripts to build forms on the fly.
But I'm not going to. Not because I don't want to, but because it's just not a practical use of my time.
so i've got #sqlite3 running on my #esp32 via #LittleFS (#SPIFFS had issues with DELETE statements and would mess up opening/closing for some reason), set up web API locally for it..... and now am trying to think of where i want to integrate it.
It's simply recording every cycle of the washing machine (this project, that keeps growing: https://beige.party/@quasirealsmiths/110098199034110219 ) and it'd be neat to see a little graph.
For $3 these little boards are beasts -> https://www.aliexpress.us/item/3256804158044498.html
next project i think will be a heat/sound sensor put under the sink on the exterior cabinet wall facing the dishwasher so I can "smarten" that thing, too.
TIL: Audactiy-Projektdateien (mit der merkwürdigen Endung aup3) sind #sqlite3 Datenbanken.
My impression is, that #SQLCipher is not compatible with the #SQLite Encryption Extension (or the other way around 
)
At least I didn't find a way to specify the key in such a way that #SQLite3 works with the database wich works using SQLCipher.
Can someone confirm or point me to some documentation regarding this?
I know sqlite3 has become popular again. Has anyone looked at litestream? It can apparently distribute/replicate sqlite3 databases.
https://litestream.io/
#sqlite #sqlite3 #litestream
Yesterday I saw a nice stream by @starbuxman about Spring Batch and analyzing a video game sales data set and I thought: Can we do with less software? We can.
Analyze the "vgsales.csv" data set with sqlite3 and curl alone:
https://gist.github.com/michael-simons/c2a8e639e540ce928e968d5c1ab8e181
Description of the dataset here https://www.kaggle.com/datasets/gregorut/videogamesales
