MastodonTech.de

Guillaume Tronix :nix: :emacs: :linux:Tuta introduces smarter email search and a new calendar widget on iOSThe search function now enables partial word searches, accompanied by a refreshed interface that highlights search terms for quicker identification. Tuta has rolled out a series of updates to its privacy-focusedemailandcalendarservices.<a href="https://alternativeto.net/news/2025/6/tuta-introduces-smarter-email-search-and-a-new-calendar-widget-on-ios/" rel="nofollow noopener" translate="no" target="_blank">https://alternativeto.net/news/2025/6/tuta-introduces-smarter-email-search-and-a-new-calendar-widget-on-ios/</a><a href="https://infosec.exchange/tags/Privacy" class="mention hashtag" rel="nofollow noopener" target="_blank">#Privacy</a> <a href="https://infosec.exchange/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLite</a>

Hacker NewsSQLite Date and Time Functions (2007)<a href="https://www2.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions" rel="nofollow noopener" translate="no" target="_blank">https://www2.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions</a><a href="https://mastodon.social/tags/HackerNews" class="mention hashtag" rel="nofollow noopener" target="_blank">#HackerNews</a> <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLite</a> <a href="https://mastodon.social/tags/Date" class="mention hashtag" rel="nofollow noopener" target="_blank">#Date</a> <a href="https://mastodon.social/tags/and" class="mention hashtag" rel="nofollow noopener" target="_blank">#and</a> <a href="https://mastodon.social/tags/Time" class="mention hashtag" rel="nofollow noopener" target="_blank">#Time</a> <a href="https://mastodon.social/tags/Functions" class="mention hashtag" rel="nofollow noopener" target="_blank">#Functions</a> #2007 <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLite</a> <a href="https://mastodon.social/tags/Functions" class="mention hashtag" rel="nofollow noopener" target="_blank">#Functions</a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener" target="_blank">#Database</a> <a href="https://mastodon.social/tags/Development" class="mention hashtag" rel="nofollow noopener" target="_blank">#Development</a> <a href="https://mastodon.social/tags/Programming" class="mention hashtag" rel="nofollow noopener" target="_blank">#Programming</a>

PermaI added search functionality to my blog using fts5 of sqlite. <a class="hashtag" href="https://genserver.social/tag/blog" rel="nofollow noopener" target="_blank">#blog</a> <a class="hashtag" href="https://genserver.social/tag/sqlite" rel="nofollow noopener" target="_blank">#sqlite</a> <a href="https://theleafslug.com/entries/search" rel="nofollow noopener" target="_blank">https://theleafslug.com/entries/search</a>

James SecondeIt's SQLite o'clock! Check out Prisma ORM to write webhooks to my new favourite way of persisting data!<a href="https://developer.vonage.com/en/blog/the-return-of-sqlite" rel="nofollow noopener" translate="no" target="_blank">https://developer.vonage.com/en/blog/the-return-of-sqlite</a><a href="https://phpc.social/tags/typescript" class="mention hashtag" rel="nofollow noopener" target="_blank">#typescript</a> <a href="https://phpc.social/tags/javascript" class="mention hashtag" rel="nofollow noopener" target="_blank">#javascript</a> <a href="https://phpc.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlite</a>

KungFuDiscoMonkeyYesterday continued my <a href="https://social.tsun.co/tags/rust" class="mention hashtag" rel="nofollow noopener" target="_blank">#rust</a> <a href="https://social.tsun.co/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlite</a> table, so that a definition like `CREATE TABLE x(path,title,slug,tags,excerpt,extra,content,metadata)` referenced the correct frontmatter fields. - path is the path to the file - slug will have a default value generated but can be overridden in the front matter - metadata is the full frontmatter as a dict and so onToday I'm going to do some integration testing with <a href="https://social.tsun.co/tags/django" class="mention hashtag" rel="nofollow noopener" target="_blank">#django</a> to see if I can get my hugo repo to show up as a django model.

KungFuDiscoMonkeyToday's progress on my <a href="https://social.tsun.co/tags/rust" class="mention hashtag" rel="nofollow noopener" target="_blank">#rust</a> based <a href="https://social.tsun.co/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlite</a> virtualtable``` CREATE VIRTUAL TABLE temp.blog USING markdowndb( schema='CREATE TABLE x(path, content)', path='content/blog' ); SELECT * FROM blog;path content ----- ./content/blog/two.markdown Post body for two ./content/blog/one.markdown Post body for one. ```

