'/%3e%3cpath%20d='M50.3943%2022.237V39.5876H43.5185V22.7481C43.5185%2019.2029%2042.0411%2017.3949%2039.036%2017.3949C35.7325%2017.3949%2034.0778%2019.5338%2034.0778%2023.7585V32.9759H27.2434V23.7585C27.2434%2019.5338%2025.5857%2017.3949%2022.2822%2017.3949C19.2949%2017.3949%2017.8027%2019.2029%2017.8027%2022.7481V39.5876H10.9298V22.237C10.9298%2018.6918%2011.835%2015.8754%2013.6453%2013.7877C15.5128%2011.7049%2017.9623%2010.6355%2021.0028%2010.6355C24.522%2010.6355%2027.1813%2011.9885%2028.9542%2014.6917L30.665%2017.5633L32.3788%2014.6917C34.1517%2011.9885%2036.811%2010.6355%2040.3243%2010.6355C43.3619%2010.6355%2045.8114%2011.7049%2047.6847%2013.7877C49.4931%2015.8734%2050.3963%2018.6899%2050.3943%2022.237Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_89_8'%20x1='30.5'%20y1='0'%20x2='30.5'%20y2='65'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%236364FF'/%3e%3cstop%20offset='1'%20stop-color='%23563ACC'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e)
Christian Mayer<p>What's your favorite <a href="https://mastodon.social/tags/embedded" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>embedded</span></a> relational <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Database</span></a> engine like <a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlite</span></a> for the <a href="https://mastodon.social/tags/Zig" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Zig</span></a> programming language? <a href="https://mastodon.social/tags/DB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DB</span></a> <a href="https://mastodon.social/tags/sqlite3" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlite3</span></a> <a href="https://mastodon.social/tags/FOSS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>FOSS</span></a> <a href="https://mastodon.social/tags/programming" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>programming</span></a> <a href="https://mastodon.social/tags/ziglang" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ziglang</span></a> <a href="https://mastodon.social/tags/rdb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>rdb</span></a></p>
101010.pl is one of the many independent Mastodon servers you can use to participate in the fediverse.
101010.pl czyli najstarszy polski serwer Mastodon. Posiadamy wpisy do 2048 znaków.
Administered by:
Server stats:
504active users
101010.pl: About · Status · Profiles directory · Privacy policy
Mastodon: About · Get the app · Keyboard shortcuts · View source code · v4.4.0-beta.1
#sqlite3
0 posts · 0 participants · 0 posts today
Gary "grim" Kramlich<p>Greetings Programs! We're back at it working towards <span class="h-card" translate="no"><a href="https://fosstodon.org/@pidgin" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>pidgin</span></a></span> 3.0 Experimental 2!</p><p>We're going to continue with some library work tonight, working on our <a href="https://mastodon.social/tags/sqlite3" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlite3</span></a> helper library and if there's time getting back to our <a href="https://mastodon.social/tags/sasl" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sasl</span></a> library!</p><p>Come on by!!</p><p><a href="https://twitch.tv/rw_grim" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">twitch.tv/rw_grim</span><span class="invisible"></span></a><br><a href="https://youtube.com/@rw_grim" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">youtube.com/@rw_grim</span><span class="invisible"></span></a></p><p><a href="https://mastodon.social/tags/Pidgin" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Pidgin</span></a> <a href="https://mastodon.social/tags/OpenSource" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OpenSource</span></a> <a href="https://mastodon.social/tags/OpenSourceLive" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OpenSourceLive</span></a> <a href="https://mastodon.social/tags/C" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>C</span></a> <a href="https://mastodon.social/tags/GTK" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>GTK</span></a> <a href="https://mastodon.social/tags/Chat" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Chat</span></a> <a href="https://mastodon.social/tags/Messaging" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Messaging</span></a></p>
db_scheehan<p>HTMX hx-prompt and hx-confirm underlying implementation with Flask</p><p><a href="https://mastodon.social/tags/python" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>python</span></a> <a href="https://mastodon.social/tags/htmx" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>htmx</span></a> <a href="https://mastodon.social/tags/flask" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>flask</span></a> <a href="https://mastodon.social/tags/sqlite3" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlite3</span></a> <span class="h-card" translate="no"><a href="https://mastodon.social/@python_discussions" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>python_discussions</span></a></span> <span class="h-card" translate="no"><a href="https://threads.net/@htmlallthethings/" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>htmlallthethings</span></a></span> <br><span class="h-card" translate="no"><a href="https://mastodon.social/@HTMXCEO" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>HTMXCEO</span></a></span> </p><p><a href="https://github.com/scheehan/web_sql_editor_with_htmx_and_flask?tab=readme-ov-file" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">github.com/scheehan/web_sql_ed</span><span class="invisible">itor_with_htmx_and_flask?tab=readme-ov-file</span></a></p><p><a href="https://youtu.be/JqLqYW-zdQY" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">youtu.be/JqLqYW-zdQY</span><span class="invisible"></span></a></p><p><a href="https://discu.eu/?q=https%3A%2F%2Fgithub.com%2Fscheehan%2Fweb_sql_editor_with_htmx_and_flask%3Ftab%3Dreadme-ov-file" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">discu.eu/?q=https%3A%2F%2Fgith</span><span class="invisible">ub.com%2Fscheehan%2Fweb_sql_editor_with_htmx_and_flask%3Ftab%3Dreadme-ov-file</span></a></p>
bert hubert 🇺🇦🇪🇺🇺🇦<p>"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. <a href="https://fosstodon.org/tags/sqlite3" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlite3</span></a> <a href="https://sqlite.org/wal.html" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">sqlite.org/wal.html</span><span class="invisible"></span></a></p>
La vie dans mon jardin en code et en image<p><strong>Codeforterra : mODIFICATION DE LA FENETRE D’AFFICHAGE DES PLANTES…</strong></p> <p><span>⭐</span></p><p><span><span></span><span></span></span><span><span></span><span></span></span><span><span></span><span></span></span><span><span></span><span></span></span><span><span></span><span></span></span><span class="">Note : 1 sur 5.</span></p> <p><span></span></p><p><a rel="nofollow noopener" class="hashtag u-tag u-category" href="https://laviedansmonjardin.com/tag/listwidget/" target="_blank">#listwidget</a> <a rel="nofollow noopener" class="hashtag u-tag u-category" href="https://laviedansmonjardin.com/tag/pyside6/" target="_blank">#pyside6</a> <a rel="nofollow noopener" class="hashtag u-tag u-category" href="https://laviedansmonjardin.com/tag/python/" target="_blank">#python</a> <a rel="nofollow noopener" class="hashtag u-tag u-category" href="https://laviedansmonjardin.com/tag/sqlite3/" target="_blank">#sqlite3</a> <a rel="nofollow noopener" class="hashtag u-tag u-category" href="https://laviedansmonjardin.com/tag/tablewidget/" target="_blank">#tablewidget</a></p>
SuperIlu<p>My 2024 <a href="https://mastodon.social/tags/GitHub" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>GitHub</span></a> <a href="https://mastodon.social/tags/recap" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>recap</span></a>:</p><p>- Two <a href="https://mastodon.social/tags/DOjS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DOjS</span></a> releases and a <a href="https://mastodon.social/tags/win32" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>win32</span></a> port</p><p>- A new release of <a href="https://mastodon.social/tags/jSH" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>jSH</span></a></p><p>- Contributed <a href="https://mastodon.social/tags/DJGPP" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DJGPP</span></a> patches to <a href="https://mastodon.social/tags/mbedTLS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mbedTLS</span></a> and <a href="https://mastodon.social/tags/jasper" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>jasper</span></a></p><p>- Updated my <a href="https://mastodon.social/tags/BuildRoot" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>BuildRoot</span></a> GeodeLX repo</p><p>- Updated DOSQLite (<a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQLite</span></a> for MS-DOS)</p><p>- 11 Updates to <a href="https://mastodon.social/tags/DOStodon" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DOStodon</span></a> (<a href="https://mastodon.social/tags/MastodonClient" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MastodonClient</span></a> for MS-DOS)</p><p>- Three updates to <a href="https://mastodon.social/tags/httpDOS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>httpDOS</span></a> (<a href="https://mastodon.social/tags/HTTPS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>HTTPS</span></a> server for MS-DOS)</p><p><a href="https://mastodon.social/tags/MSDOS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MSDOS</span></a> <a href="https://mastodon.social/tags/RetroComputing" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>RetroComputing</span></a> <a href="https://mastodon.social/tags/recap2024" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>recap2024</span></a> <a href="https://mastodon.social/tags/JavaScript" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>JavaScript</span></a> <a href="https://mastodon.social/tags/SQLite3" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQLite3</span></a> <a href="https://mastodon.social/tags/FreeDOS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>FreeDOS</span></a> <a href="https://mastodon.social/tags/creativecoding" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>creativecoding</span></a> <a href="https://mastodon.social/tags/p5js" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>p5js</span></a> <a href="https://mastodon.social/tags/retrodev" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>retrodev</span></a> <a href="https://mastodon.social/tags/retrodevelopment" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>retrodevelopment</span></a> <a href="https://mastodon.social/tags/3dfx" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>3dfx</span></a> <a href="https://mastodon.social/tags/OpenGL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OpenGL</span></a> <a href="https://mastodon.social/tags/Processing" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Processing</span></a></p>
SuperIlu<p>.oO(<a href="https://mastodon.social/tags/win32" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>win32</span></a> and <a href="https://mastodon.social/tags/win98" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>win98</span></a> are REALLY testing my patience here. <a href="https://mastodon.social/tags/DOStodon" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DOStodon</span></a> works fine with the win32-port of <a href="https://mastodon.social/tags/DOjS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DOjS</span></a> on <a href="https://mastodon.social/tags/Win10" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Win10</span></a>, but <a href="https://mastodon.social/tags/SQLite3" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQLite3</span></a> and <a href="https://mastodon.social/tags/Curl" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Curl</span></a> fail on <a href="https://mastodon.social/tags/Win98" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Win98</span></a>) 🤬</p>
ꙮ liilliil 🇫🇯🇱🇨🇱🇧<p>Печалька: примерно треть пакетов уже не собирается<br>Например, mc: ему для сборки нужен python27 непременно, unrar тот же<br>А вот <a href="https://mastodon.online/tags/nano" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>nano</span></a> собралось. И <a href="https://mastodon.online/tags/sqlite3" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlite3</span></a>, который активно пользует apple<br>Может сделать сайт и выкладывать туда бинарники для powerpc g4?</p>
:rss: Qiita - 人気の記事<p>Windows で MCP の SQLite サーバーと文字コード<br><a href="https://qiita.com/7shi/items/0e31e10df92656aac207?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">qiita.com/7shi/items/0e31e10df</span><span class="invisible">92656aac207?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items</span></a></p><p><a href="https://rss-mstdn.studiofreesia.com/tags/qiita" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>qiita</span></a> <a href="https://rss-mstdn.studiofreesia.com/tags/Python" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Python</span></a> <a href="https://rss-mstdn.studiofreesia.com/tags/SQLite3" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQLite3</span></a> <a href="https://rss-mstdn.studiofreesia.com/tags/%E6%96%87%E5%AD%97%E3%82%B3%E3%83%BC%E3%83%89" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>文字コード</span></a> <a href="https://rss-mstdn.studiofreesia.com/tags/claude" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>claude</span></a> <a href="https://rss-mstdn.studiofreesia.com/tags/ModelContextProtocol" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ModelContextProtocol</span></a></p>
halil deniz<p>Database Management with Python and a Project Example</p><p><a href="https://denizhalil.com/2024/01/22/python-database-management-guide/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">denizhalil.com/2024/01/22/pyth</span><span class="invisible">on-database-management-guide/</span></a></p><p><a href="https://mastodon.social/tags/python" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>python</span></a> <a href="https://mastodon.social/tags/pythonprogramming" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>pythonprogramming</span></a> <a href="https://mastodon.social/tags/programming" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>programming</span></a> <a href="https://mastodon.social/tags/databases" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>databases</span></a> <a href="https://mastodon.social/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>database</span></a> <a href="https://mastodon.social/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a> <a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlite</span></a> <a href="https://mastodon.social/tags/sqlite3" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlite3</span></a></p>
Adam ♿<p><a href="https://mastodon.social/@gvwilson/111868487927825439" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">mastodon.social/@gvwilson/1118</span><span class="invisible">68487927825439</span></a> just taught me that <a href="https://aus.social/tags/sqlite3" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlite3</span></a> has .mode markdown - although I did have to go check <a href="https://www.sqlite.org/changes.html" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="">sqlite.org/changes.html</span><span class="invisible"></span></a> as it's only since 2020-08-14 (3.33.0)</p><p>Thanks <span class="h-card" translate="no"><a href="https://mastodon.social/@gvwilson" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>gvwilson</span></a></span></p>
Claudius Link<p>My impression is, that <a href="https://infosec.exchange/tags/SQLCipher" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQLCipher</span></a> is not compatible with the <a href="https://infosec.exchange/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQLite</span></a> Encryption Extension (or the other way around 😞 )</p><p>At least I didn't find a way to specify the key in such a way that <a href="https://infosec.exchange/tags/SQLite3" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQLite3</span></a> works with the database wich works using SQLCipher.</p><p>Can someone confirm or point me to some documentation regarding this?</p>
@reiver ⊼ (Charles) :batman:programming
Hrefna (DHC)<p>The shim is going to be _very_ thin because I don't need to swap runtime databases and can do a little work when I switchover, though maintaining the ability to run against something like <a href="https://hachyderm.io/tags/sqlite3" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlite3</span></a> would be nice just for demo purposes. </p><p>I've gone back and forth around whether I could use a non-relational database, but RDBMS are known quantities, SQL is such a well established language (even with variants and quirks), and creating a shim like this to swap between NoSQL systems is… nontrivial.</p>
Hrefna (DHC)<p>How I am prototyping playing around with <a href="https://hachyderm.io/tags/ActivityPub" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ActivityPub</span></a> this time (with bonus <a href="https://hachyderm.io/tags/OCaml" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OCaml</span></a>) for databases:</p><p>Basically I'm building a thin shim over the database API layer. This is both remarkably easy and remarkably weird in OCaml, so it makes for a good learning experience and gets me a little more comfortable with modules.</p><p>The first pass I'm just writing the basics with <a href="https://hachyderm.io/tags/sqlite3" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlite3</span></a>, later I'll go through and modify it to work with <a href="https://hachyderm.io/tags/PSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PSQL</span></a> and/or other options.</p>
lamitpObuS<p><span class="h-card"><a href="https://mastodon.social/@rotnroll666" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>rotnroll666</span></a></span> <span class="h-card"><a href="https://chaos.social/@georgberky" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>georgberky</span></a></span> <br>q is a binary wrapper around <a href="https://troet.cafe/tags/sqlite3" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlite3</span></a>.</p><p>It brings a bit of the <a href="https://troet.cafe/tags/duckdb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>duckdb</span></a> (just learned today about it ;-) ) functionality.</p><p>In sqlite if you want to use a csv file without a header column, the only way seems to be (at least I couldn't find one without sing "create table" first)</p><p>create table table1 (columns ...)<br>.import your.csv table1</p><p>where with q you can directly query from the CSV file</p><p>select * from your.csv</p>
Michael Simons<p>Yesterday I saw a nice stream by <span class="h-card"><a href="https://mastodon.online/@starbuxman" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>starbuxman</span></a></span> about Spring Batch and analyzing a video game sales data set and I thought: Can we do with less software? We can. </p><p>Analyze the "vgsales.csv" data set with sqlite3 and curl alone: <br><a href="https://gist.github.com/michael-simons/c2a8e639e540ce928e968d5c1ab8e181" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">gist.github.com/michael-simons</span><span class="invisible">/c2a8e639e540ce928e968d5c1ab8e181</span></a></p><p>Description of the dataset here <a href="https://www.kaggle.com/datasets/gregorut/videogamesales" rel="nofollow noopener" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">kaggle.com/datasets/gregorut/v</span><span class="invisible">ideogamesales</span></a></p><p>Output in the attached image <a href="https://mastodon.social/tags/sqlite3" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlite3</span></a> <a href="https://mastodon.social/tags/csv" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>csv</span></a> <a href="https://mastodon.social/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a></p>
Schenkl<p>Habe gegoogelt, wie man mit <a href="https://chaos.social/tags/PHP" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PHP</span></a> mit einer <a href="https://chaos.social/tags/sqlite3" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlite3</span></a> DB spricht.</p><p>Habe gelacht.</p><p>Habe geweint.</p><p>Browser zu.</p><p>Also doch wieder irgendwas in <a href="https://chaos.social/tags/Bash" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Bash</span></a> hacken 😒</p><p>Wenns dann in Bash läuft irgendwas suchen, das mir Bash im Browser interaktiv benutzen lässt?</p><p>Ich sehe schon, ich werde noch sehr viel weinen müssen...</p>
El Greco<p><span class="h-card"><a href="https://toot.cafe/@tomayac" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>tomayac</span></a></span> Just finished watching the recording of the Fugu Chat from BlinkOn 17. I particularly enjoyed the very last remark by Ben Morss: <a href="https://yewtu.be/watch?v=5Yzd3nCvIAM&t=27m25s" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">yewtu.be/watch?v=5Yzd3nCvIAM&t</span><span class="invisible">=27m25s</span></a></p><p>He refers to the recent beta release of sqlite3 WebAssembly which enables to create AND persist a sqlite database in your browser: <a href="https://sqlite.org/releaselog/3_40_0.html" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">sqlite.org/releaselog/3_40_0.h</span><span class="invisible">tml</span></a> </p><p>For persisting the database they are using an unlimited 👀 browser-side storage (OPFS): <a href="https://webkit.org/blog/12257/the-file-system-access-api-with-origin-private-file-system/" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">webkit.org/blog/12257/the-file</span><span class="invisible">-system-access-api-with-origin-private-file-system/</span></a></p><p><a href="https://masto.ai/tags/Fugu" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Fugu</span></a> <a href="https://masto.ai/tags/ProjectFugu" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ProjectFugu</span></a> <a href="https://masto.ai/tags/OPFS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OPFS</span></a> <a href="https://masto.ai/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlite</span></a> <a href="https://masto.ai/tags/sqlite3" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlite3</span></a> <a href="https://masto.ai/tags/WebDev" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>WebDev</span></a></p>
Remco.py<p><a href="https://fly.io/blog/all-in-on-sqlite-litestream/" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">fly.io/blog/all-in-on-sqlite-l</span><span class="invisible">itestream/</span></a><br>Really interesting future for sqlite. Anyone with any notable experience to share? <a href="https://fosstodon.org/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlite</span></a> <a href="https://fosstodon.org/tags/sqlite3" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlite3</span></a> <a href="https://fosstodon.org/tags/flyio" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>flyio</span></a> <a href="https://fosstodon.org/tags/litestream" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>litestream</span></a> <a href="https://fosstodon.org/tags/databases" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>databases</span></a> <a href="https://fosstodon.org/tags/durftevragen" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>durftevragen</span></a></p>
ExploreLive feeds
Mastodon is the best way to keep up with what's happening.
Follow anyone across the fediverse and see it all in chronological order. No algorithms, ads, or clickbait in sight.
Create accountLoginDrag & drop to upload