Notices tagged with postgresql, page 2

Esta es la lista con los capítulos del tutorial de #PostgreSQL y el lenguaje #SQL:

https://www.youtube.com/watch?v=8_HFyjcUt6Q&list=PLtdeXn2f7ZbNOTrW0POHNuoNbgpc-Qo-6.

Suscríbete a mi canal.

#bbdd #Programacion #SiguemeYTeSigo #Followback

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

If I wanted to implement full-text search in #PostgreSQL, what would be the best way to go about it?

Learn how to use pgvector, the #PostgreSQL extension for vector storage and querying, from Python scripts and web apps 🐍

Tune in to @pamelafox's talk during #PosetteConf Livestream 3 at 9:30am PDT on June 12, 2024 🗓️
https://aka.ms/posette-schedule-livestream3

Did you know that you can write #PostgreSQL stored procedures in #SwiftLang? "Bringing Swift to the Backend of the Backend’s Backend!"
http://www.alwaysrightinstitute.com/plswift/

Added full-text search to #PieFed today.

After reading a massive tome about #ElasticSearch earlier this week I realised it was complete overkill and just used the full-text capabilities of #PostgreSQL instead.

Currently PieFed has 46,000 posts and results are fast. It'll be interesting to see how well it copes when there are more posts. Anyone want to make a guess when it'll bog down?

https://piefed.social/post/48889

Dear #Fediverse, I ask you for #help 🌌

Recommend me some #books to buy on 📚
• #Python (language)
• #Django
• #Accessibility (#web)
• #PostgreSQL
• #ArtificialIntelligence
• #DesignPatterns
• #FreeSoftware
• #OpenSource

I'd like to have 🪪
• author
• title
• suggestion reason
• purchase URL

I prefer #ePUB (more than Amazon and content with DRM), but #paperback is fine if there are no alternatives ✨

Thank you 🙏

P.S. It's fine to propose books that you've written 👍

P.P.S. #boost please 🔁

0.18.5に更新した #Lemmy サーバはまあ順調に連合しているみたい。インスタンスのリストに相手のバージョンが表示されつつある。一部のサーバとしか連合していないけど、これが世界に広がっていったら #PostgreSQL のDBとかは肥大化していくのだろうか？

#Lemmy はなんとか更新ができた、と思う。連合に関して問題がありそうで心配。
古い方のpostgresだけdocker composeで起動。bashで中にはいる。pg_dumpでbackup。
新規のpostgresのみ起動、bashで中に入り、psqlでrestore。pg_restoreができなかった。コマンドとしては、
docker compose run -d -v $(pwd):/tmp postgres
docker compose exec postgres /bin/bash
pg_dump -d lemmy -U lemmy >/tmp/lemmy-postgres.sql
------------------------------------------------
docker compose run -d -v $(pwd):/mnt postgres
docker compose exec postgres /bin/bash
psql -U lemmy -d lemmy -f /mnt/lemmy-postgres.sql
#Docker も #PostgreSQL も全く分かってないので大苦労。コマンドの使い方がわかってないので沢山のエラーに悩まされた。

次は、以前のsubdomain、管理者とかパスワードなど、さらにdbの内容を戻したり書き込めばうまく行く、と思いたい。また後でやろう。#Lemmy #PostgreSQL

結局、#Lemmy は
https://github.com/LemmyNet/lemmy/releases/tag/0.18.5
https://github.com/LemmyNet/lemmy/archive/refs/tags/0.18.5.tar.gz
からdockerだけ抜き出した。

https://github.com/LemmyNet/lemmy/blob/main/config/defaults.hjson
もpostgresのpasswordで参考にした。

lemmy.hjson
docker-compose.yml
の編集。
lemmy.hjsonのdatabaseのところにpassword:の行を追加。

mkdir -p volumes/pictrs
cd volumes
chown -R 991:991 pictrs

nohup docker compose up &
これでなんとか正しく起動したみたい。
nohupは吐かれるlogが多いので記録するため。
本番は
docker compose up -d
になるはず。#docker #postgres #PostgreSQL

Any tips on why 50 mastodon pull requests cause postgres to max out a 16x5,4ghz cpu? #mastoadmin #postgresql . The db is going since 2017 and went through some postgres updates, now at version 16. Did I miss some mandatory postgres db care instructions? I mean the queue is being dealt with but its quite a horrendous cpu usage imho.

Et hop, cluster #PostgreSQL de ma machine de supervision mis à jour vers la version 16. 🐘

Has anyone used #Neon, a serverless #PostgreSQL offer? I'm curious what the experience has been like using it.

https://neon.tech/

The #Rel8 #Haskell library lets you construct #Postgresql #SQL queries using a monadic interface.

"Rel8 has a fairly unique feature in that it’s able to return not just lists of rows, but can also return trees."

https://rel8.readthedocs.io/en/latest/cookbook.html#tree-like-queries

Abandoned ship, though I remain very very curious how this was considered reasonable by anyone. Though in fairness these days as soon as I see a .yaml file anywhere I tend to go “oh, shit, this is some software with insane build and usage nonsense that only corporate devs think is remotely acceptable”.

Conversely, #StrawberryPerl installed very easily and obviously, and all I needed to do was add its bin folder to my %PATH% et voila, it built the part of PostgreSQL I needed to build just fine.

Seems pretty silly the #PostgreSQL docs recommend, borderline insist, on using ActiveState Perl when Strawberry Perl provides #Perl in a far more “actually provides it to you” way :P