Orhun Parmaksız 👾Found another TUI for your sysadmin toolbox 🔥🛢️**jdbrowser** — A terminal SQLite database browser.💯 Supports displaying tables, copying to clipboard & more!🦀 Written in Rust & built with <a href="https://fosstodon.org/@ratatui_rs" class="u-url mention" rel="nofollow noopener" target="_blank">@ratatui_rs</a>⭐ GitHub: <a href="https://github.com/Jkeyuk/JDbrowser" rel="nofollow noopener" translate="no" target="_blank">https://github.com/Jkeyuk/JDbrowser</a><a href="https://fosstodon.org/tags/rustlang" class="mention hashtag" rel="nofollow noopener" target="_blank">#rustlang</a> <a href="https://fosstodon.org/tags/ratatui" class="mention hashtag" rel="nofollow noopener" target="_blank">#ratatui</a> <a href="https://fosstodon.org/tags/tui" class="mention hashtag" rel="nofollow noopener" target="_blank">#tui</a> <a href="https://fosstodon.org/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a> <a href="https://fosstodon.org/tags/browser" class="mention hashtag" rel="nofollow noopener" target="_blank">#browser</a> <a href="https://fosstodon.org/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlite</a> <a href="https://fosstodon.org/tags/terminal" class="mention hashtag" rel="nofollow noopener" target="_blank">#terminal</a> <a href="https://fosstodon.org/tags/commandline" class="mention hashtag" rel="nofollow noopener" target="_blank">#commandline</a>

KungFuDiscoMonkeyCurrent status``` Parsing statement: CREATE TABLE x(a,b,c) Columns: ["a", "b", "c"] ```Working on my <a href="https://social.tsun.co/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlite</a> virtual table in <a href="https://social.tsun.co/tags/rust" class="mention hashtag" rel="nofollow noopener" target="_blank">#rust</a> sqlite only seems to keep track of the column ids, so I need a way to map the names to ids for later when I'm dealing with named fields.Using sqlite3-parser and rusqlite crates

Pragmatic Bookshelf 📚Thrilled to offer our newest distribution title: Northwind Elixir Traders by Isaak TsalicoglouNot your typical programming tutorial. This immersive, project-based adventure reimagines the classic Northwind database, guiding you through Ecto’s migrations, changesets, and queries to model data with real-world edge. <a href="https://pragprog.com/titles/d-itnet?utm_source=m" rel="nofollow noopener" translate="no" target="_blank">https://pragprog.com/titles/d-itnet?utm_source=m</a> <a href="https://techhub.social/tags/Ecto" class="mention hashtag" rel="nofollow noopener" target="_blank">#Ecto</a> <a href="https://techhub.social/tags/ElixirLang" class="mention hashtag" rel="nofollow noopener" target="_blank">#ElixirLang</a> <a href="https://techhub.social/tags/Elixir" class="mention hashtag" rel="nofollow noopener" target="_blank">#Elixir</a> <a href="https://techhub.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLite</a>

Howard Chu @ SymasAn overview of <a href="https://mastodon.social/tags/LumoSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#LumoSQL</a> - the successor to SQLightning, which replaced <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLite</a>'s b+tree code with <a href="https://mastodon.social/tags/LMDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#LMDB</a> <a href="https://www.xugj520.cn/en/archives/lumosql-sqlite-enhancement-database.html?amp=1" rel="nofollow noopener" translate="no" target="_blank">https://www.xugj520.cn/en/archives/lumosql-sqlite-enhancement-database.html?amp=1</a>

nixCraft 🐧Test Postgres in Python Like SQLite : A <a href="https://mastodon.social/tags/Python" class="mention hashtag" rel="nofollow noopener" target="_blank">#Python</a> testing library that provides seamless integration between PGlite and Python test suites. Get the full power of PostgreSQL in your tests without the overhead of a full PostgreSQL installation.<a href="https://github.com/wey-gu/py-pglite" rel="nofollow noopener" translate="no" target="_blank">https://github.com/wey-gu/py-pglite</a><a href="https://mastodon.social/tags/python" class="mention hashtag" rel="nofollow noopener" target="_blank">#python</a> <a href="https://mastodon.social/tags/OpenSource" class="mention hashtag" rel="nofollow noopener" target="_blank">#OpenSource</a> <a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlite</a> <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a>

Curated Hacker NewsTest Postgres in Python Like SQLite<a href="https://github.com/wey-gu/py-pglite" rel="nofollow noopener" translate="no" target="_blank">https://github.com/wey-gu/py-pglite</a><a href="https://mastodon.social/tags/github" class="mention hashtag" rel="nofollow noopener" target="_blank">#github</a> <a href="https://mastodon.social/tags/python" class="mention hashtag" rel="nofollow noopener" target="_blank">#python</a> <a href="https://mastodon.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlite</a>

