#PostgreSQL

One thing I'm still investigating: how to make #SQLite as similar to #PostgreSQL as possible via pragmas (https://www.sqlite.org/pragma.html).

I'm ok sacrificing some speed for referential integrity. I'm currently looking into:

PRAGMA strict = ON;
PRAGMA case_sensitive_like = ON;
PRAGMA recursive_triggers = ON;
PRAGMA automatic_index = ON;
PRAGMA encoding = 'UTF-8';

Anyone have experience with these? I'm thinking about modifying @anze3db benchmark in https://blog.pecar.me/django-sqlite-benchmark to see what the impacts are.

Hey, Fediverse! I'm looking for informed opinions on database choices.

I can stand up an Internet-facing application and have it use either mysql or postgresql. Which is the better choice, and why do you think so?

Thanks!

#Mastodev #SelfHosted #SelfHosting #Postgresql #mysql

Hey, Fediverse! I'm looking for informed opinions on database choices.

I can stand up an Internet-facing application and have it use either mysql or postgresql. Which is the better choice, and why do you think so?

Thanks!

#Mastodev #SelfHosted #SelfHosting #Postgresql #mysql

I'm waivering a bit on my choice to create a single PostgreSQL server for my homelab. This felt like a good idea because I come from the Microsoft world, where every software license costs $$$$$$.

Most applications I want to use combines the database server within the install itself. This ensures no conflicts with other databases and silos performance issues as well. Which sounds like a good idea to me.

The downside - repetitive maintenance task, like backups.

#HomeLab #postgresql

【個人開発】引っ越しで後悔しない！~新卒エンジニアが“住む場所”の選び方を決めるアプリ「LiveSpot」を開発しました~
https://qiita.com/k_ohmikawa/items/bce650e2d861740bc7c3?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #Django #PostgreSQL #ポートフォリオ #React #個人開発

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!

#CFP #CallForSpeakers #OpenSource #conference #database

Database：Optimistic LockとPessimistic Lock
https://qiita.com/Ian_C/items/c3c4cb00a63fb6092a37?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #MySQL #SQL #PostgreSQL

CVE-2024-10979をローカルで再現してみる
https://qiita.com/ikeda_takato/items/df354bcd5953a1c11ef6?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #PostgreSQL #Security #CVE_2024_10979

Apparently #PostgreSQL 18 will offer a new function named uuidv7()!

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=78c5e141e9c139fc2ff36a220334e4aa25e1b0eb

...and here is a hint #2

#postgresql #database #opensource

ジェイソン記念日なのでJSON_TABLEを試してみる
https://qiita.com/sapi_kawahara/items/7b47d236abc042f9afa5?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #PostgreSQL #JSON #初心者 #Database #データべース設計

We know you’re curious about where the next conference will take place, so here’s a first hint.

#postgresql #database #opensource

I looked at several different ways to install Postgres in my Homelab:

