mastodon.xyz is one of the many independent Mastodon servers you can use to participate in the fediverse.
A Mastodon instance, open to everyone, but mainly English and French speaking.

Administered by:

Server stats:

815
active users

#rdbms

0 posts0 participants0 posts today
Dave Mason<p>Many will tell you the leading cause of alcoholism is family history.</p><p>But they're wrong--it's poor database design.</p><p><a href="https://mastodon.social/tags/RDBMS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>RDBMS</span></a><br><a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a></p>
Firebird Database<p>Firebird Project is happy to announce general availability of Firebird 5.0.2 — the latest minor release in the Firebird 5.0 series.</p><p>This minor release offers bug fixes as well as a few improvements, please refer to the Release Notes for the full list of changes.</p><p>Binary kits for Windows, Linux, MacOS and Android platforms are immediately available for download.</p><p><a href="https://firebirdsql.org/en/news/firebird-5-0-2-minor-release-is-available" 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-2-minor-release-is-available</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/Firebird5" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Firebird5</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/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a></p>
Douglas J Hunley<p>PRQL <a href="https://prql-lang.org/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">prql-lang.org/</span><span class="invisible"></span></a> <a href="https://fosstodon.org/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> <a href="https://fosstodon.org/tags/rdbms" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>rdbms</span></a></p>
Douglas J Hunley<p>Mastering Relational Database Design: A Comprehensive Guide <a href="https://fosstodon.org/tags/rdbms" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>rdbms</span></a> <a href="https://fosstodon.org/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> <a href="https://dev.to/louaiboumediene/mastering-relational-database-design-a-comprehensive-guide-3jh8" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">dev.to/louaiboumediene/masteri</span><span class="invisible">ng-relational-database-design-a-comprehensive-guide-3jh8</span></a></p>
Data Bene<p>We believe one of the best parts about <a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> is it's extensibility (although there is a lot to be celebrated about this incredibly robust <a href="https://fosstodon.org/tags/RDBMS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>RDBMS</span></a>!). As a result, we're avid fans of supporting <a href="https://fosstodon.org/tags/OpenSource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OpenSource</span></a> development.</p><p>One such project we support is <a href="https://fosstodon.org/tags/CitusData" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>CitusData</span></a> - an extension from Microsoft that's great for managing distributed PostgreSQL instances at scale. Learn more about it in the latest Postgres Café episode from <a href="https://fosstodon.org/tags/Xata" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Xata</span></a> + Data Bene:</p><p><a href="https://www.data-bene.io/en/blog/postgres-cafe-deploying-distributed-postgresql-at-scale-with-citus-data/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">data-bene.io/en/blog/postgres-</span><span class="invisible">cafe-deploying-distributed-postgresql-at-scale-with-citus-data/</span></a> </p><p><a href="https://fosstodon.org/tags/techpodcast" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>techpodcast</span></a></p>
Data Bene<p>There's always innovation happening somewhere and amazing folks sharing resources for others to learn thanks to the incredible power of <a href="https://fosstodon.org/tags/OpenSource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OpenSource</span></a>. </p><p>Sometimes these can pop in unexpected ways, such as this <a href="https://fosstodon.org/tags/AwesomeList" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>AwesomeList</span></a> of <a href="https://fosstodon.org/tags/Postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Postgres</span></a> tools &amp; resources:</p><p><a href="https://project-awesome.org/dhamaniasad/awesome-postgres" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">project-awesome.org/dhamaniasa</span><span class="invisible">d/awesome-postgres</span></a></p><p>So, we'd love to hear from you. How do *you* discover or manage your <a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> extensions? </p><p><a href="https://fosstodon.org/tags/foss" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>foss</span></a> <a href="https://fosstodon.org/tags/oss" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>oss</span></a> <a href="https://fosstodon.org/tags/developers" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>developers</span></a> <a href="https://fosstodon.org/tags/devcommunity" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>devcommunity</span></a> <a href="https://fosstodon.org/tags/tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>tech</span></a> <a href="https://fosstodon.org/tags/rdbms" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>rdbms</span></a> <a href="https://fosstodon.org/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a></p>
Data Bene<p>If you aren't already aware of PgPedia, it is an excellent resource for <a href="https://fosstodon.org/tags/developers" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>developers</span></a> using <a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> who want to learn more about upcoming developments, current announcements, general <a href="https://fosstodon.org/tags/Postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Postgres</span></a> content and even specific commits of interest being merged into the codebase. A super helpful aggregation of links run by Ian Barwick.</p><p><a href="https://pgpedia.info/blog/pgpedia-week-2025-01-26.html" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">pgpedia.info/blog/pgpedia-week</span><span class="invisible">-2025-01-26.html</span></a> </p><p><a href="https://fosstodon.org/tags/dev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>dev</span></a> <a href="https://fosstodon.org/tags/tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>tech</span></a> <a href="https://fosstodon.org/tags/opensource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>opensource</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/rdbms" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>rdbms</span></a> <a href="https://fosstodon.org/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> <a href="https://fosstodon.org/tags/learnsql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>learnsql</span></a></p>
Alejandro Baez<p>So <a href="https://fosstodon.org/tags/turso" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>turso</span></a> is doubling down on the <a href="https://fosstodon.org/tags/rust" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>rust</span></a> rewrite of <a href="https://fosstodon.org/tags/sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlite</span></a>. I'm very excited to see what comes out. 😄</p><p>Without question we in a renaissance of <a href="https://fosstodon.org/tags/RDBMS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>RDBMS</span></a> design. 😎</p><p> <a href="https://turso.tech/blog/we-will-rewrite-sqlite-and-we-are-going-all-in" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">turso.tech/blog/we-will-rewrit</span><span class="invisible">e-sqlite-and-we-are-going-all-in</span></a></p>
Data Bene<p><a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> is a five-time winner of “<a href="https://fosstodon.org/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> Management System (DBMS) of the Year” from DB-Engines (&amp; Redgate) after being compared against 423 other monitored systems! <a href="https://fosstodon.org/tags/SnowflakeDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SnowflakeDB</span></a> follows, then <a href="https://fosstodon.org/tags/Microsoft" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Microsoft</span></a>. </p><p>This follows PostgreSQL’s recognition from StackOverflow’s Developer Survey in 2023 and 2024 as the “most popular database”. (And it’s used by 49% of developers as of 2024!) </p><p>Thinking about switching to <a href="https://fosstodon.org/tags/Postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Postgres</span></a>? Get in touch. </p><p><a href="https://fosstodon.org/tags/rdbms" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>rdbms</span></a> <a href="https://fosstodon.org/tags/developer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>developer</span></a> <a href="https://fosstodon.org/tags/Tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Tech</span></a> <a href="https://fosstodon.org/tags/technews" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>technews</span></a> <a href="https://fosstodon.org/tags/OpenSource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OpenSource</span></a> <a href="https://fosstodon.org/tags/FOSS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>FOSS</span></a> <a href="https://fosstodon.org/tags/OSS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OSS</span></a></p>
Douglas J Hunley<p>Understanding Relational vs. Non-relational Databases <a href="https://fosstodon.org/tags/rdbms" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>rdbms</span></a> <a href="https://fosstodon.org/tags/nosql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>nosql</span></a> <a href="https://fosstodon.org/tags/mysql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mysql</span></a> <a href="https://fosstodon.org/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgresql</span></a> <a href="https://www.techspot.com/article/2873-relational-vs-non-relational-databases/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">techspot.com/article/2873-rela</span><span class="invisible">tional-vs-non-relational-databases/</span></a></p>
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>
रञ्जित (Ranjit Mathew)<p>Nice:</p><p>“What I Wish Someone Told Me About Postgres”, Hazel Bachrach (<a href="https://challahscript.com/what_i_wish_someone_told_me_about_postgres" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">challahscript.com/what_i_wish_</span><span class="invisible">someone_told_me_about_postgres</span></a>).</p><p>Via HN: <a href="https://news.ycombinator.com/item?id=42111896" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">news.ycombinator.com/item?id=4</span><span class="invisible">2111896</span></a></p><p>On Lobsters: <a href="https://lobste.rs/s/zgtiib/what_i_wish_someone_told_me_about_postgres" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">lobste.rs/s/zgtiib/what_i_wish</span><span class="invisible">_someone_told_me_about_postgres</span></a></p><p><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/DB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DB</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/Postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Postgres</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/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a></p>
Data Bene<p>We ran a lottery at our booth at <span class="h-card" translate="no"><a href="https://mastodon.social/@pgconfeu" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>pgconfeu</span></a></span> giving away 5 copies of The Art of <a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> by Dimitri Fontaine - five lucky winners have been chosen and notified via email! Check your inboxes if you entered the lottery!</p><p>Check out the book here, if you haven't heard of it already:</p><p><a href="https://theartofpostgresql.com" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">theartofpostgresql.com</span><span class="invisible"></span></a></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/devcommunity" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>devcommunity</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/opensource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>opensource</span></a> <a href="https://fosstodon.org/tags/bookstodon" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>bookstodon</span></a> <a href="https://fosstodon.org/tags/tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>tech</span></a> <a href="https://fosstodon.org/tags/dbms" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>dbms</span></a> <a href="https://fosstodon.org/tags/rdbms" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>rdbms</span></a> <a href="https://fosstodon.org/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> <a href="https://fosstodon.org/tags/learnsql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>learnsql</span></a> <a href="https://fosstodon.org/tags/learnprogramming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>learnprogramming</span></a> <a href="https://fosstodon.org/tags/appdev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>appdev</span></a> <a href="https://fosstodon.org/tags/dev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>dev</span></a> <a href="https://fosstodon.org/tags/pgconfeu" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>pgconfeu</span></a> <a href="https://fosstodon.org/tags/pgconfeu2024" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>pgconfeu2024</span></a></p>
Dave Mason<p>I got some quality SQL Server/database work done with one of the dev team members this week.</p><p>It started out with a request to delete duplicate data from a table. After deleting the dupes, we analyzed the table and identified a natural key and added a composite unique index--no more duplicate data going forward.</p><p>1/X</p><p><a href="https://mastodon.social/tags/SQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLServer</span></a><br><a href="https://mastodon.social/tags/RDBMS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>RDBMS</span></a><br><a href="https://mastodon.social/tags/Development" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Development</span></a></p>
Franck Pachot<p>Two possibilities to avoid write-skew anomalies are serializable isolation level (with implicit range locks) and read committed (with explicit locking). Both are scalable if the SQL schema is normalized <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></p><p><a href="https://dev.to/franckpachot/the-doctors-on-call-shift-example-in-a-normalized-relational-schema-to-avoid-write-skew-4hhf" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">dev.to/franckpachot/the-doctor</span><span class="invisible">s-on-call-shift-example-in-a-normalized-relational-schema-to-avoid-write-skew-4hhf</span></a></p>
André Machado :debian:<p>Ted Codd and Relational Database Model</p><p>Edgar Frank "Ted" Codd (August 23, 1923 – April 18, 2003) was a British computer scientist who fundamentally transformed the field of database management systems with his invention of the relational model for database management. His work laid the foundation for relational databases, which are at the core of modern data storage and processing systems today.</p><p>Read More: <a href="https://machaddr.substack.com/p/ted-codd-and-relational-database" rel="nofollow noopener noreferrer" target="_blank"><span class="invisible">https://</span><span class="ellipsis">machaddr.substack.com/p/ted-co</span><span class="invisible">dd-and-relational-database</span></a></p><p><a href="https://mastodon.sdf.org/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.sdf.org/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.sdf.org/tags/RDBMS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>RDBMS</span></a> <a href="https://mastodon.sdf.org/tags/IBM" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>IBM</span></a> <a href="https://mastodon.sdf.org/tags/Computer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Computer</span></a> <a href="https://mastodon.sdf.org/tags/Science" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Science</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>
Talk to Me About Tech<p>Interesting... anyone using this? What are your experiences / use cases?</p><p>&gt; The Selectable app lets you access your <a href="https://hachyderm.io/tags/Postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Postgres</span></a> database with a beautiful mobile-optimised experience that lets you write complex <a href="https://hachyderm.io/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> queries without breaking a sweat.</p><p><a href="https://getselectable.com" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">getselectable.com</span><span class="invisible"></span></a> </p><p><a href="https://hachyderm.io/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> <a href="https://hachyderm.io/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://hachyderm.io/tags/databases" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>databases</span></a> <a href="https://hachyderm.io/tags/dbms" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>dbms</span></a> <a href="https://hachyderm.io/tags/rdbms" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>rdbms</span></a> <a href="https://hachyderm.io/tags/dba" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>dba</span></a> <a href="https://hachyderm.io/tags/appdev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>appdev</span></a> <a href="https://hachyderm.io/tags/devcommunity" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>devcommunity</span></a> <a href="https://hachyderm.io/tags/devs" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>devs</span></a> <a href="https://hachyderm.io/tags/learnsql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>learnsql</span></a></p>
Waseem<p>What should be preferred for SQL Queries?</p><p>SQL query with sub query<br>vs<br>SQL query with join</p><p><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/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/backend" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>backend</span></a> <a href="https://mastodon.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MySQL</span></a> <a href="https://mastodon.social/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgres</span></a></p>
Talk to Me About Tech<p>Can't make it to <span class="h-card" translate="no"><a href="https://hachyderm.io/@pgdaylowlands" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>pgdaylowlands</span></a></span> this year, but want to see some of the amazing sessions? Hear from some fantastic experts like Henrietta Dombrovskaya, Julien Riou, Lætitia Avrot, Peter Eisentraut, Pavlo Golub and more. You can view the complete schedule here: <br><a href="https://lnkd.in/gh476vvN" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">lnkd.in/gh476vvN</span><span class="invisible"></span></a></p><p>Live stream link (starting in 6 hours!): <br><a href="https://lnkd.in/g6t7gP7H" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">lnkd.in/g6t7gP7H</span><span class="invisible"></span></a></p><p><a href="https://hachyderm.io/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgres</span></a> <a href="https://hachyderm.io/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgresql</span></a> <a href="https://hachyderm.io/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://hachyderm.io/tags/pgday" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>pgday</span></a> <a href="https://hachyderm.io/tags/techevent" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>techevent</span></a>#techwebinar <a href="https://hachyderm.io/tags/devcommunity" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>devcommunity</span></a> <a href="https://hachyderm.io/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> <a href="https://hachyderm.io/tags/rdbms" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>rdbms</span></a></p>