spraci.info

Search

Items tagged with: PostgreSQL

#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
 
#PostgreSQL 11.2, 10.7, 9.6.12, 9.5.16, and 9.4.21 released

https://lwn.net/Articles/779781/
"The PostgreSQL project has put out updated releases for all supported versions."
 
#formation #Git #React #PostgreSQL #PostGis #JavaScript
 

Red Hat Satellite to Drop MongoDB and Standardize on PostgreSQL Database


Red Hat Satellite is a complex offering and we wanted to spend some time talking about the underlying databases that make Satellite work as well as some upcoming changes to this underlying database…
Article word count: 490

HN Discussion: https://news.ycombinator.com/item?id=19158854
Posted by pplonski86 (karma: 3004)
Post stats: Points: 119 - Comments: 43 - 2019-02-14T01:19:36Z

\#HackerNews #and #database #drop #... Show more...
 

Hacking PostgreSQL [pdf]


HN Discussion: https://news.ycombinator.com/item?id=19014665
Posted by eatonphil (karma: 3843)
Post stats: Points: 132 - Comments: 1 - 2019-01-28T00:34:45Z

\#HackerNews #hacking #pdf #postgresql
HackerNewsBot debug: Calculated post rank: 88 - Loop: 232 - Rank min: 80 - Author rank: 46
 

PostgreSQL: Backend Flowchart


HN Discussion: https://news.ycombinator.com/item?id=19011925
Posted by octosphere (karma: 4463)
Post stats: Points: 164 - Comments: 7 - 2019-01-27T14:58:38Z

\#HackerNews #backend #flowchart #postgresql
Article content:
[1]flowchart
A query comes to the backend via data packets arriving through TCP/IP or Unix Domain sockets. It is loaded into a string, and passed to the [2]parser, where the lexical scanner, [3]scan.l, breaks the query up into tokens(words). The parser uses [4]gram.y and the tokens to identify th... Show more...
 

Internals of PostgreSQL


In this document, the internals of PostgreSQL for database administrators and system developers are described. PostgreSQL is an open source multi-purpose relational database system which is widely…
Article word count: 379

HN Discussion: https://news.ycombinator.com/item?id=18950460
Posted by billwashere (karma: 161)
Post stats: Points: 180 - Comments: 7 - 2019-01-20T01:57:58Z

\#HackerNews #internals #postgresql
Article content:

In this document, the internals of PostgreSQL for database administrators and system developers are described.

PostgreSQL is an open source multi-purpose relational d... Show more...
 

HeidiSQL – GUI client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL


HeidiSQL is free software, and has the aim to be easy to learn. "Heidi" lets you see and edit data and structures from computers running one of the database systems MariaDB, MySQL, Microsoft SQL or…
Article word count: 401

HN Discussion: https://news.ycombinator.com/item?id=18932320
Posted by piotrkubisa (karma: 333)
Post stats: Points: 120 - Comments: 68 - 2019-01-17T16:53:32Z

\#HackerNews #and #client #for #gui #... Show more...
 

Hubzilla on Silverhaze.EU gone


Already announced months ago (so that the users had enough time to migrate) I've now shutdown my #Hubzilla hub running on Silverhaze.EU:
server:~# a2dissite silverhaze.eu
Site silverhaze.eu disabled.
To activate the new configuration, you need to run:
service apache2 reload
server:~# service apache2 reload
[ ok ] Reloading Apache httpd web server: apache2.
server:~#
postgres@server:~$ dropdb hubzilla
postgres@server:~$

Hubzilla was a nice thing to try out, but I don't think that I've gained much benefit of this, because I also have #Friendica node running for years and a #Mastodon instance running for some time now.
Hubzilla is a nice software for what it is: a complete set of web applications. When you only want to have some kind of socia... Show more...
 
Later posts Earlier posts