Hacker NewsTest Postgres in Python Like SQLite<a href="https://github.com/wey-gu/py-pglite" rel="nofollow noopener" translate="no" target="_blank">https://github.com/wey-gu/py-pglite</a><a href="https://mastodon.social/tags/HackerNews" class="mention hashtag" rel="nofollow noopener" target="_blank">#HackerNews</a> <a href="https://mastodon.social/tags/TestPostgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#TestPostgres</a> <a href="https://mastodon.social/tags/Python" class="mention hashtag" rel="nofollow noopener" target="_blank">#Python</a> <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLite</a> <a href="https://mastodon.social/tags/pyPglite" class="mention hashtag" rel="nofollow noopener" target="_blank">#pyPglite</a> <a href="https://mastodon.social/tags/DatabaseTesting" class="mention hashtag" rel="nofollow noopener" target="_blank">#DatabaseTesting</a>

The gallant knightHat hier jemand Erfahrungen mit selbstgehosteten Alternativen zu <a href="https://nrw.social/tags/pocket" class="mention hashtag" rel="nofollow noopener" target="_blank">#pocket</a>? Ich bevorzuge Lösungen, die mit einer einfachen DB auskommen, <a href="https://nrw.social/tags/sqlite" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlite</a> / <a href="https://nrw.social/tags/postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#postgres</a>, nicht in Python geschrieben sind und entweder als binary daherkommen oder unter <a href="https://nrw.social/tags/node" class="mention hashtag" rel="nofollow noopener" target="_blank">#node</a> / <a href="https://nrw.social/tags/deno" class="mention hashtag" rel="nofollow noopener" target="_blank">#deno</a> laufen. Idealerweise kann ich meine pocket-Daten importieren. <a href="https://nrw.social/tags/fedihelp" class="mention hashtag" rel="nofollow noopener" target="_blank">#fedihelp</a> <a href="https://nrw.social/tags/selfhosting" class="mention hashtag" rel="nofollow noopener" target="_blank">#selfhosting</a> <a href="https://nrw.social/tags/bookmarks" class="mention hashtag" rel="nofollow noopener" target="_blank">#bookmarks</a>

Neustradamus :xmpp: :linux:<a href="https://mastodon.social/tags/Roundcube" class="mention hashtag" rel="nofollow noopener" target="_blank">#Roundcube</a> 1.5.10 (<a href="https://mastodon.social/tags/LTS" class="mention hashtag" rel="nofollow noopener" target="_blank">#LTS</a>) has been released (<a href="https://mastodon.social/tags/Webmail" class="mention hashtag" rel="nofollow noopener" target="_blank">#Webmail</a> / <a href="https://mastodon.social/tags/Mail" class="mention hashtag" rel="nofollow noopener" target="_blank">#Mail</a> / <a href="https://mastodon.social/tags/IMAP" class="mention hashtag" rel="nofollow noopener" target="_blank">#IMAP</a> / <a href="https://mastodon.social/tags/SMTP" class="mention hashtag" rel="nofollow noopener" target="_blank">#SMTP</a> / <a href="https://mastodon.social/tags/LDAP" class="mention hashtag" rel="nofollow noopener" target="_blank">#LDAP</a> / <a href="https://mastodon.social/tags/Managesieve" class="mention hashtag" rel="nofollow noopener" target="_blank">#Managesieve</a> / <a href="https://mastodon.social/tags/PHP" class="mention hashtag" rel="nofollow noopener" target="_blank">#PHP</a> / <a href="https://mastodon.social/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#MariaDB</a> / <a href="https://mastodon.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#MySQL</a> / <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a> / <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLite</a> / <a href="https://mastodon.social/tags/OracleDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#OracleDB</a> / <a href="https://mastodon.social/tags/MSSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#MSSQL</a> / <a href="https://mastodon.social/tags/LongTermSupport" class="mention hashtag" rel="nofollow noopener" target="_blank">#LongTermSupport</a>) <a href="https://roundcube.net/" rel="nofollow noopener" translate="no" target="_blank">https://roundcube.net/</a>

