Top all-time · #4672
Vertabelo
Company blog · vertabelo.com/blogdataprogramming
Vertabelo is the company blog at vertabelo.com, writing about data and programming. Since 2013, 16 different Hacker News readers have linked it 153 times, most often “Why SQL is neither legacy nor low-level nor difficult nor wrong for data logic”. The last post was in 2020, but the archive is still widely read.
Most-linked posts?
- Why SQL is neither legacy nor low-level nor difficult nor wrong for data logic6 people · 6 mentions · first linked 2015-10-07
- Business Logic in the Database. Yes or No? It Depends3 people · 4 mentions · first linked 2016-01-19
- How a Billion Dollar Mistake Has Been Stalking a Whole Industry for Decades2 people · 3 mentions · first linked 2015-11-24
- Collaborative database design2 people · 2 mentions · first linked 2013-10-14
- S.Q.L or Sequel: How do you pronounce SQL?2 people · 2 mentions · first linked 2014-09-03
- A History of the PostgreSQL Elephant Logo2 people · 2 mentions · first linked 2022-06-16
What Hacker News says?
I always like to link these articles when the topic comes up: https://sivers.org/pg https://www.vertabelo.com/blog/business-logic-in-the-databas... https://www.martinfowler.com/articles/dblogic.html There is also this video on how to properly architect these kinds of applications: https://youtu.be/PMPW024NIDE?t=1052
Comment linking /blog/business-logic-in-the-database-yes-or-no-it-depends/
on “What ORMs have taught me: just learn SQL (2014)”Submitted MySQL: Why “My”? as a story · 51 points
HN discussionVertabelo has a blog which is almost entirely devoted to modelling schemas for various contrived scenarios: https://www.vertabelo.com/blog/ .. I take umbrage with some of the decisions made but broadly they are interesting and well thought out.
Comment linking /blog/
on “Ask HN: What are some examples of good database schema designs?”Submitted A Database Model for Simple Board Games as a story · 34 points
HN discussionSome interesting posts/articles on the topic: https://www.vertabelo.com/blog/business-logic-in-the-databas... https://sivers.org/pg https://www.martinfowler.com/articles/dblogic.html
Comment linking /blog/business-logic-in-the-database-yes-or-no-it-depends/
on “ORMs Are Backwards”Submitted Why SQL is neither legacy nor low-level nor difficult nor wrong for data logic as a story · 10 points
HN discussionI think the jury's still out on that one. I've always spelled it out (and I always will, dammit!), I've had professors either spell it out or pronounce it, and it very much seems to be a mix of regional preference and past experience. Of course, there's two arguments here: One is that SEQUEL was changed to SQL to avoid possible trademark issues (thus implicating that this also necessitated a change in the pronunciat…
Comment linking /blog/notes-from-the-lab/sql-or-sequel
on “English has been my pain for 15 years (2013)”Submitted SQL joins as a story · 6 points
HN discussion- _e · 2017-07-30
Thank you for sharing your thoughts on the two. You might find Vertabelo [1] useful and possible replacement of LucidChart & Visio for db modeling. [1] http://www.vertabelo.com/
Comment linking /
on “Postage – A fast replacement for pgAdmin” Submitted Interesting changes in MySQL 5.7 as a story · 5 points
HN discussion"Best" is tricky, but Vertabelo have been doing practical data model design walkthroughs for various scenarios over the past year or two: http://www.vertabelo.com/blog .. things as diverse as data models for a 3D chess set, parking system, pet care company, office leasing, etc.
Comment linking /blog
on “Ask HN: Best resources on database design”Submitted Why SQL is simply awesome as a story · 5 points
HN discussion> the logic is in how the rows and columns are updated, which takes place (and should) in the "application", not the "storage mechanism". Business logic is any logic that exists to encode business requirements[1], everything else is just plumbing. If there is a requirement that each product must have a category, then you need business logic to enforce this. If there is a requirement that a price must not be negative…
Comment linking /blog/notes-from-the-lab/business-logic-in-the-database-yes-or-no-it-depends
on “Ask HN: Why shouldn't business logic sit in the database?”Submitted Business Logic in the Database. Yes or No? It Depends as a story · 4 points
HN discussionAnother article on the same: http://www.vertabelo.com/blog/notes-from-the-lab/business-lo...
Comment linking /blog/notes-from-the-lab/business-logic-in-the-database-yes-or-no-it-depends
on “Domain Logic and SQL”Submitted 5 Tips to optimize your SQL queries as a story · 4 points
HN discussionSubmitted Do we still need server side programming? as a story · 4 points
HN discussionSubmitted SQL vs. Mongo query as a story · 4 points
HN discussionSubmitted Business Logic in the Database. Yes or No? It Depends as a story · 3 points
HN discussionSubmitted The Reference Data Pattern: Extensible and Flexible as a story · 3 points
HN discussionSubmitted SQL Server 2008 Datatypes and the Death of Datetime as a story · 3 points
HN discussionSubmitted 19 Online Resources for Learning About Database Design Errors as a story · 3 points
HN discussionSubmitted Why SQL is neither legacy, nor low-level, nor difficult but simply awesome as a story · 3 points
HN discussionSubmitted 9 tips for better database design as a story · 3 points
HN discussionSubmitted 7 common database design errors as a story · 3 points
HN discussionSubmitted “A Check List for Doing Data Model Design Reviews” by Kent Graziano as a story · 3 points
HN discussionSubmitted Database Normalization Primer: How (and how not) to decompose relations as a story · 3 points
HN discussionSubmitted Foreign Data Wrappers for PostgreSQL as a story · 3 points
HN discussionSubmitted My weirdest database experience as a story · 3 points
HN discussionSubmitted Cheatsheet: Collations in MySQL as a story · 3 points
HN discussion
