4 ms·
I've been learning SQL recently with PostgreSQL and MySQL in an online bootcamp here in Spain. So far very comprehensive. We've touched indexing and partitionin
by spaniard89277 4y ago
I've been learning SQL recently with PostgreSQL and MySQL in an online bootcamp here in Spain. So far very comprehensive. We've touched indexing and partitioning with EXPLAIN ANALYZE for optimizing performance, and I've implemented this strategies successfully onto an active forum I own.
The SQL course has almost no love by the students but so far it has been the most useful and interesting to me.
I was able to create some complex views (couldn't understand how to make materialized views in MySQL), but they were still very slow.
I decided to copy most of this forum DB to DuckDB (with Knime now, until I know better), and optimization with DuckDB seems pointless. It's very, very fast. Less energy usage for my brain, and less time waiting. That's a win for me.
My current dataset is about 40GB, so It's not HUGE, and sure people here in HN would laugh at my "complex" views, but so far I've reduced all my concerns from optimizing to how to download the data I need without causing problems to the server.
- wodenokoto 4y agoDon’t sell yourself short. I’m sure the minority here knows what a complex view is
- spaniard89277 4y agoI have no real world experience, I've seen things in Stack Overflow that I hardly manage to understand.
- aljgz 4y ago> The SQL course has almost no love by the students This is a big early career mistake. I've seen experienced developers use NoSql in a project where Sql is clearly a great fit, then waste lots of manpower to emulate things you get with Sql for free. Of course one's career can fall into a success path that never depends on SQL, but not learning SQL deeply is not a safe bet.
- spaniard89277 4y agoI've read this again and again in this forum and other dev communities, so I didn't hesitate. I can't say I love SQL, but it's not that bad, Databases look interesting to me.
- dkjaudyeqooe 4y agoMost "programmers" just can't understand relational databases and SQL. It's too hard. I've seen things you wouldn't believe. Random deadlocks in multi-billion transaction reporting systems. Atomic transactions split into multiple commits in banking applications. Copying rows between tables instead of setting a flag on a row. All because highly paid programmers are scared of RDBs.
- kwhitefoot 4y ago> All because highly paid programmers are scared of RDBs. Really? That's not my experience over the last thirty years of programming. As soon as relational databases became something that everyone could use we all jumped in And not just programmers either, a lot of people who never wrote a line of code in their lives became adept at writing SQL in order to get around limitations in ERP systems for instance. Is this problem something that afflicts only younger programmers?
- sn0wtrooper 4y agoAll those strong relations will be lost, like tears in the rain.
- dkjaudyeqooe 4y agoThank you for noticing.
- esja 4y agoI've had the same experience (over decades) and never understood it. SQL should not be difficult for any professional programmer, and it's extremely powerful.
- twh270 4y agoI've got some developer PTSD from a previous project where the solution architect decided to use CosmosDB for the entire domain model that was very relational and very transactional, all because "NoSQL is easy to learn and allows rapid development". Yeah it is, until you're trying to manually create and maintain relations between documents in different schemas owned by different microservices.
- dkjaudyeqooe 4y agoIn the real world a relational database is the single most useful tool short of a compiler/interpreter. SQL is anachronistic but still works well even if its a pain. My advice: avoid MySQL like the plague. PgSQL and SQLite is all you ever need and all you ever want.