Neustradamus :xmpp: :linux:<a href="https://mastodon.social/tags/Roundcube" class="mention hashtag" rel="nofollow noopener" target="_blank">#Roundcube</a> 1.6.11 (stable) has been released (<a href="https://mastodon.social/tags/Webmail" class="mention hashtag" rel="nofollow noopener" target="_blank">#Webmail</a> / <a href="https://mastodon.social/tags/Mail" class="mention hashtag" rel="nofollow noopener" target="_blank">#Mail</a> / <a href="https://mastodon.social/tags/IMAP" class="mention hashtag" rel="nofollow noopener" target="_blank">#IMAP</a> / <a href="https://mastodon.social/tags/SMTP" class="mention hashtag" rel="nofollow noopener" target="_blank">#SMTP</a> / <a href="https://mastodon.social/tags/LDAP" class="mention hashtag" rel="nofollow noopener" target="_blank">#LDAP</a> / <a href="https://mastodon.social/tags/Managesieve" class="mention hashtag" rel="nofollow noopener" target="_blank">#Managesieve</a> / <a href="https://mastodon.social/tags/PHP" class="mention hashtag" rel="nofollow noopener" target="_blank">#PHP</a> / <a href="https://mastodon.social/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#MariaDB</a> / <a href="https://mastodon.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#MySQL</a> / <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#PostgreSQL</a> / <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLite</a> / <a href="https://mastodon.social/tags/OracleDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#OracleDB</a> / <a href="https://mastodon.social/tags/MSSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#MSSQL</a>) <a href="https://roundcube.net/" rel="nofollow noopener" translate="no" target="_blank">https://roundcube.net/</a>

NicdSo in SQLite, the `like` operator is case insensitive by default. You can turn it case sensitive with a pragma, but that pragma is deprecated and has side effects.You might opt for `glob`, but that one does not have escape characters. So what are you supposed to do if you have user input and you need to do a case sensitive search?<a href="https://masto.ahlcode.fi/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLite</a>

Guillaume Tronix :nix: :emacs: :linux:OpenSUSE Tumbleweed update brings QEMU 10, KDE Plasma 6.3.5, and security upgradesOpenSUSE Tumbleweedhas released its monthly update, now running on the Linux kernel 6.14.6.<a href="https://alternativeto.net/news/2025/6/opensuse-tumbleweed-update-brings-qemu-10-kde-plasma-6-3-5-and-security-upgrades/" rel="nofollow noopener" translate="no" target="_blank">https://alternativeto.net/news/2025/6/opensuse-tumbleweed-update-brings-qemu-10-kde-plasma-6-3-5-and-security-upgrades/</a><a href="https://infosec.exchange/tags/Linux" class="mention hashtag" rel="nofollow noopener" target="_blank">#Linux</a> <a href="https://infosec.exchange/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLite</a>

Inautilo<a href="https://mastodon.social/tags/Development" class="mention hashtag" rel="nofollow noopener" target="_blank">#Development</a> <a href="https://mastodon.social/tags/Anniversaries" class="mention hashtag" rel="nofollow noopener" target="_blank">#Anniversaries</a> 25 years ago, Richard Hipp created SQLite · Today, it's the most widely used database engine worldwide <a href="https://ilo.im/1649ea" rel="nofollow noopener" translate="no" target="_blank">https://ilo.im/1649ea</a>_____ <a href="https://mastodon.social/tags/Programming" class="mention hashtag" rel="nofollow noopener" target="_blank">#Programming</a> <a href="https://mastodon.social/tags/Coding" class="mention hashtag" rel="nofollow noopener" target="_blank">#Coding</a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener" target="_blank">#Database</a> <a href="https://mastodon.social/tags/DatabaseEngine" class="mention hashtag" rel="nofollow noopener" target="_blank">#DatabaseEngine</a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQL</a> <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLite</a> <a href="https://mastodon.social/tags/WebDev" class="mention hashtag" rel="nofollow noopener" target="_blank">#WebDev</a> <a href="https://mastodon.social/tags/Backend" class="mention hashtag" rel="nofollow noopener" target="_blank">#Backend</a>

tlohdeI want to make my partner a simple database (~3 tables, i think), because I think that's the "right" thing to use (as opposed to excel / google sheets). But, I've never had to create a database thingy before.Seeing this as an opportunity to learn some <a href="https://fediscience.org/tags/DuckDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#DuckDB</a> or <a href="https://fediscience.org/tags/SQLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQLite</a>.Seeking <a href="https://fediscience.org/tags/recommendations" class="mention hashtag" rel="nofollow noopener" target="_blank">#recommendations</a> for a simple (GUI) interface for interacting with the tables.<a href="https://fediscience.org/tags/LibreOffice" class="mention hashtag" rel="nofollow noopener" target="_blank">#LibreOffice</a> Base or something else?<a href="https://fediscience.org/tags/suggestions" class="mention hashtag" rel="nofollow noopener" target="_blank">#suggestions</a> welcome <a href="https://fediscience.org/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a> <a href="https://fediscience.org/tags/db" class="mention hashtag" rel="nofollow noopener" target="_blank">#db</a> <a href="https://fediscience.org/tags/help" class="mention hashtag" rel="nofollow noopener" target="_blank">#help</a>

Frühere Suchanfragen

Suchoptionen

Verwaltet von:

Serverstatistik:

#sqlite