Portainer > Docker Container
ProxMox > VM or LXC > Postgres
ProxMox > VM > Supabase
Kubernetes (I'm scared of this lol)

Decided on ProxMox > LXC. Supabase looks cool but I feel like it would hide a lot of things a newbie should really know first.

Installing as an LXC template gave me a Turnkey Linux web interface as well, tho I don't know much about it yet.

Next: A backup plan.

#HomeLab #Postgresql #TurnkeyLinux

PGConf.EU is coming to town...
#postgresql #database #opensource

I haven't had a need to install a database server in my homelab other than sqllite setups for various applications. But I've got two projects that mention a need for them now. Really don't want to pay for this if I can run it locally (is that a dumb idea?).

So, guess it's time to learn something new.

https://www.postgresql.org/download/linux/ubuntu/

#HomeLab #postgresql

I'm a senior backend engineer, did most stuff with #ruby. I like #linux know also #clang the usual scripting stuff, #python. I know a little bit #java did #openshift ( #kubernetes ) and #docker containers. My preferred database is #postgresql

Is someone searching for #vienna in #austria ? I mean finding a job should not be hard with that kind of profile, right?

#GetFediHired

Find some great PostgreSQL videos from PGconf.EU 2024 on https://www.youtube.com/playlist?list=PLF36ND7b_WU4QL6bA28NrzBOevqUYiPYq and don't forget to subscribe!
#postgresql #database #opensource #athens #speakers #postgres

#PostgreSQL 17.2, 16.6, 15.10, 14.15, 13.18, and 12.22 Released! https://www.postgresql.org/about/news/postgresql-172-166-1510-1415-1318-and-1222-released-2965/

PGConf.EU 2024 Lightning Talks

https://andreas.scherbaum.la/post/2024-11-19_pgconf-eu-2024-lightning-talks/

#PGConf.EU #Athens #Greece #Conference #PostgreSQL #LightningTalks #Talk #Presentation

Save the date: PostgreSQL Meetup in Hamburg on Dec. 11th, 18:00 CET with two exciting talks:

"Merging Forces: Enhancing PostgreSQL with DuckDB's Analytical Power" by Sascha Lorenz, and "PostgreSQL in the Age of Cloud Computing & AI: Strategies from an Industry Veteran" by @saschadittmann

RSVP here: https://www.meetup.com/hamburg-pug/events/303680581/

#meetup #Hamburg #postgresql #cloud #duckdb #event

We're always looking for speakers for our virtual Meetups! Got something to share? We'd love to hear from you! Drop us a DM and you could be our next speaker!

#speaker #postgres #PostgreSQL #bayareapostgres

Hey #PostgreSQL ppl, this Wed 13 Nov at 10:00am PST, I'll be doing a LIVE recording of Ep21 of the #TalkingPostgres podcast with my guest @andatki

Topic this month = Helping Rails developers learn Postgres.

Join us! Calendar invite: https://aka.ms/TalkingPostgres-Ep21-cal

(or you can listen to the episode after we publish on all the platforms. You can find all the podcast episodes here: https://TalkingPostgres.com)

#Postgres #databases #community #opensource #Microsoft

Transaction Isolation in Postgres, explained

https://www.thenile.dev/blog/transaction-isolation-postgres

#postgresql

Hmmm du coup la création de l'user c'est okay :

createuser --createdb --pwprompt hollo
Enter password for new role: 
Enter it again: 

                                   List of roles
 Role name |                         Attributes                         | Member of 
-----------+------------------------------------------------------------+-----------
 freebox   |                                                            | {}
 hollo     | Create DB                                                  | {}
 postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

createdb --username=hollo --encoding=utf8 --template=postgres hollo
createdb: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  Peer authentication failed for user "hollo"

I was honoured to serve on the @pgconfeu organising committee, #PGConfEU #Athens 2024 was awesome in no small part due to the amazing #PostgreSQL #Community. As always, I wish there was more time to meet more of you, but we can always do this at the next #Postgres event. Many thanks to all the committees, volunteers, sponsors, speakers and attendees that helped make this #conference a reality. 🥰

#openSource #database

Da var dette over for i år

#Postgresql

New (more or less) #PostgreSQL folks and projects on Mastodon:

@fljdin
@valgog
@pgconfdev
@jonahharris
@pjmodos
@BayAreaPostgres
@flavio
@yrashk
@katharinesaar

Do you know other account? Please let me know.

Previous postings:
https://mastodon.social/@ascherbaum/109319603453401009
https://mastodon.social/@ascherbaum/109382856990028550
https://mastodon.social/@ascherbaum/109541161628270452
https://mastodon.social/@ascherbaum/109778860645844896
https://mastodon.social/@ascherbaum/110689201525340594
https://mastodon.social/@ascherbaum/111902934327303738

Backup your postgres database to Hetzner S3 Object Storage: https://blog.popescul.com/posts/2024-10-12-backup-postgresql-with-docker/ #postgresql #hetzner #docker

Hello good morning!

I have some consulting time available in the near future. Let me know if you're looking for help with something like:

- #Ruby #Rails
- #Stripe or other payment provider integrations
- #Database performance optimization, particularly #Postgresql
- Architecture analysis

Website and email are in my profile or feel free to DM me.

(also, cliche, but boosts very much welcome!)

#fedihired #fedihire

#PostgreSQL v10 was released today, 7 years ago, and is now EOL for 2 years already.

Are you still running v10, or older? Do you have plans for an upgrade?

#PostgreSQL v14 is now exactly 3 years old, on this day, released on September 30th, 2021.

This version has two more years of support before it is end of life. It's a good time to start with plans for a migration to a newer version.

PostgreSQL is now officially the #2 preferred NoSQL database by Rails developers. 🙃

(That's as of this year, they didn't poll Postgres/JSONB previously.)

Source: https://railsdeveloper.com/survey/2024/#which-nosql-databases-do-you-use

#postgres #postgresql #rails #nosql #sql

PostgreSQL Person of the Week interview with: Nicolas Payart

https://postgresql.life/post/nicolas_payart/

#PostgreSQL #Interview

#PostgreSQL Contributions week 38

* New logo for PGEU diversity committee
* #Postgres community migration to #Mastodon
* Translations for the upcoming v17 release

https://postgres-contrib.org/post/14/

I just wrote and article... :)

https://dev.to/lifen/as-rails-developers-why-we-are-excited-about-postgresql-17-27nj

#Rails #postgresql

Feels more and more that all the so-called friends of #foss have fallen:

#Google , #Mozilla , #Canonical , #Microsoft , #GitHub , #Mastodon , #RedHat ... the list goes on.

Who is really left? #Linux #Debian #postgresql ?

Tickets for #PGConfEU in #Athens this year are selling quicker than previous years. Get your ticket soon!

The agenda with talks is available on the conference website, in case you need another reason to convince you to come to #Greece.

See you there!

#PostgreSQL #Conference @pgconfeu

Magnus Hagander on #PostgreSQL 17 development: commit fests, feature freezes, release candidates and that when we're counting LoC, let's count deletions (sad of course when it's features but they'll have another shot for 18) @pgdayuk

With all the new Mastodon users, it’s maybe time I wrote my #introduction (a.k.a. #introductions)

I am a father of 2, husband of 1. I live in The Netherlands.

I work as a freelance Database Admin for several companies, using #postgresql #oracle #mysql and many others. I also do some related stuff like #linux #ansible #kubernetes etc.

1/2

Hey folks, I'm looking for a new role.

I specialize in software delivery, reliability, and performance for growing organizations.

Contact me when your:

- systems getting too slow or old
- IT solutions are getting too expensive
- software and infra takes too long to change
- customers face too many bugs or outages

I often work with #OpenSource projects like: #Perl #Gentoo #Linux #PostgreSQL #SQLite #Laminar #CICD #Rex #OpenStack

See my profile & DM me for details!

#GetFediHired

🌿 Data Bene: Your go-to #PostgreSQL service provider and #FOSS advocate. We're globally distributed with decades of experience working with Postgres and open source technologies. We're committed to preventing vendor lock-in and promoting sustainable and secure business practices. Follow us for content around the Postgres community, open-source and cybersecurity news, and sustainable practices in tech. 🐘

#introduction #tech #technology #OpenSource #Postgres

New Meetup group "Postgres Meetup for All", organizing online meetups.

Join to see the upcoming talks, or contact the organizers if you want to present.

#PostgreSQL #Postgres #Meetup

https://www.meetup.com/postgres-meetup-for-all/

🐳 If you are using the very, very old official PostgreSQL Docker image for PostgreSQL 8 (`postgres:8`), you might be interested in https://hub.docker.com/r/joschi/postgres8 which is a identical copy of the Docker image (`postgres:8`, `posgres:8.4`, `postgres:8.4.22`) which was still using the deprecated and planned for removal image manifest v2 schema 1 and "Docker Image v1" formats.

https://docs.docker.com/engine/deprecated/#pushing-and-pulling-with-image-manifest-v2-schema-1

#Docker #PostgreSQL #Deprecation

What is it?

• Aardwolf-Social aims to be a familiar and user-friendly federated social-media application. Choices have been made to replicate the visual feel, and functionality of Facebook with some elements also being borrowed from Mastodon (hence familiar).

Who is it for?

• Anyone that wants to use a privacy-oriented social-media site with Facebook-like feature set.

Planned Features at a Glance

• Familiar user interface
• Long-form posting
• Calendar
• Groups
• Integration with existing Fediverse networks (Mastodon, PixelFed, others)

Current Status

• In Development, not ready for use

Technical Details

• Built with #RustLang for reasons of code security, and performance
• Designed to be Modular! Though it is being developed as a packaged application, the project is actually split into multiple logical parts that can be swapped to suit the needs of the developer/sysadmin.
• Frontend: Currently using #YewFramework (WASM), #Bulma (CSS Framework), and #ForkAwesome (Icons)
• Backend: Currently using #Actix, and #PostgreSQL
• Docker images are planned, developer images were working but need to be refreshed.

Contributing

• There are two repositories "Aardwolf" and "Aardwolf-Interface". Aardwolf is the primary repo for the application, and brings all of the parts together (Actix backend, DB Models, UI Templates/Translations, Rust Types). Aardwolf-Interface is a secondary repository for being able to work on the user interface without the need for a complete Rust development environment.

• The main repo (Aardwolf) has been recently updated to run on Rust stable, but uses the Ructe template system which was never fully implemented.

• The interface repo is presently where all of the Yew framework updates are being done. Approximately 80% of the HTML has been added to the Yew application but so far none of the routing or functionality has been added.

LINKS
This is the GitHub Organization Page. The two Pinned repositories are the ones being actively developed.
https://github.com/Aardwolf-Social

I accept a few new customers in the coming weeks.

I'm on a mission to enable high performance IT systems and software delivery for growing organizations.

Contact me when your:

- systems getting too slow or old
- IT solutions are getting too expensive
- software and infra takes too long to change
- customers face too many bugs or outages

I often work with #OpenSource projects like: #Perl #Gentoo #Linux #PostgreSQL #SQLite #Laminar #CICD #Rex

See my profile & DM me for details!

#GetFediHired

Want a sneak peek at some of the accepted PGConf.EU conference talks? Here: https://www.postgresql.eu/events/pgconfeu2024/sessions/. Other sessions are still pending speaker confirmations as we’re tirelessly working on putting together the schedule.

#postgresql #database #opensource #athens

Sentry is hiring Senior Software Engineer, Platform

🔧 #golang #python #rust #django #kafka #postgresql #redis #seniorengineer
🌎 Toronto, Canada
⏰ Full-time
🏢 Sentry

Job details https://jobsfordevelopers.com/jobs/senior-software-engineer-platform-at-sentry-io-feb-22-2024-9c4dd4?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring

The web-based open source software #CATMAID was devised as "google maps but for volumes". Documentation at https://catmaid.org and source code at https://github.com/catmaid/CATMAID/

Modern #CATMAID enables hundreds of #neuroscience researchers world wide to collaboratively map neuronal circuits in large datasets, e.g., 100 TB or larger, limited only by bandwidth and server-side storage. The goal: to map and analyse a whole brain #connectome.

Running client-side on #javascript and server-side on #django #python #postgresql, it's a pleasure to use–if I may say so–and easy to hack on to extend its functionality with further widgets.

The first minimally viable product was produced in 2007 by Stephan Saalfeld (what we now refer to, dearly, as "Ice Age CATMAID), who demonstrated to us all that the web, and javascript, where the way to go for distributed, collaborative annotation of large datasets accessed piece-wise. See the original paper: https://academic.oup.com/bioinformatics/article-abstract/25/15/1984/210794

See also public instances at the #VirtulaFlyBrain http://virtualflybrain.org/ particularly under "tools - CATMAID - hosted EM data such as this #Drosophila first instar larval volume of its complete nervous system https://l1em.catmaid.virtualflybrain.org/?pid=1&zp=108250&yp=82961.59999999999&xp=54210.799999999996&tool=tracingtool&sid0=1&s0=2.4999999999999996&help=true&layout=h(XY,%20%7B%20type:%20%22neuron-search%22,%20id:%20%22neuron-search-1%22,%20options:%20%7B%22annotation-name%22:%20%22papers%22%7D%7D,%200.6)

Doing SQL for over two decades. I used Oracle, SQL Server, MySQL/MariaDB and in the last 6+ years PostgreSQL.

I can say with confidence, PostgreSQL is for almost all cases *the best* option, by far.

At this point I'd say that there is no justification to pay exorbitant license fees for Oracle or SQL Server for any new project. Except for very few niche use cases, PostgreSQL offers more features, *and* better performance, even compared to Oracle.

If you _must_ use Oracle/SQL Server for a legacy project, consider hiring a professional to migrate your project. It'll pay off next time when Microsoft or Oracle start to count your CPU cores.

#sql #postgresql #SQLServer #oracle #mysql

Mon #introduction
Un gentil administrateur de bases de données (#PostgreSQL).
Je suis sous #Linux depuis très (très) longtemps.

J'aime l’esprit du logiciel libre et de ses communautés.

Je suis en télétravail depuis de nombreuses années et quand je ne travaille pas :
- promener mes #chiens (et parfois mon #chat) dans la forêt
- cuisiner pour mes filles (et elles sont difficiles)
- cultiver mon #potager punk
- chercher les œufs que mes #poules cachent dans le jardin
(suppression auto des msg)

From 2 amazing open source projects #Rails & #PostgreSQL, w/ 9 months writing to 1st draft, 12 mo. editing to “in print,” 15 chapters, 26 mo. since contract signing, 35 contributors, 450 pages, & 900 newsletter subs…

📖🚀 It’s done and in print! TY! 🥳

https://mastodon.social/@andatki/110979864532653417

Karen Jex: When I grow up I want to be a Database Administrator (said no-one ever) https://karenjex.blogspot.com/2024/06/httpskarenjex.blogspot.com202406when-i-grow-up.html.html
#postgres #postgresql

📘 Big news! My book-in-progress "PostgreSQL Mistakes and How to Avoid Them" is now available in @ManningPublications Early Access Program (MEAP) — I hope it will help application developers, software architects & database administrators not only avoid mistakes but also learn the right way to do things in #Postgres.

Use code "au35ang" to get 35% off 💕

🌐 http://mng.bz/D9mR

#PostgreSQL #Manning #MEAP #Development #Databases #OpenSource #TechBooks #BookLaunch

Couldn't be prouder to announce the release of the PostgreSQL 16 Administration Cookbook! Massive thanks to my co-authors Gianni Ciolli, Boriss Mejías @tchorix, Vibhor Kumar and Simon Riggs, and Packt for a spectacular effort on a book that is bound to be a valuable resource for the #PostgreSQL community.

🌐 Amazon: https://packt.link/6PurB

🌐 Packt: https://www.packtpub.com/product/postgresql-16-administration-cookbook/9781835460580

🌐 Amazon UK: https://www.amazon.co.uk/PostgreSQL-Administration-Cookbook-real-world-challenges/dp/1835460585

#postgres #opensource #database #databases #administration #dba #book #cookbook

Hello! I am part of the Twitter migration & just changed servers, am now on hachyderm.io. About me:

* Work on open source PostgreSQL community initiatives at Microsoft
* Live in California in USA, a transplant from NH
* Host of Talking Postgres #podcast
* Co-creator of POSETTE: An Event for Postgres (formerly Citus Con)
* Love sailing in Greek islands
* Alum of Sun, Amazon/A9, Citus Data, and Brown CS
* Love chocolate lab

#introduction #PostgreSQL #Citus #PosetteConf #OpenSource #Community

So hey! I started my computer journey with a Sinclair ZX Spectrum in 1984, studied Computing Science and worked for a bunch of companies, mainly in #software #architecture. I discovered #opensource 25 years ago and never stopped using it & engaging with the community. I'm now lucky enough to work in a #PostgreSQL #Database related role, occasionally contribute to #Postgres & frequently speak about it at conferences. I also sing and play the guitar & keyboards (badly). #introduction