Skip to main content

Search

Items tagged with: PostgreSQL


 
J'ai utilisé le FTS de #PostgreSQL sur mon blog et j'ai été étonné de la simplicité et de la robustesse.


 

PostgreSQL 11.3 and 10.8 Released


HN Discussion: https://news.ycombinator.com/item?id=19867943
Posted by oskari (karma: 128)
Post stats: Points: 141 - Comments: 26 - 2019-05-09T13:14:07Z

#HackerNews #108 #113 #and #postgresql #released
HackerNewsBot debug: Calculated post rank: 102 - Loop: 124 - Rank min: 100 - Author rank: 21


 
Bundesinstitut für Risikobewertung: Benutzername "dummy", Passwort "doof" #Sicherheitslücke #Datenbank #Datensicherheit #IFG #Passwort #PostgreSQL #Server-Applikationen #Urheberrecht #Applikationen #Internet


 

A short list of common mistakes in PostgreSQL


HN Discussion: https://news.ycombinator.com/item?id=19817531
Posted by kawera (karma: 22907)
Post stats: Points: 227 - Comments: 48 - 2019-05-03T11:52:08Z

#HackerNews #common #list #mistakes #postgresql #short
HackerNewsBot debug: Calculated post rank: 167 - Loop: 67 - Rank min: 100 - Author rank: 77


 

PostgreSQL Features You May Not Have Tried but Should


HN Discussion: https://news.ycombinator.com/item?id=19765761
Posted by rodmena (karma: 136)
Post stats: Points: 135 - Comments: 31 - 2019-04-27T14:40:41Z

#HackerNews #but #features #have #may #not #postgresql #should #tried #you
HackerNewsBot debug: Calculated post rank: 100 - Loop: 232 - Rank min: 80 - Author rank: 50


 
#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]


 

PostgreSQL Count(*) Performance Improvements


count(*) is often quite slow in PostgreSQL. This article explores your options to make counting rows faster using approximations and other tricks.
Article word count: 966

HN Discussion: https://news.ycombinator.com/item?id=19629709
Posted by turrini (karma: 2862)
Post stats: Points: 110 - Comments: 27 - 2019-04-10T23:31:41Z

#HackerNews #count* #improvements #performance #... show more


 
" #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


 
Datenbanksystem PostgreSQL: Schlupfloch macht Angreifer zum Admin #PostgreSQL #Sicherheitslücken


 

Timestamps and Time Zones in PostgreSQL


The nuance between timestamp with and without time zone

HN Discussion: https://news.ycombinator.com/item?id=19532090
Posted by GordonS (karma: 5664)
Post stats: Points: 117 - Comments: 42 - 2019-03-30T21:47:37Z

#HackerNews #and #postgresql #time #timestamps #zones
Article cont... show more


 
Can anyone here help me solving a problem with #postgres? It is breaking my instance peertube.social, and I have absolutely no idea how to fix it. I wrote up the details here:

https://serverfault.com/q/960613/516666

#sql #postgresql


 
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


 
Somehow I missed that #postgres 11.2 had dropped. It's fully compatible with 11.1 databases, no need to dump and restore.

#postgresql


 
okay ... for a final time, let's make things clear.. ;)

#gplusrefugee [ \ | /#] #diaspora user and #fediverse netitzen Transition Status: Complete.

Now i wanna try to figure out how i can run #friendica on a #postgresql server and so open up my own little #pod.. Well, time will tell. ;)

