News for hackers. Stuff that matters.
Re:Programming Language Rankings: January 2019 by hardwaresofton on Friday March 22, 2019 @04:40AM (#19460552)
Uhhh I'm mega out of my depth on that subject -- I don't know. If the systems you're discussing can kick off the distributed computing by just receiving SQL, then there are definitely crates to do that in rust -- that's just a matter of sending SQL on the wire in the right format, right?

I can talk about some SQL drivers though -- I've used `postgres` (postgres), `rusqlite` (sqlite), `r2d2` (connection pooling) and others to great success building some relatively small codebases. For a more pre-baked approach `diesel` is the ORM that everyone is generally on if that's your speed.

Just in case I misinterpreted the question -- were you meaning to say that distributed computing using Oracle/DB2/SQL Server are examples of contradictions to my statement of "everything else" being "application/solution-space level optimization"?

Re:Programming Language Rankings: January 2019 by pjmlp on Friday March 22, 2019 @05:11AM (#19460708)
Two basic examples:

- calling PL/SQL on an Oracle RAC cluster using distributed transactions at driver level.

- define data structures where the driver does the mapping into PL/SQL User Defined Types.

Re:Programming Language Rankings: January 2019 by hardwaresofton on Friday March 22, 2019 @05:43AM (#19460865)
Ahh OK -- so the first thing is basically whether there's a good oracle driver for rust that supports that feature... I don't know/don't think so? I searched "oracle" (https://crates.io/search?q=oracle) and found a bunch of drivers, but I'm not sure which of them support distributed transactions explicitly.

rust-oracle is listed on the shared programming interface page though (https://oracle.github.io/odpi), so maybe it's close if not already possible.

I doubt the second one more though -- how many languages even have an oracle driver with integration that tight to begin with? I struggle to find drivers that map PL/SQL user defined types to in-language types (even with something simple like enums)...

Re:Programming Language Rankings: January 2019 by pjmlp on Friday March 22, 2019 @08:00AM (#19461688)
Java, .NET, ADO and C++ drivers from Oracle for example.