handmade.social

0 posts0 participants0 posts today

Bumblebee 🐝EspritsCollaboratifs, la boite où je bosse, recrute une ou un adminSys en CDI, à Fontenay-sous-Bois dans l'est parisien, ou en télétravail : <a href="https://www.curebot.fr/recrutements/#jobs" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://www.curebot.fr/recrutements/#jobs</a><a href="https://mamot.fr/tags/jeRecrute" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#jeRecrute</a> <a href="https://mamot.fr/tags/job" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#job</a> <a href="https://mamot.fr/tags/adminSys" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#adminSys</a> <a href="https://mamot.fr/tags/linux" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#linux</a> <a href="https://mamot.fr/tags/ansible" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ansible</a> <a href="https://mamot.fr/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgresql</a> <a href="https://mamot.fr/tags/elasticsearch" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#elasticsearch</a> <a href="https://mamot.fr/tags/python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#python</a>

Lutin DiscretWhy would someone use the `COALESCE` function passing a single argument (it's allowed according to the docs)? 🤔<a href="https://www.postgresql.org/docs/current/functions-conditional.html#FUNCTIONS-COALESCE-NVL-IFNULL" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://www.postgresql.org/docs/current/functions-conditional.html#FUNCTIONS-COALESCE-NVL-IFNULL</a><a href="https://mastodon.libre-entreprise.com/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sql</a> <a href="https://mastodon.libre-entreprise.com/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgresql</a>

Mad A. Argon :qurio: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">#Postgres</a> has the best regeneration ability I've ever seen. And currently "the best ability" includes:> 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">#database</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.> 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:).> 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. 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: 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: <a href="https://is-a.cat/tags/admin" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#admin</a> <a href="https://is-a.cat/tags/sysadmin" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sysadmin</a> <a href="https://is-a.cat/tags/it" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#it</a> <a href="https://is-a.cat/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgresql</a>

Andreas ScherbaumNew (more or less) <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a> folks and projects on Mastodon:<a href="https://mastodon.social/@bilgegunduz" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@bilgegunduz</a> <a href="https://fosstodon.org/@ehstanton" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@ehstanton</a> <a href="https://mastodon.social/@pgxn" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@pgxn</a> <a href="https://mastodon.social/@emmasaroyan" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@emmasaroyan</a> <a href="https://mastodon.social/@edbpostgres" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@edbpostgres</a> <a href="https://mastodon.tetaneutral.net/@c2main" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@c2main</a> <a href="https://mastodon.social/@corneliabiacsics" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@corneliabiacsics</a> <a href="https://mastodon.social/@dougortiz" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@dougortiz</a> <a href="https://mastodon.social/@CloudNativePG" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@CloudNativePG</a> <a href="https://mastodon.online/@dalibo" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@dalibo</a>Do you know other account? Please let me know.Previous postings: <a href="https://mastodon.social/@ascherbaum/109319603453401009" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://mastodon.social/@ascherbaum/109319603453401009</a> <a href="https://mastodon.social/@ascherbaum/109382856990028550" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://mastodon.social/@ascherbaum/109382856990028550</a> <a href="https://mastodon.social/@ascherbaum/109541161628270452" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://mastodon.social/@ascherbaum/109541161628270452</a> <a href="https://mastodon.social/@ascherbaum/109778860645844896" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://mastodon.social/@ascherbaum/109778860645844896</a> <a href="https://mastodon.social/@ascherbaum/110689201525340594" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://mastodon.social/@ascherbaum/110689201525340594</a> <a href="https://mastodon.social/@ascherbaum/111902934327303738" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://mastodon.social/@ascherbaum/111902934327303738</a> <a href="https://mastodon.social/@ascherbaum/113329503663749302" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://mastodon.social/@ascherbaum/113329503663749302</a>

Mad A. Argon :qurio:Me 2 years ago: <a href="https://is-a.cat/tags/Kubernetes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Kubernetes</a> is software with biggest regeneration ability.Me 6 months ago: Wow, Longhorn has even better regeneration ability!Me now: What the hell, Patroni has the best regeneration ability I have ever seen!:neofox_laugh_256: Welcome to our brave new world of self-fixing things...<a href="https://is-a.cat/tags/admin" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#admin</a> <a href="https://is-a.cat/tags/sysadmin" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sysadmin</a> <a href="https://is-a.cat/tags/devops" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#devops</a> <a href="https://is-a.cat/tags/IT" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#IT</a> <a href="https://is-a.cat/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgres</a> <a href="https://is-a.cat/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgresql</a> <a href="https://is-a.cat/tags/k8s" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#k8s</a>

dommCreating a lot Postgres roles with random passwords stored in gopass <a href="http://domm.plix.at/perl/2025_03_create_postgres_roles_with_gopass.html" rel="nofollow noopener noreferrer" translate="no" target="_blank">http://domm.plix.at/perl/2025_03_create_postgres_roles_with_gopass.html</a> <a href="https://social.linux.pizza/tags/Perl" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Perl</a> <a href="https://social.linux.pizza/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a>

DeManiak 🇿🇦Some thoughts on my preliminary investigation of <a href="https://mastodon.africa/tags/Omeka" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Omeka</a> ( <a href="https://omeka.org/classic/docs/Installation/Installing/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://omeka.org/classic/docs/Installation/Installing/</a> ).Built on pretty standard <a href="https://mastodon.africa/tags/LAMP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#LAMP</a> stack. No official docker image that I could find, so of course I built my own. Which reminded me why I HATE php.Anyway.Some light testing (running locally). Pretty simple to use (good). No fancy ideas about creating "presentation" versions of items, and keeping the original upload "pristine". I am of two minds on this - for now, not a problem for me, but I can see how large archives might be problematic.For example, a MOV file needs to be presented as a MP4 for widest audience. And you probably don't want to lose the original. With Omeka that means some manual work on the admin side.It support plugins and themes - I'm of two minds here also. Good way to extend functionality and allow for customization, but my experience with such things are not good ito longterm stabililty and maintenance.I'm also not super keen on <a href="https://mastodon.africa/tags/MySQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MySQL</a> as the db, due to recent corruptions issues with my <a href="https://mastodon.africa/tags/Nextcloud" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Nextcloud</a> instance (moved that to <a href="https://mastodon.africa/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a> ). BUT, this will be read heavy, so maybe not an issue - hard-ish to corrupt a db by reading from it.The useage of <a href="https://mastodon.africa/tags/DublinCore" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DublinCore</a> at least means (I think) in theory, if I really want, I should be able to migrate to another Dublin Core compatible system if needed. So...good.My verdict - I'm going to play with it some more. Install some plugins etc, see what happens. I'm also building up a test set of assets, in case I want to eval something else.<a href="https://mastodon.africa/tags/Selfhosted" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Selfhosted</a> <a href="https://mastodon.africa/tags/DigitalArchiveManagement" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DigitalArchiveManagement</a>

GNU/Linux.chFediverse-Serie: Vernissage hostenVernissage ist eine Plattform zum Teilen von Fotos. Vernissage ist Teil des Fediverse und verbunden mit anderen Vernissage-Servern, Mastodon, Pixelfed und vielen weiteren Diensten. <a href="https://social.anoxinon.de/tags/Vernissage" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Vernissage</a> <a href="https://social.anoxinon.de/tags/Fediverse" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Fediverse</a> <a href="https://social.anoxinon.de/tags/Selfhosting" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Selfhosting</a> <a href="https://social.anoxinon.de/tags/Docker" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Docker</a> <a href="https://social.anoxinon.de/tags/Instagram" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Instagram</a> <a href="https://social.anoxinon.de/tags/Pixelfed" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Pixelfed</a> <a href="https://social.anoxinon.de/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a> <a href="https://social.anoxinon.de/tags/Fotografie" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Fotografie</a> <a href="https://social.anoxinon.de/tags/Fotovorschlag" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Fotovorschlag</a> <a href="https://social.anoxinon.de/tags/Linux" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Linux</a><a href="https://gnulinux.ch/fediverse-serie-vernissage-hosten" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://gnulinux.ch/fediverse-serie-vernissage-hosten</a>

Jobs for DevelopersWorkato is hiring Senior Infrastructure Engineer🔧 <a href="https://mastodon.world/tags/java" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#java</a> <a href="https://mastodon.world/tags/python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#python</a> <a href="https://mastodon.world/tags/ruby" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ruby</a> <a href="https://mastodon.world/tags/aws" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#aws</a> <a href="https://mastodon.world/tags/azure" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#azure</a> <a href="https://mastodon.world/tags/docker" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#docker</a> <a href="https://mastodon.world/tags/gcp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#gcp</a> <a href="https://mastodon.world/tags/kubernetes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#kubernetes</a> <a href="https://mastodon.world/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgresql</a> <a href="https://mastodon.world/tags/terraform" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#terraform</a> <a href="https://mastodon.world/tags/seniorengineer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#seniorengineer</a> 🌎 Nicosia, Cyprus ⏰ Full-time 🏢 WorkatoJob details <a href="https://jobsfordevelopers.com/jobs/senior-infrastructure-engineer-at-workato-com-dec-9-2024-9e1242?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://jobsfordevelopers.com/jobs/senior-infrastructure-engineer-at-workato-com-dec-9-2024-9e1242?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting</a> <a href="https://mastodon.world/tags/jobalert" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#jobalert</a> <a href="https://mastodon.world/tags/jobsearch" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#jobsearch</a> <a href="https://mastodon.world/tags/hiring" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#hiring</a>

Valvin (framapiaf)Hello, je ne connais pas spécialement la boîte mais ils sont à la recherche d'un administrateur système / devops qui aime travailler avec des outils Libre / OpenSource. Ils sont basés à Toulouse.Ça pourrait peut-être vous intéresser?Lien (welcome to the jungle): <a href="https://www.welcometothejungle.com/fr/companies/makina-corpus/jobs/administrateur-systeme-et-devops-f-h_toulouse" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://www.welcometothejungle.com/fr/companies/makina-corpus/jobs/administrateur-systeme-et-devops-f-h_toulouse</a><a href="https://framapiaf.org/tags/job" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#job</a> <a href="https://framapiaf.org/tags/devops" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#devops</a> <a href="https://framapiaf.org/tags/linux" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#linux</a> <a href="https://framapiaf.org/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgresql</a> <a href="https://framapiaf.org/tags/toulouse" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#toulouse</a>

Sarah ConwayNew <a href="https://infosec.exchange/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a> event announcement - Postgres Extensions Day 2025 in Montreal is "a full day dedicated to extensions – their development, lifecycle, and so on. A perfect event for extension developers and heavy extension users."It's a free event and you can register now: <a href="https://pgext.day/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://pgext.day/</a>Call for Speakers is open until April 1st. <a href="https://sessionize.com/pgextday2025mtl" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://sessionize.com/pgextday2025mtl</a><a href="https://infosec.exchange/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgres</a> <a href="https://infosec.exchange/tags/tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#tech</a> <a href="https://infosec.exchange/tags/techevent" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#techevent</a> <a href="https://infosec.exchange/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sql</a> <a href="https://infosec.exchange/tags/montreal" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#montreal</a> <a href="https://infosec.exchange/tags/canada" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#canada</a> <a href="https://infosec.exchange/tags/learnsql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#learnsql</a> <a href="https://infosec.exchange/tags/data" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#data</a> <a href="https://infosec.exchange/tags/datamanagement" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#datamanagement</a> <a href="https://infosec.exchange/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#database</a> <a href="https://infosec.exchange/tags/freesoftware" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#freesoftware</a> <a href="https://infosec.exchange/tags/opensource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#opensource</a> <a href="https://infosec.exchange/tags/foss" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#foss</a> <a href="https://infosec.exchange/tags/oss" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#oss</a>

Data BeneIt’s time for our sixth and technically final episode of <a href="https://fosstodon.org/tags/Postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Postgres</a> Café! <a href="https://bird.makeup/users/apatheticmagpie" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@apatheticmagpie</a> and <a href="https://infosec.exchange/@talktomeabouttech" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@talktomeabouttech</a> here discuss with Andrea the power of contributing to <a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a> through extension development & event participation, with many of the discussion points applying to contributions to <a href="https://fosstodon.org/tags/OpenSource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#OpenSource</a> in general. <a href="https://www.data-bene.io/en/blog/postgres-cafe-contributing-to-open-source/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://www.data-bene.io/en/blog/postgres-cafe-contributing-to-open-source/</a> Are you interested in us producing more of this podcast with Xata on <a href="https://fosstodon.org/tags/Postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Postgres</a> extensions, open source, <a href="https://fosstodon.org/tags/community" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#community</a>, & similar topics? 💬 <a href="https://fosstodon.org/tags/tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#tech</a> <a href="https://fosstodon.org/tags/dev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dev</a>

nixCraft 🐧The Internals of PostgreSQL for DBAs and developers <a href="https://www.interdb.jp/pg/index.html" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://www.interdb.jp/pg/index.html</a><a href="https://mastodon.social/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgresql</a> <a href="https://mastodon.social/tags/sysadmin" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sysadmin</a> <a href="https://mastodon.social/tags/opensource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#opensource</a>

Joche OjedaSetting Up WSL 2: My Development Environment Scripts<a href="https://www.jocheojeda.com/2025/02/24/setting-up-wsl-2-my-development-environment-scripts/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://www.jocheojeda.com/2025/02/24/setting-up-wsl-2-my-development-environment-scripts/</a><a href="https://mastodon.social/tags/wsl2" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#wsl2</a> <a href="https://mastodon.social/tags/development" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#development</a> <a href="https://mastodon.social/tags/scripts" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#scripts</a> <a href="https://mastodon.social/tags/automation" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#automation</a> <a href="https://mastodon.social/tags/windows" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#windows</a> <a href="https://mastodon.social/tags/surface" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#surface</a> <a href="https://mastodon.social/tags/developmentenvironment" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#developmentenvironment</a> <a href="https://mastodon.social/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgresql</a> <a href="https://mastodon.social/tags/mysql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mysql</a> <a href="https://mastodon.social/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#database</a> <a href="https://mastodon.social/tags/testing" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#testing</a> <a href="https://mastodon.social/tags/dotnet" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dotnet</a> <a href="https://mastodon.social/tags/setup" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#setup</a> <a href="https://mastodon.social/tags/developmenttools" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#developmenttools</a>

Scott Williams 🐧And here's financial data for various USA federal agencies going back to 2001 in one big <a href="https://mastodon.online/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgresql</a> database.FYI: This repo uses git-lfs.<a href="https://git.lsit.ucsb.edu/publicdata/usaspending" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://git.lsit.ucsb.edu/publicdata/usaspending</a><a href="https://mastodon.online/tags/data" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#data</a> <a href="https://mastodon.online/tags/datarescue" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#datarescue</a>

Hacker News 50Reliably Replicating Data Between PostgreSQL and ClickHouseLink: <a href="https://benjaminwootton.com/insights/clickhouse-peerdb-cdc/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://benjaminwootton.com/insights/clickhouse-peerdb-cdc/</a> Discussion: <a href="https://news.ycombinator.com/item?id=43111294" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://news.ycombinator.com/item?id=43111294</a><a href="https://social.lansky.name/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgresql</a>

Douglas J Hunley<a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</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">https://www.postgresql.org/about/news/postgresql-174-168-1512-1417-and-1320-released-3018/</a>

DokzaThis has been pretty successful week in my <a href="https://infosec.exchange/tags/selfhosting" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#selfhosting</a> journey. I got <a href="https://infosec.exchange/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgresql</a> running early in the week. I then made my own personal database to play with and got databases running for <a href="https://infosec.exchange/tags/freshrss" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#freshrss</a>, <a href="https://infosec.exchange/tags/redmine" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#redmine</a>, <a href="https://infosec.exchange/tags/vikunja" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#vikunja</a>, and finally <a href="https://infosec.exchange/tags/forgejo" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#forgejo</a>. Once I was happy with the setup I did pg_dumpall because I know today I'll probably get over confident and break something. First thing I'm going to do this morning is setup another postgresql <a href="https://infosec.exchange/tags/docker" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#docker</a> and make sure I understand how to import pg_dumpall. For years I've only queried databases. Setting these up and seeing the data behind the applications has been lot of fun! The access to this data makes me highly motivated to use it in my own ways such as populating my personal database with various stats and then learning Python and Flask to build simple tools for myself. <a href="https://infosec.exchange/tags/learning" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#learning</a>

Inautilo<a href="https://mastodon.social/tags/Development" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Development</a> <a href="https://mastodon.social/tags/Launches" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Launches</a> SQL Noir · A game to learn SQL by solving crimes <a href="https://ilo.im/162ciw" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://ilo.im/162ciw</a>_____ <a href="https://mastodon.social/tags/OpenSource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#OpenSource</a> <a href="https://mastodon.social/tags/Game" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Game</a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Database</a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQL</a> <a href="https://mastodon.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MySQL</a> <a href="https://mastodon.social/tags/SQLite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLite</a> <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a> <a href="https://mastodon.social/tags/Npm" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Npm</a> <a href="https://mastodon.social/tags/WebDev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#WebDev</a> <a href="https://mastodon.social/tags/Backend" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Backend</a>

DaliboRELEASE : <a href="https://mastodon.online/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a> Anonymizer sort sa version 2.0. La nouveauté majeure : sa réécriture en <a href="https://mastodon.online/tags/rust" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#rust</a> => <a href="https://dali.bo/202502_pg-anonymizer2-0" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://dali.bo/202502_pg-anonymizer2-0</a>Bravo à <a href="https://framapiaf.org/@daamien" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@daamien</a> et aux autres contributeurs ! 💐 <a href="https://mastodon.online/tags/SGBD" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SGBD</a> <a href="https://mastodon.online/tags/opensource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#opensource</a> <a href="https://mastodon.online/tags/logicielsLibres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#logicielsLibres</a> <a href="https://mastodon.online/tags/RGPD" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#RGPD</a> <a href="https://mastodon.online/tags/anonymisation" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#anonymisation</a> <a href="https://mastodon.online/tags/dalibolabs" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dalibolabs</a>

Recent searches

Search options

Administered by:

Server stats:

#PostgreSQL