.oO( P.s.: NO i don't want to install mariadb/mysql ... but i fear i have to install it for other cloud-thingie stuff anyways :( )


 
okay ... for a final time, let's make things clear.. ;)

#gplusrefugee [ \ | /#] #diaspora user and #fediverse netitzen Transition Status: Complete.

Now i wanna try to figure out how i can run #friendica on a #postgresql server and so open up my own little #pod.. Well, time will tell. ;)

.oO( P.s.: NO i don't want to install mariadb/mysql ... but i fear i have to install it for other cloud-thingie stuff anyways :( )


 

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


 

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


 

Running a Bakery on Emacs and PostgreSQL


Just over a year ago now, I finally opened the bakery I’d been dreaming of for years. It’s been a big change in my life, from spending all my time sat in front of a computer, to spending most of it…
Article word count: 1798

HN Discussion:
... show more


 

Running a Bakery on Emacs and PostgreSQL


Just over a year ago now, I finally opened the bakery I’d been dreaming of for years. It’s been a big change in my life, from spending all my time sat in front of a computer, to spending most of it…
Article word count: 1798

HN Discussion: https://news.ycombinator.com/item?id=19252952
Posted by flocial (karma: 1512)
Post stats: Points: 162 - Comments: 45 - 2019-02-26T09:06:18Z

\#HackerNews #and #bakery #emacs #postgresql #... show more


 

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."


 

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


 

MyWebSQL: Administración fácil de MySQL vía web


https://www.ochobitshacenunbyte.com/2019/02/11/mywebsql-administracion-facil-de-mysql-via-web

#centos 7 #mariadb #mysql #mywebsql #postgresql #sql #sqlite #sysadmin
MyWebSQL: Administración fácil de MySQL vía web


 
- ✅ crear una tasca cron que obtengui la visió que té mastodont.cat del #fedivers, un cop per setmana.
- ✅ guardar les dades en un fitxer
- ✅ crear un nou guió #Python que llegeixi les dades del fitxer y les escrigui en una base de dades #Postgresql.
- ✅ crear un nou Dashboard a #grafana que mostri l'evolució del fedivers, sempre segons mastodont.cat


 
Projecte nou:
- crear una tasca cron que obtengui la visió que té mastodont.cat del #fedivers, un cop per setmana.
- guardar les dades en un fitxer
- crear un nou guió #Python que llegeixi les dades del fitxer y les escrigui en una base de dades #Postgresql.
- crear un nou Dashboard a #grafana que mostri l'evolució del fedivers, sempre segons mastodont.cat


 
@jrhawley Olga Kalinina has presented the way she works with #PostgreSQL and #R (via PL/R) during #fosdem #pgday in Brussels. She prefers R but other people also use #Python. I don't think she is on Mastodon but maybe it is a good reason to invite her and ask.


 
I could not resist buying this super cute stuffed animal from the #PostgreSQL stand at #FOSDEM. It stands stable on its 4 legs, I expected no less from the Postgres project. <img class=">
Image/Photo


 

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... show more


 
Microsoft übernimmt den Postgres-Datenbankspezialisten Citus Data #CitusData #Microsoft #OpenSource #PostgreSQL


 

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


 
Hallo zusammen, ich bin #NeuHier. Ich interessiere mich für #geoinformatik, #geologe, #geologie, #hund, #hunde, #postgis, #postgresql, #qgis, #python und #triumph.
Und vieles mehr ;)
Have a ot of fun!
Uwe


 
I'm going to upgrade the diaspora-fr database, so there will be a downtime tonight.

Je vais mettre à jour la base de données de diaspora-fr, il va y avoir une coupure du service cette nuit

#diaspora-fr #postgresql


 
Cool and detailed article about why and how The Guardian migrated from MongoDB to Postgres. Been wanting to mess around with Postgres JSONB document capabilities. Maybe will now. #postgresql #mongodb #scala #software #programming #database #aws


 
Cool and detailed article about why and how The Guardian migrated from MongoDB to Postgres. Been wanting to mess around with Postgres JSONB document capabilities. Maybe will now. #postgresql #mongodb #scala #software #programming #database #aws #devops


 
@lynnesbian - well, installing #PostgreSQL 11 on #Debian testing doesn't mean that it will be used. On my unstable box the databases stayed on #psql 10 until I did a pg_upgradecluster and dropped the old cluster 10.

And of course you now that using testing comes with a risk and problems. Sometimes even worse than using Debian unstable.
For unstable you'll always need to monitor the mailing list about upcoming library transitions and such and see what will be upgraded/removed. #worksforme :)