Re: [Pharo-users] SQLite + Pharo

2016-07-12 Thread Esteban A. Maringolo
I have no experience with SQLite other than for testing it on Glorp and using it in Android (that provides a locking mechanism to queue requests), but according to the documentation it depends on how the SQLite connection is opened, if it is opened in "Serialized" mode [1], then it is safe to have

Re: [Pharo-users] SQLite + Pharo

2016-07-12 Thread Alistair Grant
On 12/07/2016 10:19 AM, "Hilaire" wrote: > > Hi, > > So what is it exactly regarding busy state of Sqlite? > The documentation is very short, to not say inexistant, on that specific > important matter. I also haven't read anything official, but my experience is that if the db is locked sqlite wai

Re: [Pharo-users] SQLite + Pharo

2016-07-12 Thread Hilaire
Hi, So what is it exactly regarding busy state of Sqlite? The documentation is very short, to not say inexistant, on that specific important matter. I am just learning statement, it is nice the Pharo Sqlite pacakge comes with it to avoid sql malware injection. Thanks Hilaire Le 10/07/2016 17:

Re: [Pharo-users] SQLite + Pharo

2016-07-10 Thread Hilaire
Hi Esteban, What is exactly thread safe from the Pharo perspective? Is Sqlite library handling the conflict of access, and put on wait an access not possible at a given moment, or does it signal it is busy? In the later case handling a wait may be necessary. I'm planing to use sql to manage users

Re: [Pharo-users] SQLite + Pharo

2016-07-10 Thread Esteban A. Maringolo
The SQLite shared library is thread safe by default, so you shouldn't worry about that. El jul. 9, 2016 7:50 AM, "Hilaire" escribió: > Le 09/07/2016 11:42, Pierce Ng a écrit : > > > After making UDBCSQLite3 work with Glorp on Pharo 5, I've > decided/realized that > > I don't have time to maintain

Re: [Pharo-users] SQLite + Pharo

2016-07-09 Thread Bernardo Ezequiel Contreras
Mark, im using this Metacello new smalltalkhubUser: 'TorstenBergmann' project: 'UDBC'; configuration: 'UDBC'; version: #bleedingEdge; load. on pharo 5 On Sat, Jul 9, 2016 at 7:41 AM, Mark Bratcher wrote: > Is UDBCSQLite3 available somewhere? I've tried Google and it turns up > nothing b

Re: [Pharo-users] SQLite + Pharo

2016-07-09 Thread Hilaire
Le 09/07/2016 11:42, Pierce Ng a écrit : > After making UDBCSQLite3 work with Glorp on Pharo 5, I've decided/realized > that > I don't have time to maintain both it and NBSQLite3. I'm leaving NBSQLite3 > more > or less as is, and continue to work on UDBCSQLite3. It is fine and your contribution

Re: [Pharo-users] SQLite + Pharo

2016-07-09 Thread stepharo
Le 9/7/16 à 12:33, Esteban Lorenzano a écrit : On 09 Jul 2016, at 11:42, Pierce Ng wrote: On Wed, Jul 06, 2016 at 11:24:51AM +0200, Hilaire wrote: I guess UDBC is for Pharo 5, and for Pharo 4 it is the NB version, right? Yes. I guess both version has the same public interface. Yes, but.

Re: [Pharo-users] SQLite + Pharo

2016-07-09 Thread Mark Bratcher
Is UDBCSQLite3 available somewhere? I've tried Google and it turns up nothing but maybe two threads discussing it. On 7/9/2016 6:33 AM, Esteban Lorenzano wrote: On 09 Jul 2016, at 11:42, Pierce Ng wrote: On Wed, Jul 06, 2016 at 11:24:51AM +0200, Hilaire wrote: I guess UDBC is for Pharo 5, a

Re: [Pharo-users] SQLite + Pharo

2016-07-09 Thread Esteban Lorenzano
> On 09 Jul 2016, at 11:42, Pierce Ng wrote: > > On Wed, Jul 06, 2016 at 11:24:51AM +0200, Hilaire wrote: >> I guess UDBC is for Pharo 5, and for Pharo 4 it is the NB version, right? > > Yes. > >> I guess both version has the same public interface. > > Yes, but. :-) Some bits of NBSQLite3, no

Re: [Pharo-users] SQLite + Pharo

2016-07-09 Thread Pierce Ng
On Wed, Jul 06, 2016 at 11:24:51AM +0200, Hilaire wrote: > I guess UDBC is for Pharo 5, and for Pharo 4 it is the NB version, right? Yes. > I guess both version has the same public interface. Yes, but. :-) Some bits of NBSQLite3, notably the online backup API but possibly other small stuff, isn'

Re: [Pharo-users] SQLite + Pharo

2016-07-07 Thread Esteban A. Maringolo
2016-07-06 6:24 GMT-03:00 Hilaire : > Thanks Esteban, > > I guess UDBC is for Pharo 5, and for Pharo 4 it is the NB version, right? Right. > I guess both version has the same public interface. There might be a small difference in the API, because it seems more people is using the UDBC version ra

Re: [Pharo-users] SQLite + Pharo

2016-07-06 Thread Hilaire
Thanks Esteban, I guess UDBC is for Pharo 5, and for Pharo 4 it is the NB version, right? I guess both version has the same public interface. Hilaire Le 30/06/2016 20:02, Esteban A. Maringolo a écrit : > Hilaire, > > If you want to generate the SQL statements by hand you can use the > UDBC S

Re: [Pharo-users] SQLite + Pharo

2016-07-06 Thread Hilaire
Thanks Esteban, I guess UDBC is for Pharo 5, and for Pharo 4 it is the NB version, right? I guess both version has the same public interface. Hilaire Le 30/06/2016 20:02, Esteban A. Maringolo a écrit : > If you want to generate the SQL statements by hand you can use the > UDBC SQLite3 driver,

Re: [Pharo-users] SQLite + Pharo

2016-06-30 Thread Esteban A. Maringolo
Hilaire, If you want to generate the SQL statements by hand you can use the UDBC SQLite3 driver, or if you want o use an ORM you can use Glorp. See: http://forum.world.st/ANN-Glorp-SQLite3-for-Pharo-5-td4899277.html#a4899303 Regards! Esteban A. Maringolo 2016-06-30 14:53 GMT-03:00 Hilaire : >

[Pharo-users] SQLite + Pharo

2016-06-30 Thread Hilaire
Hello, How do you guys use Sqlite with Pharo, for example to update an object from sql table and vis versa ? Do you use any middle man to do so? Thanks for the tips. Hilaire -- Dr. Geo http://drgeo.eu