<br><br><div class="gmail_quote">On Sun, Mar 20, 2011 at 8:09 AM, Guillermo Polito <span dir="ltr"><<a href="mailto:guillermopolito@gmail.com">guillermopolito@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<br><br><div class="gmail_quote">---------- Forwarded message ----------<br>From: <b class="gmail_sendername">Benoit St-Jean</b> <span dir="ltr"><<a href="mailto:bstjean@yahoo.com" target="_blank">bstjean@yahoo.com</a>></span><br>
Date: Sat, Mar 19, 2011 at 2:29 PM<br>
Subject: Re: [SqueakDBX] Problems<br>To: Guillermo Polito <<a href="mailto:guillermopolito@gmail.com" target="_blank">guillermopolito@gmail.com</a>><br><br><br><div><div style="font-family:arial,helvetica,sans-serif;font-size:10pt">
Hi Guillermo,<br><br>Since I'm doing lots of stuff using Smalltalk and a plethora of databases, I'd be willing to help you guys with SqueakDBX & Glorp.<br></div></div></div></blockquote><div><br>Greate. Just using it and reporting problems is good. For example, non of us uses Squeak, so if you do, then we have someone testing there.<br>
</div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div class="gmail_quote"><div><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;">
<br>I'm mostly working on Windows now (WinXP) but I have SQL Server, MS-Access, SQLite, Firebird, MySQL, InterBase & PostgreSQL database servers currently installed and running. I can also test Oracle & DB/2 if needed, all this on Windows of course.<br>
</div></div></div></blockquote><div><br>WOW :) I used to have more or les the same when developing SqueakDBX at the beginning. THen my machine crashed and now I have all that in a VirtualBox image :)<br> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div class="gmail_quote"><div><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;">
<br>If you need to test ports of SqueakDBX, I have many versions of Squeak, Pharo and VisualWorks installed as well as Dolphin, ObjectStudio & VisualAge. Even an old VSE environment that I sometimes fire up to soothe my nostalgic side! :)<br>
</div></div></div></blockquote><div><br><br>Excellent. Right now, WE want/need to support Pharo and Squeak. The rest, is up to the users. Of course we would be glad to help if someone does a port. Indeed, someone did it to Dolphin (I don't know where it is the code).<br>
</div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div class="gmail_quote"><div><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;">
<br>Anyhow, I've been working exclusively with Smalltalk for the last 20 years and used to be working with Glorp's parent,
TOPLink. As a matter of fact, my current employer is still using TOPLink with VisualAge & VisualWorks.<br><br></div></div></div></blockquote><div><br>hehehehe<br> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div class="gmail_quote"><div><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;">If I can be of any help, let me know.<br><br>P.S. I have been thinking, for a long time, about creating a *real-world* database model to seriously test database-related Smalltalk projects/packages/apps. I've always had the impression that testing against a 1000 records table ain't telling you much about how the app/package/project will behave in reality. I could create a real "benchmark" that could be used across multiple databases in not much time if needed.<br>
</div></div></div></blockquote><div><br>Yes, this is interesting. We have 3 benchmarks: DBXTinyBenchmarks, DBXBigBenchmarks and DBXMultipleForksBenchmarks. <br><br>
DBXTinyBenchmarks does selects up to 10.000 records and using the same connection. <br>
DBXBigBenchmarks does queries up to 100000 <br>DBXMultipleForksBenchmarks test concurrency, so we do also 100000 but from different processes using #fork <br><br>The biggest problem in Squeak/Pharo about managing millions of records, is not the framework itself, but the VM and FFI. FFI LOCKS completly the VM while executing a function: no other smalltalk process can run until such function is returned. We achieve this problem while using asynchronous queries in OpenDBX and do active queries to OpenDBX to see whether a querie was finished or not.... Now, Cog releases a multi-threaded VM which supports FFI that does not lock the VM. This will be a lot of progress for Squeak/Pharo.<br>
</div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div class="gmail_quote"><div><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;">
<br>In fact, most of the stuff I do (I'm working on my own OO-RDBMS mapping framework) is tested against millions of records because I've decided, upfront, that I would not put performance aside at the start. My framework ain't as "intelligent" and transparent as Glorp but it's fast, simple and lightweight. And I know how it will behave when faced with
millions of records, with queries using 5-6 LEFT JOINs, subqueries, etc.<br></div></div></div></blockquote><div><br>We are interested in this. We want to build more or less the same. We want an EASY persistent framework on top of SqueakDBX, that let you creat CRUDs and prototype apps very easy. Something like ActiveRecord, SandstonDB, SqueakSave...etc. We are thinking different options and for the moment we thought to use Magritte. Most Smalltalk web applications uses Magritte. So the idea is to use Magritte to ALSO describe the mappings. And then using the description we can get the queries. Keith Hodges did something like Magritte-RDB so we are going to investiage that too. <br>
<br>BTW, which is the license of that framework you are doing ? <br></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div class="gmail_quote">
<div><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><br>I think SqueakDBX & Glorp would benefit being "debugged" against some "real world" data & volume if we ever consider using those tools in a work environment and get passed the "hobby" project.<br>
<br>What do you think?<br></div></div></div></blockquote><div><br>I would love that. We should join forces.<br> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div class="gmail_quote"><div><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><br>See my favorite headache these days... :)<br><br><span><a href="http://myfavoriteheadache.wordpress.com/" target="_blank">http://myfavoriteheadache.wordpress.com/</a></span><div class="im">
<div><br></div></div></div></div></div></blockquote><div><br>Thanks...reading...<br> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div class="gmail_quote">
<div><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><div class="im"><div>
<div> </div>-----------------<br>Benoit St-Jean<br>Yahoo! Messenger: bstjean<br>A standpoint is an intellectual horizon of radius zero.<br>(Albert Einstein)</div></div></div><br></div></div><br>
<br>_______________________________________________<br>
SqueakDBX mailing list<br>
<a href="mailto:SqueakDBX@lists.squeakfoundation.org">SqueakDBX@lists.squeakfoundation.org</a><br>
<a href="http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx" target="_blank">http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx</a><br>
<br></blockquote></div><br>