Earlier quoted context omitted.
I feel like this feature replaces almost all of Mongo's use cases!
As soon as Postgres adds the "random data loss" feature they will have a full superset of Mongo.
You can always turn off fsyncs…
PostgreSQL 10 Beta 1 Released
31–40 of 172 posts
Re: PostgreSQL 10 Beta 1 Released
#32Earlier quoted context omitted.
Every time I see a job post mentioning mysql I realize they just haven't discovered postgres, or they have some really gross problem. :/
Or they want to allow for case-insensitivity of some data, like for example email addresses on login forms. As much as postgres is overall better than MySQL in so many ways, it's still ridiculously difficult to set things up such that SELECT id FROM users WHERE email='foo@example.com' returns the same result as SELECT id FROM users WHERE email='Foo@example.com'
not sure why you got downvoted so much.
Everyone's answer is "just lowercase everything".
I'll respond just a bit:
1. You don't always have control over all the queries that have been written against your database.
2. You would probably lose the ability to use ORMs without a moderate amount of customization.
3. If you're migrating from a different database, you may have checksums on your data that would all need to be recalculated if you change case on everything stored.
4. Doing runtime lowercase() on everything adds a bit of overhead, doesn't it?
citext on postgresql seems a decent option - the citext docs even mention drawbacks of some of the other recommended options.
Re: PostgreSQL 10 Beta 1 Released
#33PostgreSQL is an amazing project. A no-nonsense database that delivers what it promises. I'm amazed at what a talented group of people can accomplish when they are driven and put their mind to it. Thanks for a wonderful product.
Absolutely agreed.
A friend of mine was doing an MBA and was planning a paper on open source collaboration models. She asked me for my opinion on well-run projects and Postgres was the first thing that crossed my mind.
They have an excellent combination of goals, structure and expertise, and have created a remarkably low-drama, functional community around delivering excellent tools. I really think there's a lot to emulate there.
Re: PostgreSQL 10 Beta 1 Released
#34So glad that GiST indexes now support UUID and ENUM data types. That was a big wart for me due to needing exclusion constraints.
Re: PostgreSQL 10 Beta 1 Released
#35Will having logical replication make doing a DB version upgrade in production easier? We're using Postgres 9.4 on RDS right now, and there doesn't seem to be an upgrade path that doesn't involve some downtime.
Re: PostgreSQL 10 Beta 1 Released
#36Will having logical replication make doing a DB version upgrade in production easier? We're using Postgres 9.4 on RDS right now, and there doesn't seem to be an upgrade path that doesn't involve some downtime.
Also interested in this topic. Upgrade with downtime is kind of crappy option for us.
Re: PostgreSQL 10 Beta 1 Released
#37Re: PostgreSQL 10 Beta 1 Released
#38Earlier quoted context omitted.
I feel like this feature replaces almost all of Mongo's use cases!
I'm interested. When you say almost, can you elaborate on any remaining use cases when you'd use Mongo?
I know it's pretty popular to hate on Mongodb now (even more so than it was to love on Mongodb 4 years ago), but there are still areas where it's better than a relational db. In game development, it's extremely helpful (especially as an "indie") to change the structure on a whim so easily. Also based on the design of the game I'm working on, I believe the document structure captures the structure of the data so much better than if I was forced to make a bunch of tables. This aides in understanding the representation of our game's data, and I believe (but haven't tested) it will be faster than a relational db for my use case, but that's an ancillary benefit anyway.
Re: PostgreSQL 10 Beta 1 Released
#39Re: PostgreSQL 10 Beta 1 Released
#40I wished they would implement more from SQL:2011. I have a lot of applications that would benefit from system versioned tables. This is a good sum up of useful modern SQL features: https://www.slideshare.net/MarkusWinand/modern-sql
Get involved in the mailing list and start discussion on these features and how they would help you.