dhd415

31 ms·

271.
by dhd415 10y ago
For Aurora, you mean? They support 5.7 for RDS, but a consequence of forking MySQL for Aurora is that it's unlikely that new MySQL features will quickly be incorporated into Aurora/MySQL.
272.
by dhd415 10y ago
I'm curious how much of the underlying pgsql storage engine was rewritten since Aurora/MySQL uses a completely different engine than the default InnoDB.
273.
by dhd415 10y ago
Some SQL databases (e.g., SQL Server and PostgreSQL) offer key-range locking which, along with a serializable isolation level, will prevent this race condition.
274.
Amazon to Launch Aurora Service for PostgreSQL at Re:Invent(theregister.co.uk)
2 points by dhd415 10y ago|0 comments
275.
SQL Server on Linux Runs inside Microsoft's Drawbridge Sandbox(theregister.co.uk)
2 points by dhd415 10y ago|0 comments
276.
SQL Server on Linux runs inside Microsoft's Drawbridge Sandbox(theregister.co.uk)
1 points by dhd415 10y ago|1 comments
277.
by dhd415 10y ago
They haven't made all of the Enterprise Edition features available on all lower editions, but they have made many big ones such as table partitioning, Always Encrypted, in-memory OLTP, etc. available in most lower editions. There are a
278.
by dhd415 10y ago
Some of the huge news here is that as of SP1, the following features that were one exclusive to the Enterprise Edition of SQL Server are now available in Standard and Web Editions: Change Data Capture, database snapshots, column stores, tab
279.
by dhd415 10y ago
I love pgsql and it has some features that SQL Server does not, but SQL Server also has a range of features that pgsql does not including index-organized tables, automatically-updated materialized views, much more mature support for query p
280.
Many SQL Server Enterprise Features Now Available in Std, Web, and Express Edition(sqlperformance.com)
3 points by dhd415 10y ago|0 comments
281.
by dhd415 10y ago
Lots of previously Enterprise Edition-only features such as table partitioning and data compression are now available in Standard, Web, and local editions. This is a pretty big deal. More detail here: https://sqlperformance.com&#
282.
by dhd415 10y ago
Interesting, I've never heard of striping tricks like that. Do you have any links on that? And I suppose that could be applicable to EBS since it rather than S3 is the backing store for RDS.
283.
by dhd415 10y ago
I'm using RDS MySQL and have never been able to utilize more than ~25% of the provisioned IOPS or more than 100MB/s transfer rate. Also, as best as I can tell, EBS latency is pretty high so making lots of small, serial database ca
284.
Memory Usage in CockroachDB(cockroachlabs.com)
6 points by dhd415 10y ago|0 comments
285.
by dhd415 10y ago
I'm surprised there aren't more mentions of Tasks in C# or F# on the .NET platform as examples of asynchronicity done well. From the perspective of uniformity and availability, while C# provided asynchronicity via callbacks before
286.
by dhd415 10y ago
I would agree. One of the things I felt when I first moved to working remotely was a sense of isolation due partly to losing the awareness of what other people or teams were working on that you have when working in an office due to just see
287.
by dhd415 10y ago
That's along the lines of what I do. I get a used Thinkpad for occasional travel and use it to remote into my beastly dual Xeon workstation that is stupid fast and less than half the cost of a 2015 MacBook Pro.
288.
by dhd415 10y ago
+1. They'd have a much stronger case if they didn't drag in silly complaints such as "[Google BQ] does not support the ANSI SQL syntax of 'substring'. Need to change to 'substr'".
289.
by dhd415 10y ago
Having gone through this process recently, there's a lot of truth in this post. I experienced more companies "ghosting" during the process than slow turnaround times, but it is remarkable how short-sighted companies are durin
290.
by dhd415 10y ago
It's an interesting idea, but I prefer to take my experience and tell a story that specifically targets the role for which I am applying. From that perspective, having a single "story" out there for all potential employers is
291.
by dhd415 10y ago
The presentation is a little light on the technical details of how the demo was run. What I could get from the presentation was 1M fraud predictions/sec via R stored procedures on data streaming into SQL Server 2016 stored in in-memory
292.
by dhd415 10y ago
Hmm, I've never run SQL Server on anything other than NTFS where 64KB was definitely the recommended block size. In either case, it's great to have choices. When the license fee is coming out of my pocket, I'm definitely not
293.
Implementing column families in CockroachDB(cockroachlabs.com)
2 points by dhd415 10y ago|0 comments
294.
by dhd415 10y ago
I'm a fan of both PostgreSQL and SQL Server, but I think these numbers are very workload-specific. I've gotten 1GB/s throughput on SQL Server 2012 on spinning disks and CPUs older than the E5620, so I've no doubt that sa
295.
by dhd415 10y ago
>>In InnoDB all the data is stored in the PK while in PG it is just a pointer. This is just a consequence of the PK being a clustered index in InnoDB which has both pros and cons. One of the big cons is that all of the columns of the
296.
by dhd415 10y ago
PostgreSQL, for better or worse, doesn't have pluggable storage engines. There's some discussion on their dev mailing list about the possibility of adding that capability in PG10, though: http://postgresql.nabble.com&#x
297.
Google may launch Andromeda OS on rumored 7 inch Huawei Nexus tablet(androidpolice.com)
3 points by dhd415 10y ago|0 comments
298.
Google is planning a Pixel 3 laptop running the Andromeda OS for Q3 2017(androidpolice.com)
4 points by dhd415 10y ago|0 comments
299.
Safe and unsafe operations for high volume PostgreSQL(leopard.in.ua)
2 points by dhd415 10y ago|0 comments
300.
by dhd415 10y ago
The "compact" phones in the Sony Xperia line are really the only ones that come close. My wife is still happily using her Z3 Compact though its successor, the Z5 Compact, didn't review as well. The newest Xperia X Compact is

More ›