Discover and read the best of Twitter Threads about #postgres

Most recents (2)

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

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!