4 ms·
It’s so amazing to have the ability to enhance your database with custom methods. Keeps your data model really well organized across your infrastructure
by snissn 5y ago
It’s so amazing to have the ability to enhance your database with custom methods. Keeps your data model really well organized across your infrastructure
- systemvoltage 5y agoThat's the job of an API IMO.
- uoaei 5y agoAn API makes sense for this case when you won't be throwing away a lot of the raw data in favor of the processed/transformed data. But doing a lot of these operations on-server makes sense when there's a significant volume of highly parallelizable transformations which need to be done on the data before it's usable. Of course the best solution is likely to be a happy medium between the two, where simple low-level transformations are done on-server and the rest of the data preparation is done as the data is transferred to the client.
- mrbungie 5y agoNot in data processing. There are cases where you have so much data that is better to bring computation to data rather than the other way around.
- FridgeSeal 5y agoHaving dealt with the fallout of a database that’s had hundreds of stored procedures and custom code stapled into it: never again. It was so hard to debug, so hard to safely maintain these procs, and a general nightmare