Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Amazon Aurora DSQL

aws.amazon.com

Post reply on HN
Print view View original

61–70 of 146 posts

Re: Amazon Aurora DSQL

#61

Post by paulddraper »

e1g wrote: post #34

Just tried a quick test cluster - Identifies as PG 16.5 No views/triggers/sequences No foreign key constraints No extensions No NOTIFY ("ERROR: Function pg_notify not supported") No nested transactions No json(b) Unsupported PG features are now online https://docs.aws.amazon.com/aurora-dsql/latest/userguide/wor...

Yeah, this is another DocumentDB.

They'd save space by listing the supported features. It's not useless, but no existing application would run on it.

> Unsupported objects

> * Databases - Aurora DSQL supports only one database per cluster at this time.

> * Views

> * Temporary Tables

> * Triggers

> * Types

> * Tablespaces

> * UDFs / Functions other than functions using language = SQL

> Unsupported constraints

> Foreign keys

> Exclusion constraints

> Limitations

> ...

> A transaction cannot modify more than 10,000 rows

If you want a distributed PostgreSQL-lookalike, look at CockroachDB.

Re: Amazon Aurora DSQL

#62

Post by gigatexal »

e1g wrote: post #34

Just tried a quick test cluster - Identifies as PG 16.5 No views/triggers/sequences No foreign key constraints No extensions No NOTIFY ("ERROR: Function pg_notify not supported") No nested transactions No json(b) Unsupported PG features are now online https://docs.aws.amazon.com/aurora-dsql/latest/userguide/wor...

Epic fail then. Wow. That’s DOA.

Re: Amazon Aurora DSQL

#63

Post by panarky »

vosper wrote: post #23
slackerIII wrote: post #14

The only announcement I want from AWS about databases is that the price for RDS is going down. Not that they have new chip that is more expensive but offers better price/performance, but that my bill is actually going to drop. I don't trust them enough to use non-portable technology like this until they give me confidence they are committed to lowering prices.

> The only announcement I want from AWS about databases is that the price for RDS is going down. If the price hasn't been going up in line with inflation then it's been going down in real terms. Not as nice as the number going down, too, but it's not nothing. Over time AWS prices have significantly declined in real terms simply by not having been raised in nominal value.

The inflation rate for chips, memory, storage and networking is negative.

Re: Amazon Aurora DSQL

#64

Post by refset »

e1g wrote: post #34

Just tried a quick test cluster - Identifies as PG 16.5 No views/triggers/sequences No foreign key constraints No extensions No NOTIFY ("ERROR: Function pg_notify not supported") No nested transactions No json(b) Unsupported PG features are now online https://docs.aws.amazon.com/aurora-dsql/latest/userguide/wor...

> Aurora DSQL isolation level is equivalent to PostgreSQL Repeatable Read.

So it lacks Serializable isolation also, but I guess that's the secret to how it "offers the fastest distributed SQL reads and writes".

Re: Amazon Aurora DSQL

#65

Post by zokier »

Can Amazon please get RDS product management ducks in a row? You got RDS For PostgreSQL, Aurora PostgreSQL (provisioned), Aurora Serverless v1, Aurora Serverless v2, Aurora PostgreSQL Limitless Database, Aurora Global Database, and now Aurora DSQL (with PostgreSQL compatibility). It's very confusing, the docs are confusing, and the even the tools are confused.

I think this is pretty big contrast to something like S3 where the product feels far more clearly and coherently managed, and where they have released lots of big improvements/changes over the years without disrupting or muddying the core product in major ways.

Re: Amazon Aurora DSQL

#66

Post by bobnamob »

e1g wrote: post #34

Just tried a quick test cluster - Identifies as PG 16.5 No views/triggers/sequences No foreign key constraints No extensions No NOTIFY ("ERROR: Function pg_notify not supported") No nested transactions No json(b) Unsupported PG features are now online https://docs.aws.amazon.com/aurora-dsql/latest/userguide/wor...

https://docs.aws.amazon.com/aurora-dsql/latest/userguide/CHA...

The quotas page is always the most interesting for any aws service.

10Mb transaction size and 5min transaction duration limits are interesting limitations that kill any "everything lives in the db" notions that one might have.

A fully transactional, scalable, distributed data store + queue + db + data stream with triggers is my endgame

Also, the 128mb limit on transaction temporary storage seems _very_ limiting for big ol' analytic queries

Re: Amazon Aurora DSQL

#69

Post by jcmfernandes »

e1g wrote: post #34

Just tried a quick test cluster - Identifies as PG 16.5 No views/triggers/sequences No foreign key constraints No extensions No NOTIFY ("ERROR: Function pg_notify not supported") No nested transactions No json(b) Unsupported PG features are now online https://docs.aws.amazon.com/aurora-dsql/latest/userguide/wor...

> No foreign key constraints

Wat?

Re: Amazon Aurora DSQL

#70

Post by qaq »

Virtually unlimited scale :)

Maximum storage GB per cluster: 100GB Maximum size of all data modified within a write transaction 10 MiB Max: 10K rows per transaction

Post reply on HN