spraci.info

Search

Items tagged with: PostgreSQL

#PostgreSQL is big business. https://searchdatamanagement.techtarget.com/news/252478988/EnterpriseDB-looks-to-grow-market-for-PostgreSQL #postgres #psql
 
#Louisville, #CO or #Minneapolis, #MN

The only true requirement:
Broad and deep familiarity with multiple open source projects
Some of the ones we support are the following, but if you don't know these specifically, you should still apply. We are just looking for technical people that live and breath open source:
Java and #J2EE, #JBoss, #ActiveMQ, #Drools, #HornetQ, #... Show more...
 
#Louisville, #CO or #Minneapolis, #MN

Requirements:
Minimum of five years of software development and design or systems administration or level 3-4 technical support experience.
Technical knowledge, skills and expertise in complex infrastructure, web-based software and enterprise software
Understanding of software best practices; SDLC, SCM and Agile development principles.
Excellent written, verbal, and presentation skills
Expert level in a number of open source packages.
Broad and deep familiarity with multiple projects to include Java and #J2EE, #JBoss, #... Show more...
 
The more I use #psql the more I like it. We use that a lot at work. For my personal stuff it's always #mariadb / #mysql (for almost 2 decades). But #postgresql is impressive in its own way. #postgres
 

Datenbanken: Dynamische Baumstrukturen in PostgreSQL speichern


heise+ | Datenbanken: Dynamische Baumstrukturen in PostgreSQL speichern

Mit einem generischen Tabellenkonzept und den Array- und JSON-Feldern von PostgreSQL speichern SQL-Datenbanken beliebige Daten und prüfen dabei deren Struktur.
https://www.heise.de/hintergrund/Datenbanken-Dynamische-Baumstrukturen-in-PostgreSQL-speichern-4606223.html
#AssetStorm #Django #JSON #PostgreSQL
 

PostgreSQL 12: Feintuning für die quelloffene Datenbank


heise+ | PostgreSQL 12: Feintuning für die quelloffene Datenbank

Feinschliff an vielen Stellen macht die zwölfte Auflage der Open-Source-Datenbank vor allem schneller. Es bleibt aber noch Spielraum für weitere Verbesserungen.
https://www.heise.de/tests/PostgreSQL-12-Feintuning-fuer-die-quelloffene-Datenbank-4592675.html
#DataWarehousing #Geschwindigkeitsvorteile #Just-in-Time-Kompilierung #Open-Source-Datenbank #PostgreSQL #Version12
 
