TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

Important database news from the last few months

123 pointsby MarkusWinandalmost 7 years ago

14 comments

esaymalmost 7 years ago
Anyone know a really good SQL book or tutorial? Every book I&#x27;ve ever bought is usually way too simple. I&#x27;ll flip to the &quot;advanced&quot; section thinking I&#x27;ll finally learn some tricks only to see the &quot;advance&quot; section just introduces the join syntax...<p>I&#x27;d like a good book that goes over queries common in reporting, you know a 3 page sql query that joins to sub queries that themselves are joining to sub queries. You know, the good stuff!
评论 #17458519 未加载
评论 #17458547 未加载
评论 #17458540 未加载
评论 #17459279 未加载
评论 #17458893 未加载
评论 #17458449 未加载
评论 #17458459 未加载
评论 #17458504 未加载
peatmossalmost 7 years ago
I recently bought the author’s book to brush some cobwebs off parts of my SQLing. Over the years I’ve seen Markus’s blog posts and guides posted here on HN. I’m always impressed when I see an individual focus on a topic and build an identity &#x2F; business like this. Thanks for all the blog posts, Markus!
rm999almost 7 years ago
SQL is by no means perfect. For one, t̶h̶e̶r̶e̶&#x27;̶s̶ ̶n̶o̶ ̶o̶f̶f̶i̶c̶i̶a̶l̶ ̶s̶p̶e̶c̶i̶f̶i̶c̶a̶t̶i̶o̶n̶: some dialects are meaningfully different than others, and even similar ones are often full of implementation details about the underlying database. It has a ton of quirks, and isn&#x27;t as powerful as I&#x27;d always want it to be. And sometimes it can be really hard to read.<p>But I still haven&#x27;t found a better universal &quot;language&quot; to talk about extracting and manipulating data. The core set of functionality of SQL (selects, joins, aggregations) is usually adequate to express powerful ideas. Most importantly, a lot of people who work with data know it, and I&#x27;ve found semi-technical people (including non-programmers) can learn it quickly. Anyone who has been paying attention to trends in the data world in the last 5 years knows SQL is here to stay for the long-term.
评论 #17457914 未加载
评论 #17458183 未加载
评论 #17457890 未加载
Scarbuttalmost 7 years ago
Finally, an open source SQL database with history for data builtin: <a href="https:&#x2F;&#x2F;mariadb.com&#x2F;kb&#x2F;en&#x2F;library&#x2F;system-versioned-tables&#x2F;" rel="nofollow">https:&#x2F;&#x2F;mariadb.com&#x2F;kb&#x2F;en&#x2F;library&#x2F;system-versioned-tables&#x2F;</a><p>Always wondered why this feature has been ignored for so long.
评论 #17457985 未加载
评论 #17457881 未加载
thanatos_demalmost 7 years ago
It would be interesting to see a &quot;new and noteworthy&quot; section in these types of news recaps. There&#x27;s always a lot of hype around new databases, and it&#x27;d be nice to see an unbiased perspective from someone with such deep knowledge of database systems, similar to Aphyr&#x27;s deep dives into consistency and durability.<p>This seems focused on only SQL systems, and only the largest ones, which is okay, but I think there&#x27;s a lot more to the story than that :)
评论 #17458136 未加载
noncomlalmost 7 years ago
From a <i>developer’s</i> point of view, I absolutely hate SQL. Converting my data from and to row format is a pain. Transactions don’t really tie well with the rest of my application logic. And of course embedding multiline SQL statements in my code looks like monstrosity.
评论 #17458181 未加载
olavkalmost 7 years ago
Is this the final nail in the coffin for the NoSQL hype?<p>Although I&#x27;m not sure the road back to sanity is to add SQL interfaces to non-relational database systems. SQL and the relational model are often conflated, both in the NoSQL hype and apparently also in the backlash. I like things like LINQ in .net which allows you to work with a relational model and use relational algebra without having to use the SQL language
评论 #17458062 未加载
评论 #17457911 未加载
Annataralmost 7 years ago
&quot;According to the “shoot the messenger” principle, PostgreSQL has been heavily criticized for fsyncgate. Indeed, PostgreSQL suffers from this problem more than other databases as it doesn&#x27;t offer direct IO.&quot;<p>Not a problem on any illumos based operating system, as fsync(2) and ZFS do what they&#x27;re supposed to do and do not lie about data being on stable storage when it isn&#x27;t. PostgreSQL is a good database, and if you want it to be bullet proof, run it on an illumos based operating system.
评论 #17458142 未加载
评论 #17458372 未加载
spraakalmost 7 years ago
Maybe the NOSQL hype is dying down, but it still seems like for caching for fast reads it can be helpful. What do you think?
评论 #17458103 未加载
geekuillaumealmost 7 years ago
On the database subject, I&#x27;m working on a new project called DBacked, basically a simple and encrypted database backups as a service. I&#x27;m not ready yet for a Show HN (more things to improve on the presentation website) but happy to get your advices ;)
评论 #17458165 未加载
gfodoralmost 7 years ago
&quot;NoSQL&quot; took the idea of a rejection of syntax (SQL) but also, in practice, burned in with it a rejection of vast swathes of database theory that resulted in the modern RDBMSes. It was a meme that was generally easy to ignore and identify the &quot;bad ideas&quot; within if you understood the history of databases. SQL obviously is just an incidental syntactic detail on top of a fairly sound, generalized model for databases -- relational algebra combined with a clear semantic model for transactions (ACID, etc.)<p>These two things I believe will stand the test of time. Everything else, I think, is ultimately incidental complexity to meet operational goals (like indexing, or caching methods, or sharding, or replication, or denormalization) or conceptually useful models and interfaces (like graphs, or literate APIs, or query langauges, or ORMs, etc) on top of these basic facilities that need to be provided by a database system.<p>The trend of NoSQL databases I think can be summarized as people building systems that tilted towards letting these bits of incidental complexity dictate the design of the system as a whole. The overriding concern seemed to be &quot;scalability and performance&quot; with &quot;easy APIs&quot; a close second and so that resulted in specific data structure and API needs or access patterns dictating everything about how the database system itself worked, and how data was modeled in that system.<p>For example, MongoDB was hearalded as finally letting you access a hierarchical data structure without SQL JOINs, but did so not by just providing a nice abstraction on top of a sound relational schema that allowed you to &quot;re-project&quot; your thinking and access patterns to a document-oriented one when it was the right model contextually, but instead by burning that denormalized, document-oriented data structure into the entire conceptual and technical stack for the whole system!<p>The cost, of course, is self-evident since choosing to reject the relational model also chooses to reject the benefits that were explicitly recognized as a reason for the relational model to be a good choice for database systems: normalized data allows a much more rich set of transformations and projections on that data to be unambiguously expressed and fulfilled by the system. In other words, it&#x27;s much more future proofed since you now have the flexibility to mix-and-match and analyze it in arbitrary ways, decoupled from your choice of schema. So the effect of choosing MongoDB meant that you had minimal future-proofing if you got your document structure wrong and suddenly needed to re-project your data in a new way. The supported path, of course, was to &quot;just run map reduce on it&quot; -- ie, lets force every application developer to do the job the database is supposed to do :(<p>It&#x27;s nice to see things are moving forward on this again, hopefully the trend doesn&#x27;t just reverse now and we have a flood of &quot;SQL access&quot; APIs to poorly grounded database systems.
zzzcpanalmost 7 years ago
&gt; The marketing term NoSQL, which was the hippest buzzword just a few years back, is slowly becoming a synonym for a defect. Without SQL, there is something missing.<p>I guess RDBMS companies are too afraid of NoSQL to attack it with such silly propagandist statements. You can&#x27;t win the market this way.<p>To me it increasingly looks like SQL is losing in distributed systems. And NoSQL may never really gain SQL beyond niche usage after all.
评论 #17458262 未加载
mmaunderalmost 7 years ago
Whew. Those years of enduring &quot;SQL is dead&quot; posts were not easy. Now if we can just rebrand &quot;cloud&quot; to &quot;someone else&#x27;s computer&quot;, much will be right with the world.
评论 #17458337 未加载
评论 #17458027 未加载
评论 #17459650 未加载
评论 #17458127 未加载
amirouchealmost 7 years ago
How is realistic this article without a word about FoundationDB?