Mathstodon

7 posts6 participants2 posts today

LavX NewsBuilding a Flask-SQLite Boilerplate: A Step-by-Step GuideKickstart your next web application with a robust Flask-SQLite boilerplate. This guide walks you through setting up your development environment, creating a user authentication system, and managing da...<a href="https://news.lavx.hu/article/building-a-flask-sqlite-boilerplate-a-step-by-step-guide" rel="nofollow noopener noreferrer" target="_blank">https://news.lavx.hu/article/building-a-flask-sqlite-boilerplate-a-step-by-step-guide</a><a href="https://mastodon.cloud/tags/news" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#news</a> <a href="https://mastodon.cloud/tags/tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#tech</a> <a href="https://mastodon.cloud/tags/WebDevelopment" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#WebDevelopment</a> <a href="https://mastodon.cloud/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> <a href="https://mastodon.cloud/tags/Flask" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Flask</a>

𝕂𝚞𝚋𝚒𝚔ℙ𝚒𝚡𝚎𝚕sqlmapAutomatic SQL injection and database takeover tool🔧 <a href="https://sqlmap.org" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://sqlmap.org</a><a href="https://chaos.social/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sql</a> <a href="https://chaos.social/tags/map" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#map</a> <a href="https://chaos.social/tags/db" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#db</a> <a href="https://chaos.social/tags/sqlmap" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlmap</a> <a href="https://chaos.social/tags/sqldatabase" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqldatabase</a> <a href="https://chaos.social/tags/pgsql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#pgsql</a> <a href="https://chaos.social/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#database</a> <a href="https://chaos.social/tags/mysql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mysql</a> <a href="https://chaos.social/tags/opensource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#opensource</a> <a href="https://chaos.social/tags/injection" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#injection</a> <a href="https://chaos.social/tags/hacking" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#hacking</a> <a href="https://chaos.social/tags/opensql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#opensql</a> <a href="https://chaos.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlite</a> <a href="https://chaos.social/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgresql</a> <a href="https://chaos.social/tags/takeover" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#takeover</a> <a href="https://chaos.social/tags/itsec" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#itsec</a> <a href="https://chaos.social/tags/infection" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#infection</a>

ArtemisThat feeling when you forgot your password but it's been a local install anyway so you just sqlite3 into the database and generate a new bcrypt with Ruby.<a href="https://toot.cafe/tags/bcrypt" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#bcrypt</a> <a href="https://toot.cafe/tags/Ruby" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Ruby</a> <a href="https://toot.cafe/tags/Sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Sqlite</a>

Preston Maness ☭Ok. Just culled ~20,000 of 25,000 <a href="https://tenforward.social/tags/tumblr" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#tumblr</a> posts accumulated via <a href="https://tenforward.social/tags/RSS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#RSS</a> over a month. I've gotta get to work on my own project applying basic statistics to this stuff. Think "reverse chronological + $all_your_own_filtering_and_sorting_and_bucketing". Not sure if I should do that within the confines of a <a href="https://tenforward.social/tags/thunderbird" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#thunderbird</a> add-on, or try some other approach. I really, really want to be able to use <a href="https://tenforward.social/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sql</a> for this stuff. It's a natural fit. But <a href="https://tenforward.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlite</a> seems to be a no-go for <a href="https://tenforward.social/tags/WebExtensions" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#WebExtensions</a>. There is only <a href="https://tenforward.social/tags/IndexedDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#IndexedDB</a>, which, in my limited experience with it, is absolute garbage to work with.

Dion MoultHey all, I wrote a <a href="https://mastodon.social/tags/PHP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PHP</a> <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> <a href="https://mastodon.social/tags/OpenSource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#OpenSource</a> forum called <a href="https://mastodon.social/tags/Threadbare" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Threadbare</a> - <a href="https://github.com/Moult/threadbare" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://github.com/Moult/threadbare</a>If your community is mailing list scale (i.e. not huge multilingual multicategory nested threads) check it out. If you're looking for an alternative to works-only-with-JS needs-containerisation logs-everything and want something minimal with performance near to a static site, it might be for you. Would love feedback and testing and security advice!See <a href="https://community-test.osarch.org/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://community-test.osarch.org/</a> for demo.

alexanderadam<a href="https://social.lansky.name/@hn50" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@hn50</a><a href="https://ruby.social/@fractaledmind" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@fractaledmind</a> you're everywhere now if <a href="https://ruby.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> is in the game, aren't you? 😅

blaixFull, working example of using sqlite with the pretty nice, full stack, gren web framework:<a href="https://github.com/blaix/prettynice/tree/main/examples/v3/database" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://github.com/blaix/prettynice/tree/main/examples/v3/database</a><a href="https://hachyderm.io/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlite</a> <a href="https://hachyderm.io/tags/gren" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#gren</a> <a href="https://hachyderm.io/tags/FunctionalProgramming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#FunctionalProgramming</a>

