shakedown.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
A community for live music fans with roots in the jam scene. Shakedown Social is run by a team of volunteers (led by @clifff and @sethadam1) and funded by donations.

Administered by:

Server stats:

285
active users

#rdbms

0 posts0 participants0 posts today
James Bartlett :terminal:<p>Hey Data/UIUX folks, how do you handle preferred pronouns on an input form that feeds into a database? Obviously, a drop-down menu is too limited, but free-form text input is too unruly. RegEx validation of some kind, perhaps?</p><p><a href="https://techhub.social/tags/Data" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Data</span></a> <a href="https://techhub.social/tags/UIUX" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>UIUX</span></a> <a href="https://techhub.social/tags/PreferredPronouns" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PreferredPronouns</span></a> <a href="https://techhub.social/tags/Pronouns" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Pronouns</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/RDBMS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>RDBMS</span></a> <a href="https://techhub.social/tags/RegEx" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>RegEx</span></a></p>
🧿🪬🍄🌈🎮💻🚲🥓🎃💀🏴🛻🇺🇸<p><span class="h-card" translate="no"><a href="https://linuxrocks.online/@haircode" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>haircode</span></a></span> <a href="https://mastodon.social/tags/typescript" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>typescript</span></a> <a href="https://mastodon.social/tags/tailwind" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>tailwind</span></a> <a href="https://mastodon.social/tags/reactRouter" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>reactRouter</span></a> <a href="https://mastodon.social/tags/docker" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>docker</span></a> <a href="https://mastodon.social/tags/graphql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>graphql</span></a> <a href="https://mastodon.social/tags/java" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>java</span></a> <a href="https://mastodon.social/tags/nix" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>nix</span></a> <a href="https://mastodon.social/tags/vim" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>vim</span></a> <a href="https://mastodon.social/tags/mac" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mac</span></a> <a href="https://mastodon.social/tags/ios" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ios</span></a> <a href="https://mastodon.social/tags/iphone" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>iphone</span></a> <a href="https://mastodon.social/tags/express" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>express</span></a> <a href="https://mastodon.social/tags/gcp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>gcp</span></a> <a href="https://mastodon.social/tags/reactNative" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>reactNative</span></a> <a href="https://mastodon.social/tags/nativeApps" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>nativeApps</span></a> <a href="https://mastodon.social/tags/appStore" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>appStore</span></a> <a href="https://mastodon.social/tags/apple" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>apple</span></a> <a href="https://mastodon.social/tags/aapl" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>aapl</span></a> <a href="https://mastodon.social/tags/htmx" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>htmx</span></a> <a href="https://mastodon.social/tags/vercel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>vercel</span></a> <a href="https://mastodon.social/tags/netlify" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>netlify</span></a> <a href="https://mastodon.social/tags/heroku" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>heroku</span></a> <a href="https://mastodon.social/tags/nevernester" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>nevernester</span></a> <a href="https://mastodon.social/tags/10xDev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>10xDev</span></a> <a href="https://mastodon.social/tags/10xdevelopers" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>10xdevelopers</span></a> <a href="https://mastodon.social/tags/codeReview" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>codeReview</span></a> <a href="https://mastodon.social/tags/pairProgramming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>pairProgramming</span></a> <a href="https://mastodon.social/tags/oop" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>oop</span></a> <a href="https://mastodon.social/tags/earlyReturns" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>earlyReturns</span></a> <a href="https://mastodon.social/tags/guardClauses" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>guardClauses</span></a> <a href="https://mastodon.social/tags/flutter" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>flutter</span></a> <a href="https://mastodon.social/tags/angular" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>angular</span></a> <a href="https://mastodon.social/tags/neverNesting" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>neverNesting</span></a> <a href="https://mastodon.social/tags/unitTest" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>unitTest</span></a> <a href="https://mastodon.social/tags/unitTesting" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>unitTesting</span></a> <a href="https://mastodon.social/tags/cssFrameworks" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>cssFrameworks</span></a> <a href="https://mastodon.social/tags/jest" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>jest</span></a> <a href="https://mastodon.social/tags/jetbrains" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>jetbrains</span></a> <a href="https://mastodon.social/tags/neoVim" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>neoVim</span></a> <a href="https://mastodon.social/tags/wordpress" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>wordpress</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/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgresql</span></a> <a href="https://mastodon.social/tags/rdbms" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>rdbms</span></a> <a href="https://mastodon.social/tags/rubyOnRails" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>rubyOnRails</span></a></p>
Firebird Database<p>Firebird Project is happy to announce general availability of Firebird 5.0 — the latest major release of the Firebird relational database for Windows, Linux, MacOS and Android platforms.</p><p>This release introduces improvements in areas of performance, multithreaded processing (including backup, restore, sweep), SQL queries profiling, with better scalability and numerous enhancements in SQL language.</p><p><a href="https://mastodon.social/tags/Firebird5" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Firebird5</span></a> <a href="https://mastodon.social/tags/FirebirdSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>FirebirdSQL</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/RDBMS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>RDBMS</span></a> <a href="https://mastodon.social/tags/opensource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>opensource</span></a><br><a href="https://firebirdsql.org/en/news/firebird-5-0-0-is-released/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">firebirdsql.org/en/news/firebi</span><span class="invisible">rd-5-0-0-is-released/</span></a></p>
Mark Gardner<p><span class="h-card" translate="no"><a href="https://hachyderm.io/@robpike" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>robpike</span></a></span> <span class="h-card" translate="no"><a href="https://floss.social/@gisgeek" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>gisgeek</span></a></span> Fair but often unavoidable. For example, almost every language’s <a href="https://social.sdf.org/tags/RDBMS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>RDBMS</span></a> support involves FFI to a client library.</p>
mkj<p><span class="h-card"><a href="https://mstdn.social/@Tedgarrison3" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>Tedgarrison3</span></a></span> <span class="h-card"><a href="https://mstdn.social/@stux" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>stux</span></a></span> <span class="h-card"><a href="https://gremlins.social/@gizmo" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>gizmo</span></a></span> Normally, a database engine should be able to lock fairly small chunks of storage to delete individual rows in a table. My guess would be that since such a cleanup presumably touches a rather large fraction of the rows in the table, the <a href="https://social.linux.pizza/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://social.linux.pizza/tags/RDBMS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>RDBMS</span></a> engine at some point, rather than locking individual chunks, just throws its hands in the air with a "I'm through with this piecemeal stuff, I'll just lock the whole thing instead so I can get this over with".</p>
Firebird Database<p>Firebird Project is happy to announce general availability of Firebird 4.0.2 — the second point release in the Firebird 4.0 series.</p><p>This sub-release offers many bug fixes and also adds a few improvements, please refer to the Release Notes for the full list of changes.<br>Binary kits for Windows, Linux and Android platforms are immediately available for download.</p><p><a href="https://firebirdsql.org/en/firebird-4-0-2/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">firebirdsql.org/en/firebird-4-</span><span class="invisible">0-2/</span></a></p><p><a href="https://mastodon.social/tags/FirebirdSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>FirebirdSQL</span></a> <a href="https://mastodon.social/tags/Windows" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Windows</span></a> <a href="https://mastodon.social/tags/Linux" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Linux</span></a> <a href="https://mastodon.social/tags/MacOs" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MacOs</span></a> <a href="https://mastodon.social/tags/RDBMS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>RDBMS</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/Android" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Android</span></a> <a href="https://mastodon.social/tags/Embedded" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Embedded</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/Firebird" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Firebird</span></a></p>