Most recents (5)

@alvar_f

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

Gunnar Morling 🌍

@gunnarmorling

#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

https://twitter.com/gunnarmorling/status/1423311149748166657

- 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

Corey E Baker

@DrCoreyBaker

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

Felix Geisendörfer

@felixge

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!

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