3 ms·

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, th

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"?

pjmlp 8y ago
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.
- hardwaresofton 8y ago
  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 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 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)...
  - pjmlp 8y ago
    Java, .NET, ADO and C++ drivers from Oracle for example.

pjmlp 8y ago

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.

hardwaresofton 8y ago
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 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 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)...
- pjmlp 8y ago
  Java, .NET, ADO and C++ drivers from Oracle for example.