masto.ai is one of the many independent Mastodon servers you can use to participate in the fediverse.
A general Mastodon server for all languages.

Administered by:

Server stats:

2.2K
active users

#database

23 posts22 participants1 post today
Mad A. Argon :qurio:<p>Some time ago I mentioned here, in half-joking way, self-fixing software I work with. I said Patroni <a href="https://is-a.cat/tags/Postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Postgres</span></a> has the best regeneration ability I've ever seen. And currently "the best ability" includes:</p><p>&gt; After network migrations servers changed IP addresses. It broke etcd config so I had to completely delete that config and initialize etcd cluster again. Which also forced cleaning and renewing Patroni config because it is strongly dependent on etcd. Even when configuration temporarily didn't exist, connection with WAL archives (technically other separate server) wasn't interrupted (I am not even sure if real data transfer could happen at that time). It was seemingly enough to start new <a href="https://is-a.cat/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> cluster from last timeline. I don't know WHAT forced servers to immediately pull that data on fresh start. At migration time there weren't any real production data so I didn't even purposely try to restore anything.</p><p>&gt; Not so long time later (and now with real production things) some script tests, causing lots of database changes in relatively short time, beyond former server's capacity, killed master server. Patroni switched as intended and I could work on increasing server's capacity (had to do it live, not very convenient). First server finally decided data corruption was too big and to fix it automatically deleted whole /var/lib/postgresql/* directory and started to recreate thing from scratch, using data from new master server (and was doing it with at least 2 GB/s speed because why not? :blobcatjoy:).</p><p>&gt; During above mentioned process impatient tester hit again with their not optimised scripts, finally killing whole cluster. Swearing silently I increased remaining servers as it was only thing I really could do. Postgresql API mostly wasn't responsive, it had limited info about last state before final failure. It wasn't possible to force any change or affect it in any way.<br>First server decided to delete whole directory again and recreate it (at least this time I saw exact moment in logs), at the same time second server did rewind to state of third server (why??). All these things happened automatically, without my help. I wouldn't even know what to do :blobcatsweat: </p><p>And it's only beginning when we use it on production. Now I wait for stubborn users to do some more unintended durability tests... Maybe I would see it's even more invincible :blobcatamused: </p><p><a href="https://is-a.cat/tags/admin" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>admin</span></a> <a href="https://is-a.cat/tags/sysadmin" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sysadmin</span></a> <a href="https://is-a.cat/tags/it" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>it</span></a> <a href="https://is-a.cat/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgresql</span></a></p>
Linuxiac<p>Valkey 8.1 in-memory data store is here with boosts in performance, lower latency, enhanced observability, and more.<br><a href="https://linuxiac.com/valkey-8-1-in-memory-data-store-unleashes-10-faster-throughput/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">linuxiac.com/valkey-8-1-in-mem</span><span class="invisible">ory-data-store-unleashes-10-faster-throughput/</span></a></p><p><a href="https://mastodon.social/tags/valkey" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>valkey</span></a> <a href="https://mastodon.social/tags/redis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>redis</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/opensource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>opensource</span></a></p>
Gea-Suan Lin<p>Django 5.2 支援 composite primary key</p><p>看到 Django 5.2 的公告,裡面列出了比較重大的改變,其中一個注意到的是支援 Composite (Compound) Primary Key 了:「Django 5.2 released」,完整的 release notes 則是在「Django 5.2 release notes」這邊可以看到。 就是因為這些 ORM library 不支援 compsite primary key,所以才會有 best (?) practice 要求每個表格都要有 primary key,而且是單一欄位... 大家應該都習以為常了,怎麼會突然在 2025 年才想要支援? …</p><p><a href="https://blog.gslin.org/archives/2025/04/04/12331/django-5-2-%e6%94%af%e6%8f%b4-composite-primary-key/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">blog.gslin.org/archives/2025/0</span><span class="invisible">4/04/12331/django-5-2-%e6%94%af%e6%8f%b4-composite-primary-key/</span></a></p><p><a href="https://abpe.org/tags/composite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>composite</span></a> <a href="https://abpe.org/tags/compound" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>compound</span></a> <a href="https://abpe.org/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://abpe.org/tags/db" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>db</span></a> <a href="https://abpe.org/tags/django" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>django</span></a> <a href="https://abpe.org/tags/library" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>library</span></a> <a href="https://abpe.org/tags/orm" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>orm</span></a> <a href="https://abpe.org/tags/pk" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>pk</span></a> <a href="https://abpe.org/tags/PrimaryKey" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PrimaryKey</span></a> <a href="https://abpe.org/tags/rdbms" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>rdbms</span></a></p>
Orhun Parmaksız 👾<p>What do you call MongoDB in a terminal?</p><p>🍃 **tongo** — A TUI for navigating and manipulating MongoDB.</p><p>🔥 Supports fuzzy search, multiple sessions, customizations &amp; more!</p><p>🦀 Written in Rust &amp; built with <span class="h-card" translate="no"><a href="https://fosstodon.org/@ratatui_rs" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>ratatui_rs</span></a></span></p><p>⭐ GitHub: <a href="https://github.com/drewzemke/tongo" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">github.com/drewzemke/tongo</span><span class="invisible"></span></a></p><p><a href="https://fosstodon.org/tags/rustlang" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>rustlang</span></a> <a href="https://fosstodon.org/tags/ratatui" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ratatui</span></a> <a href="https://fosstodon.org/tags/tui" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>tui</span></a> <a href="https://fosstodon.org/tags/mongodb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mongodb</span></a> <a href="https://fosstodon.org/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://fosstodon.org/tags/administration" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>administration</span></a> <a href="https://fosstodon.org/tags/terminal" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>terminal</span></a> <a href="https://fosstodon.org/tags/commandline" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>commandline</span></a></p>
toiida🌻<p>Джорджийскому мальчику 20 неполных лет, а он участник семи музыкальных групп/проектов и известен под 25 псевдонимами: <a href="https://rateyourmusic.com/artist/janis-lago" rel="nofollow noopener noreferrer" target="_blank"><span class="invisible">https://</span><span class="ellipsis">rateyourmusic.com/artist/janis</span><span class="invisible">-lago</span></a> <a href="https://library.love/tags/JanisLago" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>JanisLago</span></a> <a href="https://library.love/tags/musicians" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>musicians</span></a> <a href="https://library.love/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://library.love/tags/postindustrial" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postindustrial</span></a> <a href="https://library.love/tags/deconstructedclub" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>deconstructedclub</span></a> <a href="https://library.love/tags/2020s" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>2020s</span></a></p>
Tokyo Outsider (337ppm)<p>What's the best Windows or web-based <a href="https://mas.to/tags/software" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>software</span></a> to produce <a href="https://mas.to/tags/SSADM" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SSADM</span></a> style <a href="https://mas.to/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> documentation these days? (free for personal use, ideally)</p><p>Boosts for reach much appreciated 🙏</p>
Sarah Conway<p>Hey <a href="https://infosec.exchange/tags/Montreal" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Montreal</span></a>, did you know Postgres Extensions Day is coming May 12? </p><p>Anyone working with PostgreSQL or who is interested in extension development can benefit from this event. Sign up for free, here: <a href="https://pgext.day" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">pgext.day</span><span class="invisible"></span></a></p><p>Questions? Get in touch with <span class="h-card" translate="no"><a href="https://discuss.systems/@yrashk" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>yrashk</span></a></span></p><p><a href="https://infosec.exchange/tags/devcommunity" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>devcommunity</span></a> <a href="https://infosec.exchange/tags/canada" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>canada</span></a> <a href="https://infosec.exchange/tags/tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>tech</span></a> <a href="https://infosec.exchange/tags/data" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>data</span></a> <a href="https://infosec.exchange/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://infosec.exchange/tags/foss" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>foss</span></a> <a href="https://infosec.exchange/tags/oss" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>oss</span></a> <a href="https://infosec.exchange/tags/opensource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>opensource</span></a> <a href="https://infosec.exchange/tags/techevent" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>techevent</span></a> <a href="https://infosec.exchange/tags/hacker" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>hacker</span></a> <a href="https://infosec.exchange/tags/coder" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>coder</span></a> <a href="https://infosec.exchange/tags/applicationdeveloper" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>applicationdeveloper</span></a> <a href="https://infosec.exchange/tags/dev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>dev</span></a> <a href="https://infosec.exchange/tags/developer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>developer</span></a> <a href="https://infosec.exchange/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgres</span></a></p>
Elegant Joy Digital<p>Do you, like me, LOVE SQL?? </p><p>I'm not kidding.</p><p>Check out the SQL murder mystery!<br>It's a fun way to exercise your SQL skills.</p><p><a href="https://mystery.knightlab.com/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">mystery.knightlab.com/</span><span class="invisible"></span></a></p><p>NO SPOILERS - yes, I know who did it.</p><p><a href="https://mastodon.online/tags/womenintech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>womenintech</span></a> <a href="https://mastodon.online/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> <a href="https://mastodon.online/tags/mystery" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mystery</span></a> <a href="https://mastodon.online/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a></p>
🔘 G◍M◍◍T 🔘<p>💡 MCP: lo standard che collega modelli AI e dati in tempo reale</p><p><a href="https://gomoot.com/mcp-lo-standard-che-collega-modelli-ai-e-dati-in-tempo-reale/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">gomoot.com/mcp-lo-standard-che</span><span class="invisible">-collega-modelli-ai-e-dati-in-tempo-reale/</span></a></p><p><a href="https://mastodon.uno/tags/anthropic" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>anthropic</span></a> <a href="https://mastodon.uno/tags/blog" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>blog</span></a> <a href="https://mastodon.uno/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://mastodon.uno/tags/dati" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>dati</span></a> <a href="https://mastodon.uno/tags/llm" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>llm</span></a> <a href="https://mastodon.uno/tags/mcp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mcp</span></a> <a href="https://mastodon.uno/tags/news" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>news</span></a> <a href="https://mastodon.uno/tags/openai" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>openai</span></a> <a href="https://mastodon.uno/tags/picks" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>picks</span></a> <a href="https://mastodon.uno/tags/server" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>server</span></a> <a href="https://mastodon.uno/tags/tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>tech</span></a> <a href="https://mastodon.uno/tags/tecnologia" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>tecnologia</span></a></p>
Pierre Lindenbaum<p>🇫🇷 INBOX: "Nous avons été sollicité hier soir par le ministère pour identifier d'urgence une liste de bases de données, critiques pour nos activités de recherche, qu'il faudrait "back-uper". Avez-vous des suggestions ? "</p><p> <a href="https://genomic.social/tags/france" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>france</span></a> <a href="https://genomic.social/tags/Science" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Science</span></a> <a href="https://genomic.social/tags/BackupPlan" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>BackupPlan</span></a> <a href="https://genomic.social/tags/Backup" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Backup</span></a> <a href="https://genomic.social/tags/usa" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>usa</span></a> <a href="https://genomic.social/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a></p>
💧🌏 Greg Cocks<p>Critical Minerals In Ores (CMiO) Database<br>--<br><a href="https://lnkd.in/gynRjUfn" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">lnkd.in/gynRjUfn</span><span class="invisible"></span></a> &lt;-- shared USGS publication<br>--<br><a href="https://lnkd.in/gETca3DQ" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">lnkd.in/gETca3DQ</span><span class="invisible"></span></a> &lt;-- shared link to open data database, web map services, etc<br>--<br><a href="https://portal.ga.gov.au/persona/cmmi" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">portal.ga.gov.au/persona/cmmi</span><span class="invisible"></span></a> &lt;-- shared web map<br>--<br><a href="https://lnkd.in/gdmMp2zg" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">lnkd.in/gdmMp2zg</span><span class="invisible"></span></a> &lt;-- shared editorial piece on critical minerals and geopolitics<br>--<br><a href="https://techhub.social/tags/geology" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>geology</span></a> <a href="https://techhub.social/tags/fedscience" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>fedscience</span></a> <a href="https://techhub.social/tags/opendata" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>opendata</span></a> <a href="https://techhub.social/tags/CMMI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>CMMI</span></a> <a href="https://techhub.social/tags/CMiO" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>CMiO</span></a> <a href="https://techhub.social/tags/criticalminerals" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>criticalminerals</span></a> <a href="https://techhub.social/tags/minerals" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>minerals</span></a> <a href="https://techhub.social/tags/ores" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ores</span></a> <a href="https://techhub.social/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://techhub.social/tags/opendata" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>opendata</span></a> <a href="https://techhub.social/tags/GIS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>GIS</span></a> <a href="https://techhub.social/tags/spatial" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>spatial</span></a> <a href="https://techhub.social/tags/mapping" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mapping</span></a> <a href="https://techhub.social/tags/spatialanalysis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>spatialanalysis</span></a> <a href="https://techhub.social/tags/commodities" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>commodities</span></a> <a href="https://techhub.social/tags/technology" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>technology</span></a> <a href="https://techhub.social/tags/components" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>components</span></a> <a href="https://techhub.social/tags/geochemistry" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>geochemistry</span></a> <a href="https://techhub.social/tags/deposits" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>deposits</span></a> <a href="https://techhub.social/tags/mining" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mining</span></a> <a href="https://techhub.social/tags/extraction" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>extraction</span></a> <a href="https://techhub.social/tags/classifaction" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>classifaction</span></a> <a href="https://techhub.social/tags/nomenclature" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>nomenclature</span></a> <a href="https://techhub.social/tags/environments" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>environments</span></a> <a href="https://techhub.social/tags/structuralgeology" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>structuralgeology</span></a> <a href="https://techhub.social/tags/exploration" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>exploration</span></a> <br>@USGS | @GeoscienceAustralia | @GeologicalSurveyOfCanada</p>
Wulfy<p><span class="h-card" translate="no"><a href="https://mas.to/@PrivacyDigest" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>PrivacyDigest</span></a></span> </p><p>YES!</p><p>FINALLY!</p><p>RESPONSIBLE <a href="https://infosec.exchange/tags/SYSADMIN" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SYSADMIN</span></a> DELETES THEIR <a href="https://infosec.exchange/tags/DATABASE" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DATABASE</span></a> WHEN THE FASCISTS TAKE OVER !!!</p>
PrivacyDigest<p><a href="https://mas.to/tags/OpenSource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OpenSource</span></a> <a href="https://mas.to/tags/Genetic" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Genetic</span></a> <a href="https://mas.to/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> Shuts Down to Protect Users From 'Authoritarian Governments'<br> <br>"The risk/benefit calculus of providing free &amp; open access to individual <a href="https://mas.to/tags/genetic" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>genetic</span></a> data in 2025 is very different compared to 14 years ago."<br><a href="https://mas.to/tags/privacy" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>privacy</span></a> <a href="https://mas.to/tags/dna" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>dna</span></a> </p><p><a href="https://www.404media.co/open-source-genetic-database-opensnp-shuts-down-to-protect-users-from-authoritarian-governments/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">404media.co/open-source-geneti</span><span class="invisible">c-database-opensnp-shuts-down-to-protect-users-from-authoritarian-governments/</span></a></p>
Pierre Lindenbaum<p>asking for a friend: do you know any database/framework to visualize RNAseq data ? (just like <a href="https://github.com/broadinstitute/gnomad-browser" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">github.com/broadinstitute/gnom</span><span class="invisible">ad-browser</span></a> for WGS)</p><p><a href="https://genomic.social/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://genomic.social/tags/rnaseq" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>rnaseq</span></a> <a href="https://genomic.social/tags/bioinformatics" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>bioinformatics</span></a></p>
SeanBurlington<p>Today I'm researching better workflows to backup databases, and create sanitised copies for local development.</p><p>I'm not able to find a great deal of informative discussion around best practice.</p><p>Is this stuff more obvious than I think - or is it so under-the-radar-unsexy that industry practice is just not very good?</p><p><a href="https://mastodon.me.uk/tags/backups" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>backups</span></a> <a href="https://mastodon.me.uk/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://mastodon.me.uk/tags/gdpr" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>gdpr</span></a> <a href="https://mastodon.me.uk/tags/webdev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>webdev</span></a></p>
InfoQ<p>Ever wondered how to compute a function across multiple parties without revealing their inputs?</p><p>This technique can be used to split secrets among parties, perform logical operations, or count votes in a way that ensures data privacy is preserved.</p><p>Read the <a href="https://techhub.social/tags/InfoQ" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>InfoQ</span></a> article to learn more: <a href="https://bit.ly/4cx8sAV" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">bit.ly/4cx8sAV</span><span class="invisible"></span></a> </p><p><a href="https://techhub.social/tags/BigData" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>BigData</span></a> <a href="https://techhub.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://techhub.social/tags/DataPrivacy" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataPrivacy</span></a> <a href="https://techhub.social/tags/SecureCoding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SecureCoding</span></a> <a href="https://techhub.social/tags/Algorithms" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Algorithms</span></a></p>
Iñaki de Miguel Díaz :verified_aroace:<p>Hoy toca hacer <a href="https://masto.es/tags/refactoring" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>refactoring</span></a> de una mierda en <a href="https://masto.es/tags/csharp6" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>csharp6</span></a> a mierda en la misma versión pero que no reviente las <a href="https://masto.es/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlserver</span></a> <a href="https://masto.es/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> si es que no me ponen con algún <a href="https://masto.es/tags/agilemeet" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>agilemeet</span></a> absurdo o a ayudar a los junior, que eso sí que me gusta.</p>
Prairie Postgres<p>🐘 Introducing: Prairie Postgres, a 501(c)(3) nonprofit organization chartered in Illinois, the Prairie State, serving the Midwestern United States!</p><p>We are devoted to training, professional development, and networking opportunities for technical practitioners and researchers.</p><p>For more information, check out our website: <a href="https://prairiepostgres.org" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">prairiepostgres.org</span><span class="invisible"></span></a></p><p><a href="https://cityofchicago.live/tags/tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>tech</span></a> <a href="https://cityofchicago.live/tags/dev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>dev</span></a> <a href="https://cityofchicago.live/tags/learnprogramming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>learnprogramming</span></a> <a href="https://cityofchicago.live/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> <a href="https://cityofchicago.live/tags/learnsql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>learnsql</span></a> <a href="https://cityofchicago.live/tags/studentdev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>studentdev</span></a> <a href="https://cityofchicago.live/tags/juniordev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>juniordev</span></a> <a href="https://cityofchicago.live/tags/developer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>developer</span></a> <a href="https://cityofchicago.live/tags/learntech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>learntech</span></a> <a href="https://cityofchicago.live/tags/codingnewbie" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>codingnewbie</span></a> <a href="https://cityofchicago.live/tags/data" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>data</span></a> <a href="https://cityofchicago.live/tags/opensource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>opensource</span></a> <a href="https://cityofchicago.live/tags/oss" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>oss</span></a> <a href="https://cityofchicago.live/tags/foss" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>foss</span></a> <a href="https://cityofchicago.live/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a></p>
James Gayfer<p>Is it a code smell for a table in Postgres to have mutually exclusive foreign keys?</p><p>For example, table A has foreign keys to table B and C, but there's a constraint in place where only one of those foreign keys can be populated.</p><p>My gut says I should be creating separate tables for these, as I'm effectively trying to tie a single table to multiple domain models (that happen to share the same fields).</p><p><a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgres</span></a> <a href="https://fosstodon.org/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://fosstodon.org/tags/databases" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>databases</span></a></p>
Truls<p>I am a (relational) database guy and have been for decades. </p><p>When I read "feature drop" it sounds to me, as if something was removed, not added. </p><p><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/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://mastodon.social/tags/wording" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>wording</span></a> <a href="https://mastodon.social/tags/featureDrop" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>featureDrop</span></a></p>