b4ux1t3 :trek_ds9_sisko:#1️⃣GOING LIVE! I'm taking a break from the emulator to work on my <a href="https://hachyderm.io/tags/matrix" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#matrix</a> bot!<a href="https://twitch.tv/b4ux1t3" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://twitch.tv/b4ux1t3</a>It's a little bit for running <a href="https://hachyderm.io/tags/TTRPG" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#TTRPG</a> sessions (currently <a href="https://hachyderm.io/tags/DCCRPG" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DCCRPG</a>) using the matrix protocol! It's a rare occasion where I'm using _gasp_ python! Tonight we'll be wiring up the new character code I wrote to a command in chat, and will probably need to implement some <a href="https://hachyderm.io/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> DB access. Hopefully by the end of the week we'll be ready to open the game up to more players! <a href="https://hachyderm.io/tags/LiveCoding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LiveCoding</a> <a href="https://hachyderm.io/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Programming</a> <a href="https://hachyderm.io/tags/IndieDev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#IndieDev</a> <a href="https://hachyderm.io/tags/OpenSource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#OpenSource</a> <a href="https://hachyderm.io/tags/DevelopInTheOpen" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DevelopInTheOpen</a> <a href="https://hachyderm.io/tags/python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#python</a> <a href="https://hachyderm.io/tags/NoAI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#NoAI</a>

b4ux1t3 :trek_ds9_sisko:#1️⃣Tonight, at roughly 9PM Eastern, I'm taking a break from the emulator to work on my <a href="https://hachyderm.io/tags/matrix" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#matrix</a> bot!<a href="https://twitch.tv/b4ux1t3" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://twitch.tv/b4ux1t3</a>It's a little bit for running <a href="https://hachyderm.io/tags/TTRPG" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#TTRPG</a> sessions (currently <a href="https://hachyderm.io/tags/DCCRPG" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DCCRPG</a>) using the matrix protocol! It's a rare occasion where I'm using _gasp_ python! Tonight we'll be wiring up the new character code I wrote to a command in chat, and will probably need to implement some <a href="https://hachyderm.io/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> DB access. Hopefully by the end of the week we'll be ready to open the game up to more players! <a href="https://hachyderm.io/tags/LiveCoding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LiveCoding</a> <a href="https://hachyderm.io/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Programming</a> <a href="https://hachyderm.io/tags/IndieDev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#IndieDev</a> <a href="https://hachyderm.io/tags/OpenSource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#OpenSource</a> <a href="https://hachyderm.io/tags/DevelopInTheOpen" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DevelopInTheOpen</a> <a href="https://hachyderm.io/tags/python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#python</a> <a href="https://hachyderm.io/tags/NoAI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#NoAI</a>

Helge Heß<a href="https://c.im/@leogdion" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@leogdion</a> For <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> I also have Lighter, which I think is actually really good: <a href="https://github.com/Lighter-swift" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://github.com/Lighter-swift</a> And for Core Data I have replicated the <a href="https://mastodon.social/tags/SwiftData" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SwiftData</a> macros: <a href="https://github.com/Data-swift/ManagedModels/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://github.com/Data-swift/ManagedModels/</a> This by <a href="https://mastodon.social/@mattiem" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@mattiem</a> might also be relevant to your article: <a href="https://mastodon.social/@mattiem/114359442297769327" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://mastodon.social/@mattiem/114359442297769327</a>

Kees N ✅<a href="https://mastodon.sdf.org/@argv_minus_one" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@argv_minus_one</a> If it is actually written, yes. But <a href="https://toot.community/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> might detect there is no actual change and not declare the page dirty. And even if it is declared dirty, the row size will not change, so the B-Tree structure will be stable. The page has to be read anyway, so both the disk cache and the SQLite page cache are primed. Except for hi-speed, hi-volume applications, I would not worry in advance. Premature optimization is the root of all evil.

Kees N ✅<a href="https://mastodon.sdf.org/@argv_minus_one" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@argv_minus_one</a> CREATE TABLE T1 ( id INTEGER PRIMARY KEY NOT NULL , tx TEXT UNIQUE ); INSERT INTO T1 (tx) VALUES ('abc'),('def'),('ghi'); SELECT * FROM T1; id tx -- --- 1 abc 2 def 3 ghi INSERT INTO T1 (tx) VALUES ('def') ON CONFLICT (tx) DO UPDATE SET id = id + 0 RETURNING id; id -- 2<a href="https://toot.community/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlite</a>