#PostgreSQL people, help :(
Limit (cost=1001.17..7595.95 rows=3 width=16)
-> Gather Merge (cost=1001.17..1709047.98 rows=777 width=16)
Workers Planned: 2
-> Nested Loop Left Join (cost=1.15..1702653.97 rows=324 width=12)
Filter: ((content_content.author_id = 2) OR (content_content.visibility = ANY ('{2,0}'::integer[])) OR ((content_content.visibility = 1) AND (content_content_limited_visibilities.profile_id = 2)))
-> Nested Loop Left Join (cost=0.86..1702536.14 rows=325 width=20)
Filter: ((t2.author_id = 49976) OR (content_content.author_id = 49976))
-> Parallel Index Scan Backward using content_post_e2fa5388 on content_content (cost=0.43..722645.67 rows=1381459 width=20)
Filter: (content_type = 0)
-> Index Scan using content_content_19a8afea on content_content t2 (cost=0.43..0.68 rows=2 wi
... Show more...
 
#postgres #psql #postgresql #db in government
Crunchy Data and ORock Technologies Partnership Brings Trusted Open Source Cloud Native PostgreSQL to Federal Government
 
#PostgreSQL 12 boosts open source #database performance

https://searchdatamanagement.techtarget.com/news/252472281/PostgreSQL-12-boosts-open-source-database-performance Sean Michael Kerner on #postgres #psql #db
 
ça tourne bien #postgresql et #mariadb sur de l'ARM ? l'idée c'est d'isoler mes BDD qui tournent aujourd'hui en containers sur un host x86.
L'idée c'est d'avoir plus de mémoire / cpu pour le même prix mais si derrière ça pédale dans le choucroute, je ne voies pas l'intérêt. Merci 😀
 
#PostgreSQL considers seccomp() filters
https://lwn.net/Articles/800916/ #psql #postgres #db
 
Datenbank: PostgreSQL 12 beschleunigt Abfragen und unterstützt JSON - Golem.de
https://www.golem.de/news/datenbank-postgresql-12-beschleunigt-abfragen-und-unterstuetzt-json-1910-144248.html
#PostgreSQL #Datenbank #JSON #LLVM #SQL #jit #Applikationen #OpenSource #Softwareentwicklung
 
Links 3/10/2019: #PostgreSQL 12, #Blender 2.81 Released http: //techrights.org/2019/10/03/postgresql-12-released/ #techrights #gnu #linux
 
Using #PostgreSQL as a cache? http://renesd.blogspot.com/2019/10/using-postgresql-as-cache.html #postgres #psql (release imminent)
 
#PostgreSQL release today. Just in time:
 
GitLab verabschiedet sich endgültig von MySQL
https://www.heise.de/developer/meldung/GitLab-verabschiedet-sich-endgueltig-von-MySQL-4463394.html
#Git #MySQL #PostgreSQL
 
#Crunchy Data releases an update to the CIS #Benchmark for #PostgreSQL 11
 
#PostgreSQL #security : a quick look at authentication best practices [Tutorial]https://hub.packtpub.com/postgresql-security-a-quick-look-at-authentication-best-practices-tutorial/ 8+ years at my employer, never seen #psql security incidents (yet)
PostgreSQL security: a quick look at authentication best practices [Tutorial]
 
" #GDA is getting fixes for most of its bugs around SQLite, #PostgreSQL and #MySQL providers. Lot of modernization work has been landing in master, making #GCC more and more happy avoiding warnings, some of them are present, yet."
 
#PostgreSQL Adds #GSSAPI #Encryption Support
https://www.phoronix.com/scan.php?page=news_item&px=PostgreSQL-GSSAPI-Encryption
 
Gibberfish Social has undergone a major overhaul this weekend.

First, the database has been converted to from MariaDB to PostgreSQL, which has led to a noticeable speed-up in stream loading time.

Second, the single server has been split into two: One which holds the database and user-uploaded content, which uses full-disk encryption. The other runs the Diaspora, Movim, and chat servers and holds no data of its own. Both new servers are ARM64-based systems, which do not have hardware backdoors like those designed into Intel and AMD chipsets.

This is not only a little bit cheaper to run than our old server, but allows us to easily scale by adding more application servers if the need arises. "Cheaper" doesn't mean free, though, so if you enjoy the services provided by this pod, please consider making a donation to help support it. Thanks!

#gibberfish #diaspora #movim #xmpp #postgresql #arm #arm64
Make a Donation
 
There will be some downtime today as we attempt to migrate the database from MariaDB to Postgresql to improve performance. Thanks for your patience.

#gibberfish #database #mariadb #mysql #postgresql #maintenance #downtime
 
#docker #PostgreSQL #RabbitMQ #python #rootless
 
Somehow I missed that #postgres 11.2 had dropped. It's fully compatible with 11.1 databases, no need to dump and restore.

#postgresql
 

PGHoard – PostgreSQL backup and restore service for cloud object storages


PostgreSQL backup and restore service. Contribute to aiven/pghoard development by creating an account on GitHub.
Article word count: 34

HN Discussion: https://news.ycombinator.com/item?id=19285459
Posted by bjoko (karma: 383)
Post stats: Points: 114 - Comments: 15 - 2019-03-01T21:31:28Z

\#HackerNews #and #backup #cloud #for #object #pghoard #postgresql #restore #service #storages
Article content:

Image/photo

You can’t perform that action at this time.

You signed in with another tab or window. [1]Reload to refresh your session. You signed out in another tab or window. [2]Reload to refresh your session.

References

Visible links
1. file:///dev/
2. file:///dev/

HackerNewsBot debug: Calculated post rank: 81 - Loop: 417 - Rank min: 80 - Author rank: 89
 

Matrix


Ich hatte meinen Matrix Server für zwei Tage offline, weil ich große performance Probleme hatte.
Nach einen wechsel von Sqlite auf Postgresql-11 läuft nun alles.
Python3.5 -> 3.7 wird noch folgen.

Wenn es so weiter geht, dann werde ich die ersten Bridges installieren und mich dann von den anderen Messenger trennen.

#Matrix #Riot #Synapse #Postgresql #messenger
 

PostgreSQL


Kann mir jemand sagen, ob #pglz auch in der Community Edition von #PostgreSQL aktive ist?

#Linux #DB #OpenSource
 
#GNU Health Federation message and authentication server drops #MongoDB and adopts #PostgreSQL
GNU Health Federation message and authentication server drops MongoDB and adopts PostgreSQL
 

PostgreSQL 11 Reestablishes Window Functions Leadership


PostgreSQL 11 offers the best OVER clause support among its competitors, true procedures, and improvements in FETCH FIRST and XML.
Article word count: 1882

HN Discussion: https://news.ycombinator.com/item?id=19165923
Posted by boshomi (karma: 323)
Post stats: Points: 141 - Comments: 10 - 2019-02-14T20:55:26Z

\#HackerNews #functions #leadership #postgresql #reestablishes #... Show more...
 

Fully managed PostgreSQL databases


Fully managed, and scalable database clusters without the administrative overhead.
Article word count: 37

HN Discussion: https://news.ycombinator.com/item?id=19162729
Posted by alexellisuk (karma: 1204)
Post stats: Points: 193 - Comments: 70 - 2019-02-14T15:46:05Z

\#HackerNews #databases #fully #managed #postgresql
Article content:




[1]C83f5e9d5a13bee5740ed213ddaf8a3d107d94c0 abugameslogo notext

“Our e-commerce business relies on a high-performance database. Managed Databases from DigitalOcean allow us to create a PostgreSQL environment that’s easy to configure and gives us built-in backup, redundancy, and automatic upgrades.”

Adam Fuhriman CIO at ABUGames

References

Visible links

HackerNewsBot debug: Calculated post rank: 152 - Loop: 162 - Rank min: 100 - Author rank: 18
 
Later posts Earlier posts