Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
-
The other side of this:
Ok. We have a static 150kloc CSV file, that we want to be able to query randomly.
Is the data set updatable? no.
will any records be deleted? no.
Are the queris static? yes.
Are we going to do anything else with this in the next 5 years? no.
So CRUD, without the C, U or D?
Simple solution: memory resident sqlite database. memory footprint of 30mb. With a bit of sql written.
TL during Code Review: Why no ORM?
Me: 😵 -
@magicMirror why sql at all? O.o
-
The problem I was highlighting wasn't ORM vs non-ORM; the problem I was highlighting was downloading the whole fucking db because you can't use a component in Angular.
As for ORMs, they are tools. You need to know when to hold them and when to fold them. You say PHP and, given the slowness, I take it you're using Eloquent, it's an Active Record (and a bad one at that too), so it's doomed to be slow. Data Mappers are much more reasonable and work fine for 99% of your use cases, really. -
@tosensei you must have seen some shit...
-
@iiii
Need to query the data on 3 columns, one is a possible partial string match.
Sql? yes.
Custom solution? Noooooooo. Fuck that. -
I hope they know what they're doing!
So apparently this is an official company in the UK
> TeamLeader1: I just discovered SQL is actually super fast! The low responsiveness I've experienced comes from our ORM!
> IHateForALiving: well of course SQL is blazingly fast. SQL has been refined by the best engineers in the world for the past 50 years, its performances are unparalleled for everything you could possibly need, unless you want to scale REALLY big. Sequelize, instead, is an Active Record ORM, so it's bound to struggle with huge amount of data, because every single row will get attached a significant amount of black magic to make sure everything syncs correctly. Why is that?
> TeamLeader1: I have a problem with this frontend component, it doesn't allow pagination. I tried downloading the whole DB to bypass that, but the ORM is slow... so I will bypass the ORM and download the whole table with a raw query. Look at that! It works like a charm, it's super duper fast!'
This mf is downloading some 35 thousand rows every time some user loads a page because he doesn't know how to paginate the fucking table with Angular, there's no way these people are real.
rant
optimization
orm
sql