On Mon, 6 Jun 2016 at 23:00 Greg Keogh <[email protected]> wrote: > I forgot to mention ... don't forget Azure Table Storage! I've been really > loving it recently and using it where a SQL Db would be overkill. The API > is dead simple, vast capacity, cheap, and build and runtime dependencies > are trivial -- *GregK* >
Here is a list of good things about table storage: - And here is a list of caveats for table storage: - No support for complex queries. - Indexes only exist as clustered indexes on the primary key. - No support for computed aggregates. - No support for joins. - No support for server-side stored procedures. - No ACLs support so security trimming must be done manually in the application logic. - No enforced schema or types. Tables may vary shape on a row-by-row basis. - No support for transactions. And slow. David. -- David Connors [email protected] | @davidconnors | LinkedIn | +61 417 189 363
