BibSonomy bookmarks for /tag/postgresqlhttps://www.bibsonomy.org/tag/postgresqlBibSonomy RSS Feed for /tag/postgresqlWhat I Wish Someone Told Me About Postgres | ChallahScripthttps://challahscript.com/what_i_wish_someone_told_me_about_postgresbshanks2024-11-12T04:13:49+01:00postgres postgresql sql <a itemprop="url" data-versiondate="2024-11-12T04:13:49+01:00" href="https://challahscript.com/what_i_wish_someone_told_me_about_postgres" rel="nofollow" class="description-link">https://challahscript.com/what_i_wish_someone_told_me_about_postgres</a>10 gravierende PostgreSQL-Fehler | ComputerwocheDie Flexibilität von PostgreSQL hat auch eine Kehrseite. Diese zehn Design- und Konfigurationsfehler sollten Sie sich sparen.https://www.computerwoche.de/article/3535404/10-gravierende-postgresql-fehler.html?utm_date=20240924152832&utm_campaign=COMPUTERWOCHE%20First%20Look&utm_content=Read%20More%3A%20Die%20Flexibilit%C3%A4t%20von%20PostgreSQL%20hat%20auch%20eine%20Kehrseite.%20Diese%20zehn%20Design-%20und%20Konfigurationsfehler%20sollten%20Sie%20sich%20sparen.%20&utm_term=Computerwoche%20Newsletters&utm_medium=email&utm_source=Adestra&huid=46bc70ff-f11d-4598-8714-c9ea27b2c8c0&tap=e0de46536508812a602092b6554939d1ubt.rohlfs2024-09-24T17:59:18+02:00datenbank postgresql sysadmin <span itemprop="description">Die Flexibilität von PostgreSQL hat auch eine Kehrseite. Diese zehn Design- und Konfigurationsfehler sollten Sie sich sparen.</span>PostgreSQL and UUID as Primary Key | Hacker Newshttps://news.ycombinator.com/item?id=40884878bshanks2024-07-08T01:06:18+02:00db postgre postgresql primarykey uuid <a itemprop="url" data-versiondate="2024-07-08T01:06:18+02:00" href="https://news.ycombinator.com/item?id=40884878" rel="nofollow" class="description-link">https://news.ycombinator.com/item?id=40884878</a>Maciej Walkowiak | PostgreSQL and UUID as primary keyhttps://maciejwalkowiak.com/blog/postgres-uuid-primary-key/bshanks2024-07-08T01:03:34+02:00db postgres postgresql primarykey uuid <a itemprop="url" data-versiondate="2024-07-08T01:03:34+02:00" href="https://maciejwalkowiak.com/blog/postgres-uuid-primary-key/" rel="nofollow" class="description-link">https://maciejwalkowiak.com/blog/postgres-uuid-primary-key/</a>supabase/index_advisor: PostgreSQL Index AdvisorPostgreSQLhttps://github.com/supabase/index_advisorbshanks2024-04-14T19:29:44+02:00PostgreSQL Postgres <span itemprop="description">PostgreSQL</span>An Overview of Distributed PostgreSQL Architectures | Crunchy Data Bloghttps://www.crunchydata.com/blog/an-overview-of-distributed-postgresql-architecturesbshanks2024-01-20T23:56:38+01:00db ha postgresql <a itemprop="url" data-versiondate="2024-01-20T23:56:38+01:00" href="https://www.crunchydata.com/blog/an-overview-of-distributed-postgresql-architectures" rel="nofollow" class="description-link">https://www.crunchydata.com/blog/an-overview-of-distributed-postgresql-architectures</a>GitHub - pgvector/pgvector: Open-source vector similarity search for Postgreshttps://github.com/pgvector/pgvector#getting-startedjil2023-11-24T16:41:29+01:00extension pgvector postgres postgresql store vector <a itemprop="url" data-versiondate="2023-11-24T16:41:29+01:00" href="https://github.com/pgvector/pgvector#getting-started" rel="nofollow" class="description-link">https://github.com/pgvector/pgvector#getting-started</a>Apt - PostgreSQL wikihttps://wiki.postgresql.org/wiki/Aptjil2023-11-24T16:39:12+01:00apt deb debian list package postgres postgresql repository sources <a itemprop="url" data-versiondate="2023-11-24T16:39:12+01:00" href="https://wiki.postgresql.org/wiki/Apt" rel="nofollow" class="description-link">https://wiki.postgresql.org/wiki/Apt</a>Creating a search engine with PostgreSQL | Hacker Newshttps://news.ycombinator.com/item?id=36699016bshanks2023-07-14T00:36:31+02:00postgresql search <a itemprop="url" data-versiondate="2023-07-14T00:36:31+02:00" href="https://news.ycombinator.com/item?id=36699016" rel="nofollow" class="description-link">https://news.ycombinator.com/item?id=36699016</a>Create an advanced search engine with PostgreSQLPostgreSQLhttps://xata.io/blog/postgres-full-text-search-enginebshanks2023-07-14T00:33:44+02:00PostgreSQL search <span itemprop="description">PostgreSQL</span>Don't Do This - PostgreSQL wikihttps://wiki.postgresql.org/wiki/Don't_Do_Thiscontinued2023-04-25T21:32:53+02:00Datenbank Donts PostgreSQL lang:en <a itemprop="url" data-versiondate="2023-04-25T21:32:53+02:00" href="https://wiki.postgresql.org/wiki/Don't_Do_This" rel="nofollow" class="description-link">https://wiki.postgresql.org/wiki/Don't_Do_This</a>Don't Do This - PostgreSQL wikiselect * from foo where col not in (1,null); -- always returns 0 rowshttps://wiki.postgresql.org/wiki/Don't_Do_This#Don.27t_use_rulesjil2023-04-25T15:32:51+02:00do dont donts postgresql psql this <span itemprop="description">select * from foo where col not in (1,null); -- always returns 0 rows</span>Trusted Open Source PostgreSQL & Commercial Support for the Enterprise | Crunchy Datahttps://www.crunchydata.com/bshanks2022-08-26T03:09:33+02:00db postgres postgresql <a itemprop="url" data-versiondate="2022-08-26T03:09:33+02:00" href="https://www.crunchydata.com/" rel="nofollow" class="description-link">https://www.crunchydata.com/</a>sql - updating table rows in postgres using subquery - Stack OverflowPostgres allows:
UPDATE dummy
SET customer=subquery.customer,
address=subquery.address,
partn=subquery.partn
FROM (SELECT address_id, customer, address, partn
FROM /* big hairy SQL */ ...) AS subquery
WHERE dummy.address_id=subquery.address_id;
This syntax is not standard SQLhttps://stackoverflow.com/questions/6256610/updating-table-rows-in-postgres-using-subqueryjil2022-05-10T15:42:12+02:00from into postgres postgresql psql select subquery update <span itemprop="description">Postgres allows:
UPDATE dummy
SET customer=subquery.customer,
address=subquery.address,
partn=subquery.partn
FROM (SELECT address_id, customer, address, partn
FROM /* big hairy SQL */ ...) AS subquery
WHERE dummy.address_id=subquery.address_id;
This syntax is not standard SQL</span>The Internals of PostgreSQL : Introductionhttps://www.interdb.jp/pg/bshanks2022-02-10T21:33:13+01:00PostgreSQL <a itemprop="url" data-versiondate="2022-02-10T21:33:13+01:00" href="https://www.interdb.jp/pg/" rel="nofollow" class="description-link">https://www.interdb.jp/pg/</a>How Postgres Stores Rows - Ketan SinghPostgreSQLhttps://ketansingh.me/posts/how-postgres-stores-rows/bshanks2022-02-10T21:33:05+01:00PostgreSQL <span itemprop="description">PostgreSQL</span>The Internals of PostgreSQL : IntroductionPostgreSQLhttps://www.interdb.jp/pg/index.htmlbshanks2022-01-28T01:45:36+01:00PostgreSQL <span itemprop="description">PostgreSQL</span>CockroachDB is getting a lot of interest these days. It has broad PGSQL language... | Hacker NewsCockroachDBhttps://news.ycombinator.com/item?id=28425809bshanks2021-09-08T17:33:34+02:00CockroachDB postgre postgres postgresql <span itemprop="description">CockroachDB</span>citusdata/citus: Distributed PostgreSQL as an extensionPostgreSQLhttps://github.com/citusdata/citusbshanks2021-09-08T17:23:44+02:00Postgre PostgreS PostgreSQL db ha scale <span itemprop="description">PostgreSQL</span>Zero downtime Postgres migration, done righthttps://engineering.theblueground.com/blog/zero-downtime-postgres-migration-done-right/bshanks2021-06-15T09:20:52+02:00downtime migrate postgres postgresql <a itemprop="url" data-versiondate="2021-06-15T09:20:52+02:00" href="https://engineering.theblueground.com/blog/zero-downtime-postgres-migration-done-right/" rel="nofollow" class="description-link">https://engineering.theblueground.com/blog/zero-downtime-postgres-migration-done-right/</a>