Did Microsoft's DLINQ ever get sorted?
I thought it had some potential, conceptually.
On 31/12/2008, at 3:31 AM, Jim Starkey wrote:
John David Duncan wrote:
What's Squirrel? Does this mean you're implementing a Javascript-
like language with 3-value-logic and embedded SQL?
Yeah, I'm afraid I'm implementing a JavaScript-like language with 3-
valued logic and built-in classes for database access. I'd like it
to look something like this:
function execute (connection, properties)
{
// Get tax info from warehouse
var results = connection.executeAndFetch(
"select w_tax from warehouse where w_id=?",
properties.warehouseId);
var warehouseTax = results.w_tax;
delete results;
// Get tax and next order id from district
results = connection.executeAndFetch(
"select d_tax, d_next_o_id from district where w_w_id=? and
d_id=? for update",
properties.warehouseId,
properties.districtId);
var districtTax = results.d_tax;
var orderId = results.d_next_o_id;
delete results;
// Update next order id
connections.execute(
"update district set d_next_o_id = d_next_o_id + 1 where
w_w_id=? and d_id=? for update",
properties.warehouseId,
properties.districtId);
connection.commit();
}
I'd also like iterators. Objects and exception handling are must
haves. Cheap instantiation is also high on my list.
Squirrel is another dynamic language. There are a lot of them. The
Lua advocates are the most strident of the bunch, but the whole
crowd are generally convinced that their favorite is the one true
dynamic language. I care a lot less. I just want something
suitable for a server-side scripting language.
--
Arjen Lentz, Director @ Open Query (http://openquery.com.au)
MySQL Training from $475/day, DBA/Support from $249/month
My blog is at http://arjen-lentz.livejournal.com
OurDelta: free enhanced builds for MySQL @ http://ourdelta.org
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
