[Pharo-users] Glorp + NBSQLite3

2014-09-24 Thread Pierce Ng
Hello, I am pleased to report that I have gotten Glorp working with NBSQLite3 enough to run Sven's Reddit.st. As mentioned in my blog post, there is more work to be done to get Glorp fully integrated with NBSQLite3, but preliminary results are encouraging. http://www.samadhiweb.com/blog/2014

Re: [Pharo-users] Glorp + NBSQLite3

2014-09-24 Thread Esteban A. Maringolo
This is really cool! How does SQLite scale in terms of table size and so on? I was surprised to know it is based on an old version of PostgreSQL according to this presentation: http://www.pgcon.org/2014/schedule/events/736.en.html Regards! Esteban A. Maringolo 2014-09-24 13:17 GMT-03:00 Pierce

Re: [Pharo-users] Glorp + NBSQLite3

2014-09-25 Thread Pierce Ng
On Wed, Sep 24, 2014 at 01:33:02PM -0300, Esteban A. Maringolo wrote: > How does SQLite scale in terms of table size and so on? According to https://www.sqlite.org/whentouse.html: An SQLite database is limited in size to 140 terabytes (2^47 bytes, 128 tibibytes). And even if it could handle l

Re: [Pharo-users] Glorp + NBSQLite3

2014-10-03 Thread stepharo
On 24/9/14 18:17, Pierce Ng wrote: Hello, I am pleased to report that I have gotten Glorp working with NBSQLite3 enough to run Sven's Reddit.st. Cool what is NBSQLite3 (a nativeboost version)? Nice. Would be nice once you API stabilize that we get a chapter or on NBSQLite3 :) As mentioned

Re: [Pharo-users] Glorp + NBSQLite3

2014-10-03 Thread Sanjay-M
There is a discussion on developing client/server in Dolphin Smalltalk's online documentation http://www.object-arts.com/downloads/docs/index.html -> Appendix B -> Application Patterns -> New Application #consequences. I was wondering if this approach could be adopted in developing a Client/Server

Re: [Pharo-users] Glorp + NBSQLite3

2014-10-06 Thread Pierce Ng
On Fri, Oct 03, 2014 at 10:44:43PM +0200, stepharo wrote: > Cool what is NBSQLite3 (a nativeboost version)? Nice. Would be nice > once you API stabilize that we get a chapter or on NBSQLite3 :) Yes, NativeBoost interface to SQLite. Yes, I plan to write a chapter on it. :-) Pierce

Re: [Pharo-users] Glorp + NBSQLite3

2014-10-06 Thread Pierce Ng
On Fri, Oct 03, 2014 at 09:19:15PM -0700, Sanjay-M wrote: > I was wondering if this approach could be adopted in developing a > Client/Server application with a separate server component accessing the > SQLite database (on a separate machine). Using HTTP/S as the client-server protocol, have the w

Re: [Pharo-users] Glorp + NBSQLite3

2014-10-06 Thread Sanjay-M
I am thinking of situations where we cannot have a web server even on the intranet - more like traditional servers accessed over TCP/IP - --- Regards, Sanjay -- View this message in context: http://forum.world.st/Glorp-NBSQLite3-tp4779996p4782972.html Sent from the Pharo Smalltalk Users mai

Re: [Pharo-users] Glorp + NBSQLite3

2014-10-06 Thread Esteban A. Maringolo
Sanjay-M wrote: > I was wondering if this approach could be adopted in developing a > Client/Server application with a separate server component accessing the > SQLite database (on a separate machine). > If a template / model can be developed i am sure this can be very useful in > creating large

Re: [Pharo-users] Glorp + NBSQLite3

2014-10-06 Thread Esteban A. Maringolo
Pierce, Thank you for the answers. Is the wrapper thread safe? I understan the library is thread-safe per se (at least in Android+Java it is), so using the wrapper in Pharo (single-threaded at the OS level) wouldn't cause issues. But I don't know how NativeBoost plays here. Regards! Esteban A

Re: [Pharo-users] Glorp + NBSQLite3

2014-10-06 Thread Sanjay-M
what I was saying was supposing we write a server that alone only accesses the SQLite database. Users behave like clients accessing the server over TCP/IP. and the text i pointed to in my earlier mail detailed how such a scenario could be implemented. If someone could write a small sample with sa

Re: [Pharo-users] Glorp + NBSQLite3

2014-10-06 Thread Esteban A. Maringolo
2014-10-06 14:11 GMT-03:00 Sanjay-M : > what I was saying was supposing we write a server that alone only accesses > the SQLite database. Users behave like clients accessing the server over > TCP/IP. > and the text i pointed to in my earlier mail detailed how such a scenario > could be implemented.

Re: [Pharo-users] Glorp + NBSQLite3

2014-10-07 Thread Esteban A. Maringolo
More reasons to consider SQLite as solid option: 50% faster than 3.7.17 The latest SQLite 3.8.7 alpha version (available on the download page http://www.sqlite.org/download.html) is 50% faster than the 3.7.17 release from 16 months ago. That is to say, it does 50% more work using the same number