HTMX hx-prompt and hx-confirm underlying implementation with Flask
#python #htmx #flask #sqlite3 @python_discussions @htmlallthethings
@HTMXCEO
https://github.com/scheehan/web_sql_editor_with_htmx_and_flask?tab=readme-ov-file
I know #SQLite3 supports #SQL comments in newer versions with the right flags, but `rails g` for #ActiveRecord ďoesn’t seem to support them except in #PostgreSQL or #MySQL / #MariaDB. Is there a workaround?
"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)
Database Management with Python and a Project Example
https://denizhalil.com/2024/01/22/python-database-management-guide/
One of the great things about #golang is easy cross-compilation. However, most #golang #sqlite3 drivers make it considerably less easy by wrapping around the C implementation, requiring #cgo. Now there's a new `database/sql` compatible driver that gets rid of #cgo by wrapping the #sqlite #wasm build instead. Neat!
[2/2]
I'm not sure what to think of the SQL statement limit for SQLite3 (https://www.sqlite.org/limits.html):
> [...] text of an SQL statement is limited to SQLITE_MAX_SQL_LENGTH which defaults to 1,000,000,000.
but also:
> [...] SQL statement is limited to be a million bytes in length, then obviously you will not be able to insert multi-million byte strings
Except the it first says 1 billion bytes (or almost a GB) which can easily handle a multi-million byte length string.
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
My #Synology NAS decided to went into ReadOnly mode for no reason. The problem is that i need to evacuate 50TB of data to 5TB drives. I can not connect all those 5TB drives and once and They're quite not reliable - some are crashing after writing some data to them.
Is there a ready program which cna help me?
So far my plan is to write #Python script to index all those files into #sqlite3 database and then prepare lists of files which fits into space on external drives.
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.