Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
dhd415
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
40 ms
·
151.
▲
Apple fans returning new MacBook Pros with Core i9
(finance.yahoo.com)
98 points
by
dhd415
8y ago
|
65 comments
152.
▲
by
dhd415
8y ago
Or cheaper Glendronach for that matter? It's 40-60% more expensive than Macallan here.
153.
▲
System.IO.Pipelines – High Performance IO in .NET
(blogs.msdn.microsoft.com)
3 points
by
dhd415
8y ago
|
0 comments
154.
▲
by
dhd415
8y ago
Perforce has supported concurrent versioning since at least 2001 if not earlier. Individual files could be marked as requiring locks which is useful for binary files for which concurrent changes cannot be merged (one of the big reasons why
155.
▲
by
dhd415
8y ago
I'm not sure articles like this one do non-database professionals any favors by associating unrelated concepts that are often found together such as relational databases and ACID compliance. There are both relational databases that are
156.
▲
by
dhd415
8y ago
It's because of selective incorporation. ( https://www.law.cornell.edu/wex/incorporation_doctrine ). For example, the Second Amendment wasn't incorporated against the states until 2010 in McDonald v. City of Ch
157.
▲
by
dhd415
8y ago
I think the article intended to highlight features specific to PostgreSQL. CTEs are undeniably great, especially recursive CTEs, but they're also part of the SQL:1999 standard and available in lots of databases.
158.
▲
by
dhd415
8y ago
Long comment thread on a previous posting: https://news.ycombinator.com/item?id=12166585 TLDR: Uber is using MySQL as part of their "Schemalass" key-value store ( https://eng.uber.com/schemaless-par
159.
▲
by
dhd415
8y ago
LSMs do not guarantee that sequential key/value pairs are stored in the same SSTable so reading "n" k/v pairs, in the worst case, could require seeking through "n" different SSTables. There are datastores that
160.
▲
by
dhd415
8y ago
I have the same setup and it's great for some development tasks, but its single-core speed can't match the latest processors. I actually installed Linux on my company-issued MBP and I run a bunch of dev tools on it via Xwin from m
161.
▲
by
dhd415
8y ago
For those reasons, I like Xfce and LXDE on Xubuntu and Lubuntu, respectively. I use those for workstations, they've got the same CLI features as Ubuntu, and I don't need or want a bunch of GUI chrome in my dev environments.
162.
▲
by
dhd415
8y ago
I'm happy to see that MySQL is progressing, but I think that enumerating its adherence to the latest SQL standards overlooks some of its other serious flaws from the perspective of operations and reliability. Below are two of the worst
163.
▲
One Giant Leap for SQL: MySQL 8.0 Released
(modern-sql.com)
136 points
by
dhd415
8y ago
|
152 comments
164.
▲
by
dhd415
8y ago
Their basic approach for handling time series data -- partition the inserts by time range -- is one that works for pretty much any relational database. If you can treat the data as immutable which is often the case with time series data, it
165.
▲
by
dhd415
9y ago
Yeah, apart from contractors who are between gigs, I can't imagine very many people who can work for a week as part of the hiring process. And even if many applicants could, I think it takes longer, sometimes quite a bit longer, to acc
166.
▲
by
dhd415
9y ago
I'm not sure what you mean by "multi-process DB", but there are plenty of workloads in which SQLite under-performs non-MVCC databases. It is simply not designed for highly concurrent access patterns. In a previous job, I had
167.
▲
by
dhd415
9y ago
I think skill differentials in programming is a contributing factor to the bimodal distribution. I think there's also another factor which is the degree to which one is an active "curator" of one's own career. I've
168.
▲
by
dhd415
9y ago
>>Random distribution seems like it would be better for write performance - it means that inserting multiple new values and rebuilding the index can happen in parallel rather than having to coordinate the auto increments. It also natu
169.
▲
by
dhd415
9y ago
The sequencing of those UUIDs resets every time Windows restarts. Given the frequency of OS and SQL Server updates that require reboots, that wasn't good enough for any of my workloads.
170.
▲
by
dhd415
9y ago
Making blanket generalizations in the title of an article is a terrible idea. Auto-increment integer IDs work for different use cases than UUIDs. This article does a decent job of describing the scenarios where UUIDs work well, but its sect
171.
▲
by
dhd415
9y ago
Given the existing architecture of Aurora, the independent scaling of CPU and storage seems pretty straightforward. What is much harder to scale up and (especially) down is a warmed-up buffer pool which is critical for consistent query perf
172.
▲
by
dhd415
9y ago
It would certainly be nice to disable just that one section. I took the GGP's comment to be about disabling the entire Google Now/Feed app.
173.
▲
by
dhd415
9y ago
FWIW, you can disable Google Now on your phone. On the more recent versions of Android, you long-press an empty spot on your home screen, select "Settings", and then locate and disable the "Your feed" item.
174.
▲
by
dhd415
9y ago
The article says, "The [new instance class] db.r4.16xlarge will give you additional write performance." Does anyone know why this is the case? I thought one of the distinguishing characteristics of Aurora was that the read and wri
175.
▲
by
dhd415
9y ago
An article from Ars Technica [1] on this topic makes the following point: "Unlike most Azure compute resources, which are typically shared between customers, the Cray supercomputers will be dedicated resources. This suggests that Micro
176.
▲
Cray supercomputers coming to Azure Cloud
(arstechnica.com)
3 points
by
dhd415
9y ago
|
0 comments
177.
▲
How to work with me
(cockroachlabs.com)
4 points
by
dhd415
9y ago
|
0 comments
178.
▲
Automated node rebalancing and repair in CockroachDB
(cockroachlabs.com)
1 points
by
dhd415
9y ago
|
0 comments
179.
▲
by
dhd415
9y ago
A missing small feature here or there is kind of a lame reason to not take a large and well-respected product seriously. That said, bcp and PowerShell (piping the output of Invoke-Sqlcmd through Export-CSV) are among the more common ways th
180.
▲
by
dhd415
9y ago
That may be the case for other products, but in this case, they acquired the "Sybase SQL Server" product and simply renamed it "Microsoft SQL Server".
More ›