dventimi

46 ms·

631.
by dventimi 4y ago
For testing if I'm in PostgreSQL I use pgTAP. For version control I use git just as I do for other program units.
632.
by dventimi 4y ago
Ok so if I'm not mixing in compute heavy workloads like the stochastic gradient descent described in the article, then it's less likely I'll saturate the CPU. Perhaps that won't happen at all and then I won't have t
633.
by dventimi 4y ago
disclosure: Supabase user Long time user, first time caller. Besides the DO droplet, separately I also use Supabase and I love it. I understand completely about restricting the content type, maybe just for now. Fun fact: I work around it by
634.
by dventimi 4y ago
It's a little different. Anyway, this is under the constraint "no stored procedures."
635.
by dventimi 4y ago
In PostgreSQL at least, a table can appear as a return type of a function and as a parameter to a function. That's not nothing.
636.
by dventimi 4y ago
"rein in" not "reign in"...typo
637.
by dventimi 4y ago
> As for posting to HN absolutely no thanks. These people are so fucking hostile there is no accomplishment too small to tear apart for entertainment here. I have no interest in it. You make a really good point.
638.
by dventimi 4y ago
If I scale up to saturate the database CPU...by doing data retrieval? Setting aside my skepticism about saturating the CPU with mere data retrieval, how is that solved by moving the data to another host's CPU, when moving the data invo
639.
by dventimi 4y ago
I believe the PC revolution gave a few generations of programmers the mistaken belief that imperative languages with familiar features (Basic, Pascal, C, Perl, Python, Java, etc.) are the only or the best way to interact with computers. For
640.
by dventimi 4y ago
I'm doing this right now with a DO droplet built with PostgreSQL, postgrest, nginx, and not much else. Do you have any tips, tricks, or blog posts you can share based on your experience? You should post it to HN. Strike while the iron&
641.
by dventimi 4y ago
Are they meant for querying data?
642.
by dventimi 4y ago
If you can't use stored procedures which are good for this very case, many databases offer dynamic SQL. That might work in some cases.
643.
by dventimi 4y ago
As for sharing SQL, that's easy to do within a database using views. Across databases with possibly different data models, that's not something I personally ever want to do.
644.
by dventimi 4y ago
> maybe that will change one day I pray that it never does. https://blog.codinghorror.com/object-relational-mapping-is-t...
645.
by dventimi 4y ago
No idea what this means
646.
by dventimi 4y ago
Stored procedures can be relations. Queries are relations. Ergo, stored procedures can be queries.
647.
by dventimi 4y ago
What good is that going to do if the data always resides in the database?
648.
by dventimi 4y ago
The resources I'm familiar with are I/O, memory, and CPU. The only one I believe can be spared in the database by using that resource outside of the database, is CPU. When the database is far from saturated on CPU and latency and
649.
by dventimi 4y ago
People lost their jobs at that time not because of inflation, but because of Volcker's efforts to reign in inflation. Throwing people out of work was a feature not a bug. Raising unemployment was his objective, and he achieved that. Th
650.
by dventimi 4y ago
Many ML models experience offline training, and some online training is fine-tuning a model that was pretrained offline. Hence, I see no particular reason to worry about doing this "in prod."
651.
by dventimi 4y ago
-PostgreSQL extensions are easy to include and use. -pgTAP exists for testing. -A large query in SQL is not made smaller but translating it into an ORM DSL. -If "Query" in "SQL" means it's for querying data, then ev
652.
by dventimi 4y ago
Why would running code in a database process be intrinsically more expensive than running it in some other process?
653.
by dventimi 4y ago
Is a query not a relation?
654.
by dventimi 4y ago
https://news.ycombinator.com/newsguidelines.html Probably off topic
655.
by dventimi 4y ago
Did you know that there are other countries besides Brazil in the region conventionally referred to as Latin America? https://www.washingtonpost.com/archive/politics/1981/01/14/c...
656.
by dventimi 4y ago
No. I'm not. https://www.washingtonpost.com/archive/politics/1981/01/14/c...
657.
by dventimi 4y ago
Evidently, he provided military aid to the junta in El Salvador at the beginning of that country's civil war: https://www.washingtonpost.com/archive/politics/1981/01/14/c...
658.
by dventimi 4y ago
> But it looks like the right thing looking back historically and politically in reality to you
659.
by dventimi 4y ago
That doesn't seem at all reasonable to me.
660.
by dventimi 4y ago
Some people paid that price more than others, and some not at all. Those who paid the most might say that it wasn't worth it to them, and you're in no position to say they're wrong.

More ›