Harris Georgiou<p><a href="https://mastodon.social/tags/Coding_Fridays" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Coding_Fridays</span></a> is back : K-nn classifier in SQLite</p><p>Watch the full video in the Youtube channel central <br>>> <a href="https://www.youtube.com/@apneacoding" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="">youtube.com/@apneacoding</span><span class="invisible"></span></a> </p><p>This is a set of SQL queries demonstrating how in-server data processing can enable some basic data analytics. </p><p>Enable captions for more details and walk-through. Source code available at the Github repository (see channel info).</p><p><a href="https://mastodon.social/tags/asmr" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>asmr</span></a> <a href="https://mastodon.social/tags/coding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>coding</span></a> <a href="https://mastodon.social/tags/programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>programming</span></a> <a href="https://mastodon.social/tags/notalking" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>notalking</span></a> <a href="https://mastodon.social/tags/terminal" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>terminal</span></a> <a href="https://mastodon.social/tags/console" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>console</span></a> <a href="https://mastodon.social/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> <a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlite</span></a></p>
Frühere Suchanfragen
Keine früheren Suchanfragen
Suchoptionen
Only available when logged in.
troet.cafe ist Teil eines dezentralisierten sozialen Netzwerks, angetrieben von Mastodon.
Hallo im troet.cafe!
Dies ist die derzeit größte deutschsprachige Mastodon Instanz zum tröten, neue Leute kennenlernen, sich auszutauschen und Spaß zu haben.
Verwaltet von:
Serverstatistik:
7,1 Tsd.aktive Profile
Mehr erfahren
troet.cafe: Über · Profilverzeichnis · Datenschutzerklärung
Mastodon: Über · App herunterladen · Tastenkombinationen · Quellcode anzeigen · v4.2.19
#sqlite
23 Beiträge · 19 Beteiligte · 2 Beiträge heute
Harris Georgiou<p><a href="https://mastodon.social/tags/Coding_Fridays" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Coding_Fridays</span></a> is back : K-nn classifier in SQLite</p><p>Watch the full video in the Youtube channel central <br>>> <a href="https://www.youtube.com/@apneacoding" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="">youtube.com/@apneacoding</span><span class="invisible"></span></a> </p><p>This is a set of SQL queries demonstrating how in-server data processing can enable some basic data analytics.</p><p>Enable captions for more details and walk-through. Source code available at the Github repository (see channel info).</p><p><a href="https://mastodon.social/tags/asmr" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>asmr</span></a> <a href="https://mastodon.social/tags/coding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>coding</span></a> <a href="https://mastodon.social/tags/programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>programming</span></a> <a href="https://mastodon.social/tags/notalking" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>notalking</span></a> <a href="https://mastodon.social/tags/terminal" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>terminal</span></a> <a href="https://mastodon.social/tags/console" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>console</span></a> <a href="https://mastodon.social/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> <a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlite</span></a></p>
N-gated Hacker News<p>😂 Oh joy, another Kafka-length ode to SQLite's virtual tables! Apparently, all you need for "true transactional integrity" is a few 🌟magical🌟 hooks. Because, obviously, row-level updates are for amateurs. 🙄<br><a href="https://misfra.me/2025/sqlite-transactions-and-virtual-tables/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">misfra.me/2025/sqlite-transact</span><span class="invisible">ions-and-virtual-tables/</span></a> <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLite</span></a> <a href="https://mastodon.social/tags/SQLiteVirtualTables" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLiteVirtualTables</span></a> <a href="https://mastodon.social/tags/TransactionalIntegrity" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>TransactionalIntegrity</span></a> <a href="https://mastodon.social/tags/ProgrammingHumor" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ProgrammingHumor</span></a> <a href="https://mastodon.social/tags/SoftwareDevelopment" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SoftwareDevelopment</span></a> <a href="https://mastodon.social/tags/HackerNews" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>HackerNews</span></a> <a href="https://mastodon.social/tags/ngated" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ngated</span></a></p>
Hacker News<p>SQLite Transactions and Virtual Tables</p><p><a href="https://misfra.me/2025/sqlite-transactions-and-virtual-tables/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">misfra.me/2025/sqlite-transact</span><span class="invisible">ions-and-virtual-tables/</span></a></p><p><a href="https://mastodon.social/tags/HackerNews" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>HackerNews</span></a> <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLite</span></a> <a href="https://mastodon.social/tags/Transactions" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Transactions</span></a> <a href="https://mastodon.social/tags/VirtualTables" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>VirtualTables</span></a> <a href="https://mastodon.social/tags/DatabaseDevelopment" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DatabaseDevelopment</span></a> <a href="https://mastodon.social/tags/TechNews" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>TechNews</span></a></p>
Curated Hacker News<p>SQLite transactions and virtual tables</p><p><a href="https://misfra.me/2025/sqlite-transactions-and-virtual-tables/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">misfra.me/2025/sqlite-transact</span><span class="invisible">ions-and-virtual-tables/</span></a></p><p><a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlite</span></a></p>
James Seconde<p>"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">#<span>Sqlite</span></a>"</p><p><a href="https://phpc.social/tags/Typescript" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Typescript</span></a> <a href="https://phpc.social/tags/Prisma" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Prisma</span></a> <a href="https://phpc.social/tags/ExpressJS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ExpressJS</span></a>: 2 days, including finding out <a href="https://phpc.social/tags/Sequelize" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Sequelize</span></a> CLI is broken so shelved for Prisma and some libraries are still stuck in CommonJS vs ESM module export hell.</p><p><a href="https://phpc.social/tags/Laravel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Laravel</span></a>: 35 minutes.</p>
LLMsDIY AI Butler Is Simpler and More Useful Than Siri [Geoffrey Litt] shows that getting an effectiv...<br><br><a href="https://hackaday.com/2025/04/15/diy-ai-butler-is-simpler-and-more-useful-than-siri/" rel="nofollow noopener noreferrer" target="_blank">https://hackaday.com/2025/04/15/diy-ai-butler-is-simpler-and-more-useful-than-siri/</a><br><br><a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/Artificial" target="_blank">#Artificial</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/Intelligence" target="_blank">#Intelligence</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/AI" target="_blank">#AI</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/assistant" target="_blank">#assistant</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/digital" target="_blank">#digital</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/assistant" target="_blank">#assistant</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/diy" target="_blank">#diy</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/LLM" target="_blank">#LLM</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/sqlite" target="_blank">#sqlite</a><br><br><a href="https://awakari.com/pub-msg.html?id=SwBAGywsWo6Ubx75wTOWeZcczc8" rel="nofollow noopener noreferrer" target="_blank">Event Attributes</a>
Pyrzout :vm:<p>DIY AI Butler Is Simpler and More Useful Than Siri <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"><span class="invisible">https://</span><span class="ellipsis">hackaday.com/2025/04/15/diy-ai</span><span class="invisible">-butler-is-simpler-and-more-useful-than-siri/</span></a> <a href="https://social.skynetcloud.site/tags/ArtificialIntelligence" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ArtificialIntelligence</span></a> <a href="https://social.skynetcloud.site/tags/digitalassistant" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>digitalassistant</span></a> <a href="https://social.skynetcloud.site/tags/AIassistant" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>AIassistant</span></a> <a href="https://social.skynetcloud.site/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlite</span></a> <a href="https://social.skynetcloud.site/tags/diy" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>diy</span></a> <a href="https://social.skynetcloud.site/tags/LLM" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LLM</span></a></p>
TelegramDIY AI Butler Is Simpler and More Useful Than Siri [Geoffrey Litt] shows that getting an effectiv...<br><br><a href="https://hackaday.com/2025/04/15/diy-ai-butler-is-simpler-and-more-useful-than-siri/" rel="nofollow noopener noreferrer" target="_blank">https://hackaday.com/2025/04/15/diy-ai-butler-is-simpler-and-more-useful-than-siri/</a><br><br><a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/Artificial" target="_blank">#Artificial</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/Intelligence" target="_blank">#Intelligence</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/AI" target="_blank">#AI</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/assistant" target="_blank">#assistant</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/digital" target="_blank">#digital</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/assistant" target="_blank">#assistant</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/diy" target="_blank">#diy</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/LLM" target="_blank">#LLM</a> <a rel="nofollow noopener noreferrer" class="mention hashtag" href="https://mastodon.social/tags/sqlite" target="_blank">#sqlite</a><br><br><a href="https://awakari.com/pub-msg.html?id=TEFXy0pYyWzjfutnsbyZrBx1DNo" rel="nofollow noopener noreferrer" target="_blank">Event Attributes</a>
IT News<p>DIY 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"><span class="invisible">https://</span><span class="ellipsis">hackaday.com/2025/04/15/diy-ai</span><span class="invisible">-butler-is-simpler-and-more-useful-than-siri/</span></a> <a href="https://schleuss.online/tags/artificialintelligence" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>artificialintelligence</span></a> <a href="https://schleuss.online/tags/digitalassistant" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>digitalassistant</span></a> <a href="https://schleuss.online/tags/aiassistant" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>aiassistant</span></a> <a href="https://schleuss.online/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlite</span></a> <a href="https://schleuss.online/tags/diy" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>diy</span></a> <a href="https://schleuss.online/tags/llm" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>llm</span></a></p>
Curated Hacker News<p>SQLite File Format Viewer</p><p><a href="https://sqlite-internal.pages.dev" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">sqlite-internal.pages.dev</span><span class="invisible"></span></a></p><p><a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlite</span></a></p>
Curated Hacker News<p>A hackable AI assistant using a single SQLite table and a handful of cron jobs</p><p><a href="https://www.geoffreylitt.com/2025/04/12/how-i-made-a-useful-ai-assistant-with-one-sqlite-table-and-a-handful-of-cron-jobs" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">geoffreylitt.com/2025/04/12/ho</span><span class="invisible">w-i-made-a-useful-ai-assistant-with-one-sqlite-table-and-a-handful-of-cron-jobs</span></a></p><p><a href="https://mastodon.social/tags/ai" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ai</span></a> <a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlite</span></a></p>
stephann :godot:<p>It would be nice if Godot had native integration with SQLite, or at least an official plugin. It's a tiny/fast/embedabble database, perfect for games and mobile/desktop apps.</p><p><a href="https://mastodon.gamedev.place/tags/godotengine" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>godotengine</span></a> <a href="https://mastodon.gamedev.place/tags/godot" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>godot</span></a> <a href="https://mastodon.gamedev.place/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlite</span></a></p>
David Bisset<p>Stevens: a hackable <a href="https://phpc.social/tags/AI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>AI</span></a> assistant "using a single <a href="https://phpc.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLite</span></a> table and a handful of cron jobs"</p><p><a href="https://www.geoffreylitt.com/2025/04/12/how-i-made-a-useful-ai-assistant-with-one-sqlite-table-and-a-handful-of-cron-jobs" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">geoffreylitt.com/2025/04/12/ho</span><span class="invisible">w-i-made-a-useful-ai-assistant-with-one-sqlite-table-and-a-handful-of-cron-jobs</span></a></p><p><a href="https://phpc.social/tags/webdev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>webdev</span></a></p>
Hacker News<p>SQLite File Format Viewer</p><p><a href="https://sqlite-internal.pages.dev" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">sqlite-internal.pages.dev</span><span class="invisible"></span></a></p><p><a href="https://mastodon.social/tags/HackerNews" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>HackerNews</span></a> <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLite</span></a> <a href="https://mastodon.social/tags/File" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>File</span></a> <a href="https://mastodon.social/tags/Format" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Format</span></a> <a href="https://mastodon.social/tags/Viewer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Viewer</span></a> <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLite</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/Tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Tech</span></a> <a href="https://mastodon.social/tags/Tools" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Tools</span></a> <a href="https://mastodon.social/tags/Developer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Developer</span></a> <a href="https://mastodon.social/tags/Resources" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Resources</span></a></p>
Curated Hacker News<p>SQLite File Format Viewer</p><p><a href="https://sqlite-internal.pages.dev" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">sqlite-internal.pages.dev</span><span class="invisible"></span></a></p><p><a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlite</span></a></p>
Curated Hacker News<p>A hackable AI assistant using a single SQLite table and a handful of cron jobs</p><p><a href="https://www.geoffreylitt.com/2025/04/12/how-i-made-a-useful-ai-assistant-with-one-sqlite-table-and-a-handful-of-cron-jobs" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">geoffreylitt.com/2025/04/12/ho</span><span class="invisible">w-i-made-a-useful-ai-assistant-with-one-sqlite-table-and-a-handful-of-cron-jobs</span></a></p><p><a href="https://mastodon.social/tags/ai" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ai</span></a> <a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlite</span></a></p>
N-gated Hacker News<p>🚀🎩 Oh, the sheer audacity of using a single <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLite</span></a> table and cron jobs to whip up a "hackable" <a href="https://mastodon.social/tags/AI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>AI</span></a> assistant! Who needs cutting-edge <a href="https://mastodon.social/tags/tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>tech</span></a> when you can <a href="https://mastodon.social/tags/MacGyver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MacGyver</span></a> your way through the AI landscape with a couple of strings and some duct tape? 🤖🔧<br><a href="https://www.geoffreylitt.com/2025/04/12/how-i-made-a-useful-ai-assistant-with-one-sqlite-table-and-a-handful-of-cron-jobs" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">geoffreylitt.com/2025/04/12/ho</span><span class="invisible">w-i-made-a-useful-ai-assistant-with-one-sqlite-table-and-a-handful-of-cron-jobs</span></a> <a href="https://mastodon.social/tags/hackable" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>hackable</span></a> <a href="https://mastodon.social/tags/cronjobs" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>cronjobs</span></a> <a href="https://mastodon.social/tags/creativity" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>creativity</span></a> <a href="https://mastodon.social/tags/HackerNews" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>HackerNews</span></a> <a href="https://mastodon.social/tags/ngated" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ngated</span></a></p>
Hacker News<p>A hackable AI assistant using a single SQLite table and a handful of cron jobs</p><p><a href="https://www.geoffreylitt.com/2025/04/12/how-i-made-a-useful-ai-assistant-with-one-sqlite-table-and-a-handful-of-cron-jobs" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">geoffreylitt.com/2025/04/12/ho</span><span class="invisible">w-i-made-a-useful-ai-assistant-with-one-sqlite-table-and-a-handful-of-cron-jobs</span></a></p><p><a href="https://mastodon.social/tags/HackerNews" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>HackerNews</span></a> <a href="https://mastodon.social/tags/hackableAI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>hackableAI</span></a> <a href="https://mastodon.social/tags/assistant" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>assistant</span></a> <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLite</span></a> <a href="https://mastodon.social/tags/cronjobs" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>cronjobs</span></a> <a href="https://mastodon.social/tags/AItechnology" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>AItechnology</span></a></p>
Mika<p>I... actually managed to do this and it was somewhat messy to get through with it, but I did it. My 'stoppers' initially were simply needing to update some of the <a href="https://sakurajima.social/tags/Jellyfin" rel="nofollow noopener noreferrer" target="_blank">#Jellyfin</a>'s <code>xml</code> configs for any wrong/old paths/values, and lastly, the <a href="https://sakurajima.social/tags/SQLite" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> DBs themselves which had old paths as well - most of which were easy to fix as they're <code>text</code> values, but some were (JSON) <code>blob</code>s, using the same extension on <a href="https://sakurajima.social/tags/VSCode" rel="nofollow noopener noreferrer" target="_blank">#VSCode</a><span>, this wasn't that hard to do either by simply exporting the blob, editing the blob's JSON text value, and reimporting the blob to the column.<br><br>Now my Jellyfin </span><a href="https://sakurajima.social/tags/LinuxServer" rel="nofollow noopener noreferrer" target="_blank">#LinuxServer</a>.io container sitting in an unprivileged (<a href="https://sakurajima.social/tags/Debian" rel="nofollow noopener noreferrer" target="_blank">#Debian</a> <a href="https://sakurajima.social/tags/Linux" rel="nofollow noopener noreferrer" target="_blank">#Linux</a>) <a href="https://sakurajima.social/tags/LXC" rel="nofollow noopener noreferrer" target="_blank">#LXC</a> container on <a href="https://sakurajima.social/tags/Proxmox" rel="nofollow noopener noreferrer" target="_blank">#Proxmox</a> is set up with hardware transcoding using the <a href="https://sakurajima.social/tags/AMD" rel="nofollow noopener noreferrer" target="_blank">#AMD</a> Ryzen 5 5600G onboard iGPU (cos I'm getting impatient in waiting for my <a href="https://sakurajima.social/tags/Intel" rel="nofollow noopener noreferrer" target="_blank">#Intel</a> <a href="https://sakurajima.social/tags/ArcA380" rel="nofollow noopener noreferrer" target="_blank">#ArcA380</a> to arrive). I'll update my <a href="https://sakurajima.social/tags/ErsatzTV" rel="nofollow noopener noreferrer" target="_blank">#ErsatzTV</a> container to do the same. Everything's perfect now, 'cept, I still wouldn't recommend users to stream Jellyfin on the web or a web-based client using transcoding, cos while the transcoding itself is perfect, Jellyfin seems to have an issue (that I never got on <a href="https://sakurajima.social/tags/Plex" rel="nofollow noopener noreferrer" target="_blank">#Plex</a><span>) whereby the subtitle would desync pretty consistently if not direct playing - with external or embedded subs, regardless. Dk if that can ever be fixed though, considering the issue has been up since 2023 with no fix whatsoever.<br><br>There's also a separate issue I'm having where Jellyfin does not seem to support discovering/serving media files that are contained in a symlink directory (even though there were some people on their forums reporting in the past that it should) - I've reported it last week, but it's not going anywhere for now. Regardless though, I'm absolutely loving Jellyfin despite some of its rough edges, and my users are loving it too. I think I've considered myself 'migrated' from Plex to Jellyfin, but I'll still keep Plex around as backup for these 2 cases/issues I've mentioned, for now.<br><br></span>🔗 <a href="https://github.com/jellyfin/jellyfin-web/issues/4346" rel="nofollow noopener noreferrer" target="_blank">https://github.com/jellyfin/jellyfin-web/issues/4346</a><span><br><br></span>🔗 <a href="https://github.com/jellyfin/jellyfin/issues/13858" rel="nofollow noopener noreferrer" target="_blank">https://github.com/jellyfin/jellyfin/issues/13858</a><span><br><br>RE: </span><a href="https://sakurajima.social/notes/a6j9bhrbtq" rel="nofollow noopener noreferrer" target="_blank">https://sakurajima.social/notes/a6j9bhrbtq</a></p>
EntdeckenLive-Feeds
Melde dich an, um Profilen oder Hashtags zu folgen, Beiträge zu favorisieren, zu teilen und auf sie zu antworten. Du kannst auch von deinem Konto aus auf einem anderen Server interagieren.
Konto erstellenAnmeldenZum Hochladen hereinziehen