
PostgresRVA
@PostgresRVA
We are a Richmond, VA Community for PostgreSQL professionals and enthusiasts
Anda mungkin suka
Our hope is to speak to diverse #data professionals consisting of Data Scientists, Engineers, and Analysts as well as Developers and DBAs in the Richmond, VA area! Check us out at meetup.com/Postgres-RVA/ #Postgres #DataScience #DataAnalytics #sql
Recording of the discussion on "SQL or NoSQL? Schema or Schemaless?" with @morgo, @billkarwin and me. youtube.com/watch?v=4EIai4…
youtube.com
YouTube
Panel: SQL or NoSQL? Schema or Schemaless?
Craig Kerstiens (@craigkerstiens): Building a recommendation engine inside Postgres with Python and Pandas postgr.es/p/4Sy
for i in {0..255}; do printf "\x1b[38;5;${i}mc${i}\x1b[0m "; done

Here's a basic introduction to writing functions which can be used to add functionality to PostgreSQL. learn.crunchydata.com/postgresql-dev…
Semab Tariq (@2ndquad): How to use AdaBoost Machine Learning model with 2UDA – PostgreSQL and Orange (Part 6) postgr.es/p/4On
Digging into Postgres indexing and BRIN indexes can sometimes feel a bit magical but incredibly useful for larger data sets, a great deep dive and comparison of them - info.crunchydata.com/blog/postgresq…
crunchydata.com
PostgreSQL BRIN Indexes: Big Data Performance With Minimal Storage | Crunchy Data Blog
A PostgreSQL block range index, or BRIN, can help you to significantly reduce the amount of disk space required for high performance queries on big data.
PGCon 2020 tutorials start on Tue May 26 @ 1300 UTC Online. Free. No registration. pgcon.org/events/pgcon_2… You can watch them via the steaming channel: pgcon.org/2020/stream1.p… You can interact via Zoom meeting - details later.
Caterina Magini: How to migrate from inheritance-based partitioning to declarative partitioning in PostgreSQL postgr.es/p/4L6
Florian Nadler: Intersecting Tracks of individuals – MobilityDB postgr.es/p/4K-
cybertec-postgresql.com
Intersecting Tracks of individuals – MobilityDB
How to use MobilityDB for contact tracking. Extension built on top of PostGIS, specializing on processing and analysing spatio-temporal data
Martin Davis: A Deep Dive into PostGIS Nearest Neighbor Search postgr.es/p/4KW
SQL is neither legacy, nor low-level, nor difficult, nor the wrong place for business logic, but simply awesome! vertabelo.com/blog/notes-fro…
"Compare MongoDB vs PostgreSQL: JOIN Command" New blog post Dr. Michael Stonebraker co-authored with me: enterprisedb.com/blog/compare-m… We review how to model "related" data and even compare the performance in a benchmark that is, as usual, open and public: gitlab.com/ahachete/pgmon…


Indexes: The neglected performance all rounder slideshare.net/MarkusWinand/i… Everybody knows indexing is important for performance. Yet nobody takes the time to learn and apply it properly.
slideshare.net
Indexes: The neglected performance all rounder
Open Source, if anything, is about *freedom*. This includes the freedom to not contribute to Open Source projects. Let's stop telling others what they should do. I'd love everybody to contribute everything as Open Source. But I will not criticize those who are not doing it.
Rules I fail to live by: Don't blog angry on the weekend :-) connor-mcdonald.com/2020/02/29/dat…
Federico Campoli (@4thdoctor_scarf): The strange case of the EXCEPTION block postgr.es/p/4Eo
SQLite Is Serverless - Do you Agree ? sqlite.org/serverless.html #sqlite #serverless
Oracle Autonomous Database: waiting for it to take the autonomous decision to replace itself with Postgres.
#PostgreSQL at the center of the stage of the proprietary to open source RDBMs migration stories. @ongresinc experience matches the mentioned trend that not only Oracle but also SQL Server to PostgreSQL migrations are accelerating.


United States Tren
- 1. #DWTS 14.4K posts
- 2. Robert 98.7K posts
- 3. #RHOSLC 2,836 posts
- 4. #WWENXT 9,058 posts
- 5. Elaine 39.3K posts
- 6. Whitney 12.3K posts
- 7. Carrie Ann 1,252 posts
- 8. #DWCS 1,875 posts
- 9. Young Republicans 39.8K posts
- 10. D’Angelo 385K posts
- 11. Politico 240K posts
- 12. Jackson Chourio 1,725 posts
- 13. Charlie 743K posts
- 14. #LHHATL N/A
- 15. Dennis Quaid 1,629 posts
- 16. Erika Kirk 97.4K posts
- 17. Teoscar 2,840 posts
- 18. Angie 68.1K posts
- 19. Matt Cardona 1,404 posts
- 20. Cornelia 1,628 posts
Something went wrong.
Something went wrong.