argv minus oneI am disappointed to find that, with <a href="https://mastodon.sdf.org/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a>, an INSERT statement with both ON CONFLICT DO NOTHING and RETURNING clauses won't return anything if there is a conflict.I have a table that's basically just for interning frequently-used strings. It has a numeric ID column and a unique text column, and I want to get the ID for a given string, inserting if necessary.With this RETURNING behavior, that has to be done in two steps, not one. 😔<a href="https://mastodon.sdf.org/tags/programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#programming</a>

Harris Georgiou<a href="https://mastodon.social/tags/Coding_Fridays" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Coding_Fridays</a> is back : K-nn classifier in SQLiteWatch the full video in the Youtube channel central >> <a href="https://www.youtube.com/@apneacoding" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://www.youtube.com/@apneacoding</a> This is a set of SQL queries demonstrating how in-server data processing can enable some basic data analytics. Enable captions for more details and walk-through. Source code available at the Github repository (see channel info).<a href="https://mastodon.social/tags/asmr" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#asmr</a> <a href="https://mastodon.social/tags/coding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#coding</a> <a href="https://mastodon.social/tags/programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#programming</a> <a href="https://mastodon.social/tags/notalking" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#notalking</a> <a href="https://mastodon.social/tags/terminal" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#terminal</a> <a href="https://mastodon.social/tags/console" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#console</a> <a href="https://mastodon.social/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sql</a> <a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlite</a>

Harris Georgiou<a href="https://mastodon.social/tags/Coding_Fridays" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Coding_Fridays</a> is back : K-nn classifier in SQLiteWatch the full video in the Youtube channel central >> <a href="https://www.youtube.com/@apneacoding" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://www.youtube.com/@apneacoding</a> This is a set of SQL queries demonstrating how in-server data processing can enable some basic data analytics.Enable captions for more details and walk-through. Source code available at the Github repository (see channel info).<a href="https://mastodon.social/tags/asmr" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#asmr</a> <a href="https://mastodon.social/tags/coding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#coding</a> <a href="https://mastodon.social/tags/programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#programming</a> <a href="https://mastodon.social/tags/notalking" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#notalking</a> <a href="https://mastodon.social/tags/terminal" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#terminal</a> <a href="https://mastodon.social/tags/console" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#console</a> <a href="https://mastodon.social/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sql</a> <a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlite</a>

Hacker NewsSQLite Transactions and Virtual Tables<a href="https://misfra.me/2025/sqlite-transactions-and-virtual-tables/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://misfra.me/2025/sqlite-transactions-and-virtual-tables/</a><a href="https://mastodon.social/tags/HackerNews" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#HackerNews</a> <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> <a href="https://mastodon.social/tags/Transactions" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Transactions</a> <a href="https://mastodon.social/tags/VirtualTables" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#VirtualTables</a> <a href="https://mastodon.social/tags/DatabaseDevelopment" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DatabaseDevelopment</a> <a href="https://mastodon.social/tags/TechNews" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#TechNews</a>

Curated Hacker NewsSQLite transactions and virtual tables<a href="https://misfra.me/2025/sqlite-transactions-and-virtual-tables/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://misfra.me/2025/sqlite-transactions-and-virtual-tables/</a><a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlite</a>

James Seconde"Take a Vonage Voice API webhook and persist it to <a href="https://phpc.social/tags/Sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Sqlite</a>"<a href="https://phpc.social/tags/Typescript" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Typescript</a> <a href="https://phpc.social/tags/Prisma" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Prisma</a> <a href="https://phpc.social/tags/ExpressJS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ExpressJS</a>: 2 days, including finding out <a href="https://phpc.social/tags/Sequelize" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Sequelize</a> CLI is broken so shelved for Prisma and some libraries are still stuck in CommonJS vs ESM module export hell.<a href="https://phpc.social/tags/Laravel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Laravel</a>: 35 minutes.

IT NewsDIY AI Butler Is Simpler and More Useful Than Siri - [Geoffrey Litt] shows that getting an effective digital assistant that’s tailored ... - <a href="https://hackaday.com/2025/04/15/diy-ai-butler-is-simpler-and-more-useful-than-siri/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://hackaday.com/2025/04/15/diy-ai-butler-is-simpler-and-more-useful-than-siri/</a> <a href="https://schleuss.online/tags/artificialintelligence" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#artificialintelligence</a> <a href="https://schleuss.online/tags/digitalassistant" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#digitalassistant</a> <a href="https://schleuss.online/tags/aiassistant" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#aiassistant</a> <a href="https://schleuss.online/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlite</a> <a href="https://schleuss.online/tags/diy" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#diy</a> <a href="https://schleuss.online/tags/llm" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#llm</a>

Curated Hacker NewsSQLite File Format Viewer<a href="https://sqlite-internal.pages.dev" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://sqlite-internal.pages.dev</a><a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlite</a>

Recent searches

Search options

Administered by:

Server stats:

#sqlite