Hacker News
- How PostgreSQL aggregation works and how it inspired our hyperfunctions’ design https://blog.timescale.com/blog/how-postgresql-aggregation-works-and-how-it-inspired-our-hyperfunctions-design-2/ 31 comments
- Working around a case where the Postgres planner is “not very smart” https://heap.io/blog/when-the-postgres-planner-is-not-very-smart 59 comments
- Why Postgres RDS didn't work for us https://medium.com/@mkremer_75412/why-postgres-rds-didnt-work-for-us-and-why-it-won-t-work-for-you-if-you-re-implementing-a-big-6c4fff5a8644 115 comments
Lobsters
- Working with postgresql-simple with generic-sop https://ocharles.org.uk/blog/posts/2014-08-07-postgresql-simple-generic-sop.html 14 comments haskell
- PostgreSQL Begins Working On Zstd Compression Support https://www.phoronix.com/scan.php?page=news_item&px=PostgreSQL-ZStd-Start 110 comments programming
- Working With JSON in Postgres 14 https://aaronbos.dev/posts/postgres-14-json 5 comments postgresql
- Working with PostgreSQL - Zerodha Tech Blog https://zerodha.tech/blog/working-with-postgresql/ 4 comments postgresql
- How PostgreSQL replication works https://medium.com/moveax/how-postgresql-replication-works-6288b3e6000e 12 comments postgresql
- Working with Hierarchical Structures in Postgres https://hoverbear.org/blog/postgresql-hierarchical-structures/ 6 comments postgresql
- Complete Guide on Working with Python and PostgreSQL https://pynative.com/python-postgresql-tutorial/ 5 comments programming
- PostgreSQL workings in one picture. http://blog.postgresql-consulting.com/2017/09/postgresql-workings-in-one-picture.html?m=1 8 comments programming
- Working with DateTimeRangeField in Django 1.11 and PostgreSQL https://www.reddit.com/r/django/comments/74ls0w/working_with_datetimerangefield_in_django_111_and/ 7 comments django
- Having an issue getting Postgres working on Rails app. https://www.reddit.com/r/rails/comments/6ohu2p/having_an_issue_getting_postgres_working_on_rails/ 8 comments rails
- Working with time in Postgres http://www.craigkerstiens.com/2017/06/08/working-with-time-in-postgres/ 3 comments programming
- New to Docker - need help understanding how Postgres works in it https://www.reddit.com/r/docker/comments/5rcohy/new_to_docker_need_help_understanding_how/ 4 comments docker
- What features should Postgres work on next? http://rhaas.blogspot.com/2016/01/postgresql-past-present-and-future.html 17 comments programming
- 4 Tips for Working with Dates in PostgreSQL http://blog.sensible.io/2013/08/26/4-tips-for-working-with-dates-in-postgresql.html 40 comments programming
- My college from a company I'm working for made a detailed list of changes and maintainers who made PostgreSQL 14 possible. IMO it's a pretty good reference. https://en.euro-linux.com/blog/postgresql-14-a-detailed-list-of-changes 3 comments postgresql
- Why is my app working with my PostgreSQL database without importing psycopg2? https://docs.djangoproject.com/en/3.2/ref/databases/#postgresql-notes 5 comments django
- An overview of PostgreSQL, how it works, and its benefits & shortcomings as an open-source database https://www.openlogic.com/blog/what-is-postgresql 6 comments opensource
- Getting SQL Provider to work with PostgreSQL https://fsprojects.github.io/SQLProvider/ 9 comments fsharp
- Can't figure out why retrieving data from aws rds postgresql won't work when deployed on heroku https://fundingrates.herokuapp.com/ 3 comments heroku
- Im getting "Error: connect ECONNREFUSED" while trying to connect to postgresql(this only happened because im using docker, before docker everything worked fine) https://www.reddit.com/r/docker/comments/i5jy70/im_getting_error_connect_econnrefused_while/ 26 comments docker
- How do PostgreSQL triggers work depending on the current transaction isolation level https://vladmihalcea.com/postgresql-triggers-isolation-levels/ 3 comments programming
- New library - EntityFramework.Exceptions: Handle database errors easily when working with Entity Framework Core. Supports SQLServer, PostgreSQL and MySql https://github.com/Giorgi/EntityFramework.Exceptions 6 comments csharp
- New library - EntityFramework.Exceptions: Handle database errors easily when working with Entity Framework Core. Supports SQLServer, PostgreSQL and MySql https://github.com/giorgi/entityframework.exceptions 12 comments programming
- Architecture when working with raw SQL and Express + Postgres? https://www.reddit.com/r/javascript/comments/9m7uuz/architecture_when_working_with_raw_sql_and/ 9 comments javascript
- Sequelize, Knex, Bookshelf? What do you prefer when working with PostgreSQL? https://www.reddit.com/r/node/comments/8deq8x/sequelize_knex_bookshelf_what_do_you_prefer_when/ 4 comments javascript
- How I got ASP.NET Core RC2 with Entity Framework and PostgreSQL hosted on Ubuntu working. http://totaltechware.blogspot.com/2016/05/aspnet-core-rc2-with-entity-framework.html 5 comments webdev
- Working with UUID in Ruby on Rails 6 with PostgreSQL https://pawelurbanek.com/uuid-order-rails 23 comments ruby
- PostgreSQL SWAG: JSON data type and working with Twitter data http://bibhas.in/blog/postgresql-swag-json-data-type-and-working-with-twitter-data/ 18 comments programming
- Built a console based database viewer/editor. Only works with SQLite3 atm, but will add MySQL and PostgreSQL as well if people want it. https://github.com/coffeeandscripts/sqlcrush 24 comments programming
- Easy migrations for relational databases with rollback on failure (works with at least Postgres and SQLite, but probably not MySQL) https://github.com/burntsushi/migration 5 comments golang
- Try Valentina Studio - a new FREE GUI Manager for PostgreSQL, mySQL, mariaDB, SQLite. It works native on Mac, Linux, Windows. http://www.valentina-db.com/valentina-studio-overview 92 comments webdev
- PSA: Azure data studio is a modern version of SSMS and works locally for both SQL Server and PostgreSQL databases now(locally) https://docs.microsoft.com/en-us/sql/azure-data-studio/download?view=sql-server-2017 31 comments programming
- TypeORM - data-mapper ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, WebSQL databases. Works in Node.js and Browser. https://github.com/typeorm/typeorm 11 comments javascript
- Data-Mapper ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, WebSQL databases. Works in Node.js and Browser. https://github.com/typeorm/typeorm 16 comments dotnet
- Data-Mapper ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, WebSQL databases. Works in Node.js and Browser. https://github.com/typeorm/typeorm 9 comments node
- Data-Mapper ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, WebSQL databases. Works in Node.js and Browser. https://github.com/typeorm/typeorm 6 comments typescript