vocalounge.cafe is one of the many independent Mastodon servers you can use to participate in the fediverse.
A Mastodon instance specializing in Vocaloid, UTAU, and anything relevant to vocalsynth culture.

Administered by:

Server stats:

37
active users

#postgresql

1 post1 participant0 posts today
Douglas J Hunley<p>Why pg_dump Is Amazing <a href="https://fosstodon.org/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgresql</span></a> <a href="https://rhaas.blogspot.com/2024/11/why-pgdump-is-amazing.html" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">rhaas.blogspot.com/2024/11/why</span><span class="invisible">-pgdump-is-amazing.html</span></a></p>
Sune Stolborg Vuorela<p>A few years ago, I gave my kid a <a href="https://floss.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> elephant plushie (here named El-El). At <a href="https://floss.social/tags/fosdem" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>fosdem</span></a> this year, I got a selfie with the human sized PostgreSQL mascot. I was asked today when I would bring big El-El to our house.</p>
Linuxiac<p>FerretDB 2.0 open-source document database offers 20x faster performance, MongoDB compatibility, vector search, and more.<br><a href="https://linuxiac.com/ferretdb-2-0-open-source-document-database-goes-ga/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">linuxiac.com/ferretdb-2-0-open</span><span class="invisible">-source-document-database-goes-ga/</span></a></p><p><a href="https://mastodon.social/tags/mongodb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mongodb</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/ferretdb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ferretdb</span></a> <a href="https://mastodon.social/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a></p>
Linuxiac<p>EdgeDB is now Gel, fully supports SQL and integrates seamlessly with Postgres.<br><a href="https://linuxiac.com/edgedb-rebrands-as-gel-brings-full-sql-support/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">linuxiac.com/edgedb-rebrands-a</span><span class="invisible">s-gel-brings-full-sql-support/</span></a></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/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgresql</span></a></p>
Kerrick Long (code)<p>High Performance PostgreSQL for Rails by Andrew Atkinson is part of a 16-ebook $18 bundle! Pragmatic Bookshelf and Humble Bundle have made it available along with Practical A/B Testing, Designing Data Governance from the Ground Up, SQL Antipatterns Vol. 1, and others. Pretty sweet deal!</p><p><a href="https://www.humblebundle.com/books/data-engineering-and-management-pragmatic-books" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">humblebundle.com/books/data-en</span><span class="invisible">gineering-and-management-pragmatic-books</span></a></p><p><a href="https://dotnet.social/tags/Ruby" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Ruby</span></a> <a href="https://dotnet.social/tags/Rails" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Rails</span></a> <a href="https://dotnet.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> <a href="https://dotnet.social/tags/ABTesting" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ABTesting</span></a> <a href="https://dotnet.social/tags/Data" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Data</span></a> <a href="https://dotnet.social/tags/DataGovernance" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataGovernance</span></a> <a href="https://dotnet.social/tags/Phoenix" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Phoenix</span></a> <a href="https://dotnet.social/tags/LiveView" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LiveView</span></a> <a href="https://dotnet.social/tags/Elixir" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Elixir</span></a> <a href="https://dotnet.social/tags/Quanum" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Quanum</span></a> <a href="https://dotnet.social/tags/Prolog" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Prolog</span></a> <a href="https://dotnet.social/tags/MachineLearning" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MachineLearning</span></a> <a href="https://dotnet.social/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Python</span></a> <a href="https://dotnet.social/tags/DataScience" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataScience</span></a> <a href="https://dotnet.social/tags/Math" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Math</span></a> <a href="https://dotnet.social/tags/eBooks" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>eBooks</span></a> <a href="https://dotnet.social/tags/Deal" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Deal</span></a> <a href="https://dotnet.social/tags/reading" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>reading</span></a> <a href="https://dotnet.social/tags/programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>programming</span></a></p>
Douglas J Hunley<p><a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> 17.4, 16.8, 15.12, 14.17, and 13.20 Released! <a href="https://www.postgresql.org/about/news/postgresql-174-168-1512-1417-and-1320-released-3018/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">postgresql.org/about/news/post</span><span class="invisible">gresql-174-168-1512-1417-and-1320-released-3018/</span></a></p>
dakkar<p><span>Ooh, fun.<br><br>In </span><a href="https://s.thenautilus.net/tags/PostgreSQL" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a>:</p><pre><code>set session time zone 'UTC'; select '2025-01-01T00:00:00-0100'::timestamptz::date &gt;= '2025-01-01T00:00:00-0100'; select '2025-01-01T00:00:00+0100'::timestamptz::date &gt;= '2025-01-01T00:00:00+0100'; set session time zone '+0100'; select '2025-01-01T00:00:00-0100'::timestamptz::date &gt;= '2025-01-01T00:00:00-0100'; select '2025-01-01T00:00:00+0100'::timestamptz::date &gt;= '2025-01-01T00:00:00+0100';</code></pre><span>results in true/false/true/true.<br><br>Looks like dates are always interpreted according to the session time zone? I can see the reasoning, but it suprised me a bit.</span><p></p>

If you're thinking about submitting a talk proposal to a #PostgreSQL conference, you're in luck. 💥 There are 6 conference CFPs open now! But some of the CFPs close as soon as Dec 31st, others in Jan or early Feb.

So carpe diem: Submit that talk proposal & share your expertise and interesting stories, successes, failures, insights, whatever.

Also, boosts appreciated 🚀, please tell your friends & teammates so they don't miss their shot!

Some good news to end the year on: Today Christoph Berg emailed to say I am now listed on the official Contributors page for the #PostgreSQL #opensource project!

There are so many ppl ❤️ in Postgres 🐘 who have helped me on this 8.5+ yr journey, both inside & outside of #Microsoft. Thank you! 🙏

And @alvherre tells me that congratulations 👏 are also due to @tchorix, @floord, @intrbiz, & @vyruss. All of whom add so much to the Postgres world. 🐘
postgresql.org/community/contr

www.postgresql.orgPostgreSQL: Contributor Profiles

I'm honoured to share that I've been recognised as a Contributor to the PostgreSQL Project 🥹

I can only thank this wonderful community for its continuing support 🙏

Contributions:
- Maintainer of pg_statviz extension
- Author of PostgreSQL Mistakes and How to Avoid Them, PostgreSQL 16 Administration Cookbook
- Conference organiser, speaker & advocate
- Co-creator of postgres-contrib.org

Check out all contributors:
postgresql.org/community/contr

www.postgresql.orgPostgreSQL: Contributor Profiles
#Job #AdminSys #InfoSec #Entrouvert #LogicielLibre
À la recherche de l’administratrice·eur système (bis)
Entr’ouvert développe Publik, une plateforme de gestion de la relation usager, principalement à destination des collectivités locales (villes, métropoles, départements, régions). Pour donner un ordre de grandeur, en 2024, c'est un peu plus de dix-neuf millions de demandes actives.

Ce sont exclusivement des logiciels libres développés publiquement (git et tickets accessibles). Technologiquement, c'est #Debian, #Python, #Django, #PostgreSQL et c'est le plus souvent hébergé par nos soins (certaines instances sont déployées sur des serveurs des collectivités, mais on tend à éviter ça).
https://www.entrouvert.com/actualites/2024/entrouvert-recherche-une-administratrice-bis/
publik.entrouvert.comPublik - Accueil