Discover and read the best of Twitter Threads about #Postgres

Most recents (5)

Für Software-Entwickler und Nerds ein kleiner Thread zur IT-Sicherheit bei #Datenbanken und Zugriffs-Berechtigungen:

Bei normalen Dateisystem haben wir uns daran gewöhnt, dass nicht jeder Server-Dienst nach /etc, /usr/local/bin oder c:\windows\system32 schreiben darf. 1/x
Viele Entwickler wollen auf Datenbanken aber Vollzugriff auf alles haben. Steht die Anwendung im Netz und findet jemand eine Lücke ist die Kacke am Dampfen: „DELETE FROM users;“ und alle User sind weg. Mit „TRUNCATE users“ gehts sogar schneller. 2/x
Mit Pech geht das sogar auf fremden Datenbanken auf dem gleichen Server. Dumm.

Daher kennen anständige relationale Datenbankmanagementsystemen (RDBMS) User, Rollen und Zugriffsrechte; nutzt man die, darf der Applikations-User der Web-Anwendung nur das nötige. 3/x
Read 20 tweets
#Postgres as an event store -- Thanks a lot for all the super-insightful answers 🙏! It looks like using a jsonb[] for modeling an event stream isn't ideal performance-wise, but several great pointers to using #Postgres for event sourcing here. Mentioned solutions include... 1/4
- FactCast: docs.factcast.org
- Message DB: github.com/message-db/mes…
- @marten_lib: martendb.io
- @axonframework: axoniq.io
- crabzilla: github.com/crabzilla/crab… (an event sourcing exploration using @vertx_project)

2/4
Two really read-worthy blog posts on the topic of using #Postgres as an event store:

- dev.to/kspeakman/even… by Kasey Speakman
- softwaremill.com/implementing-e… by @adamwarski

3/4
Read 4 tweets
Researchers & app developers, are you trying to synchronize your CareKit app data to the cloud? My team, #NetReconLab at the @universityofky has released a set of open-source tools to help #WWDC #Swift #CareKit #Cloud #synchronization #Postgres #mongodb

developer.apple.com/videos/play/ww…
Apple engineers discussed all of the new synchronization features they added today within CareKit (19 minutes - end of the video). I was fortunate enough to make some contributions to this effort on CareKits official GitHub Page (I'm " cbaker6" 🙃)

github.com/carekit-apple/…
The CareKitSample-ParseCareKit which shows off all of the tools at once. It combines the data sync tool (ParseCareKit) that syncs the data from your device to parse-hipaa. The sample app will have you synching data to your server in 3 minutes!

github.com/netreconlab/Ca…
Read 6 tweets
1) Are you using #postgres via #docker for mac?

Have you ever noticed `EXPLAIN ANALYZE` slowing down your queries by like 60x?

Let's dig into some #postgres and #linux internals to figure out what's going on! An accessible version of this thread is available at https://github.com/felixge/tweets/tree/master/postgres-docker-explain-analyze
1b) This thread is also available on GitHub: github.com/felixge/tweets…
2) First we need some understanding of how `EXPLAIN ANALYZE` works.

Looking through the PostgreSQL code, it basically boils down to:

start = clock_gettime()
row = node.nextRow()
node.time += clock_gettime() - start
return row
Read 22 tweets
@georgberky 14/ New trends in Databases

not necessarily for #groovylang, but something everyone needs to know like #jooq #hibernate #postgres #neo4j #tinkerpop #cassandra #redis #mongodb
15/ #groovypuzzlers or a similar interactive session to get people talking about #groovylang
16/ Dynamic vs static programming in #groovylang

- performance differences
- tooling improvements
- etc
Read 15 tweets

Related hashtags

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3.00/month or $30.00/year) and get exclusive features!

Become Premium

Too expensive? Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal Become our Patreon

Thank you for your support!