Re: [Pharo-users] Garage and SQLite file databases, general project structure

2015-05-24 Thread Ben Coman
On Mon, May 18, 2015 at 4:48 PM, Guillermo Polito wrote: > I wanted in general to have a single easy-to-learn way to build a database > connection string for all drivers. > > [driverid]://[host][:port]/[databasename]?[properties] > > I bumped into an interesting app "SQL Workbench/J" [1] that l

Re: [Pharo-users] Garage and SQLite file databases, general project structure

2015-05-19 Thread Ben Coman
On Tue, May 19, 2015 at 10:49 PM, Sven Van Caekenberghe wrote: > > > I made the following commits: > This does not change the current default behaviour, but it makes it a lot > easier to work with relative references: > Cool. Now just a passing thought. The original term URL is from RFC1738, wh

Re: [Pharo-users] Garage and SQLite file databases, general project structure

2015-05-19 Thread Sven Van Caekenberghe
Ben, (comments inline) > On 18 May 2015, at 17:46, Ben Coman wrote: > > > > On Mon, May 18, 2015 at 7:06 PM, Sven Van Caekenberghe wrote: > > > On 18 May 2015, at 12:13, Guillermo Polito > > wrote: > > > > Hi Sven, I'll take that into account. I did not think about using an empty > > hos

Re: [Pharo-users] Garage and SQLite file databases, general project structure

2015-05-18 Thread Ben Coman
On Mon, May 18, 2015 at 7:06 PM, Sven Van Caekenberghe wrote: > > > On 18 May 2015, at 12:13, Guillermo Polito > wrote: > > > > Hi Sven, I'll take that into account. I did not think about using an > empty host/port pair, maybe because of the extra slash. > > > > Also, I do not need to convert th

Re: [Pharo-users] Garage and SQLite file databases, general project structure

2015-05-18 Thread Sven Van Caekenberghe
> On 18 May 2015, at 12:13, Guillermo Polito wrote: > > Hi Sven, I'll take that into account. I did not think about using an empty > host/port pair, maybe because of the extra slash. > > Also, I do not need to convert the file name to a file reference. That is > done in sqlite by the sqlite l

Re: [Pharo-users] Garage and SQLite file databases, general project structure

2015-05-18 Thread Guillermo Polito
Hi Sven, I'll take that into account. I did not think about using an empty host/port pair, maybe because of the extra slash. Also, I do not need to convert the file name to a file reference. That is done in sqlite by the sqlite library itself, so it's less work for the driver. The only need I need

Re: [Pharo-users] Garage and SQLite file databases, general project structure

2015-05-18 Thread Sven Van Caekenberghe
Hi Guile, > On 18 May 2015, at 10:48, Guillermo Polito wrote: > > Well, I wanted in general to have a single easy-to-learn way to build a > database connection string for all drivers. > > [driverid]://[host][:port]/[databasename]?[properties] > > Then, for sqlite I would like to have: > > sq

Re: [Pharo-users] Garage and SQLite file databases, general project structure

2015-05-18 Thread Guillermo Polito
Hi Pierce, El sáb., 16 de may. de 2015 a la(s) 10:52 a. m., Pierce Ng < pie...@samadhiweb.com> escribió: > On Tue, May 12, 2015 at 08:35:23PM +0200, Torsten Bergmann wrote: > > Also I do not understand: while "Garage-Postgres" uses the Postgres > > project PostgresV2 as a backend the "Garage-Sql

Re: [Pharo-users] Garage and SQLite file databases, general project structure

2015-05-18 Thread Guillermo Polito
Hi Torsten, Thanks for taking a look, I'll answer between lines :). El mar., 12 de may. de 2015 a la(s) 8:35 p. m., Torsten Bergmann < asta...@gmx.de> escribió: > Hi Guille, > > I had a short look at Garage [1]. Nice initiative! > > Looks like using a file is not supported for the SQLite3 backen

Re: [Pharo-users] Garage and SQLite file databases, general project structure

2015-05-16 Thread Pierce Ng
On Tue, May 12, 2015 at 08:35:23PM +0200, Torsten Bergmann wrote: > Also I do not understand: while "Garage-Postgres" uses the Postgres > project PostgresV2 as a backend the "Garage-Sqlite3" does not use > NBSqlite3 or SQlite3 projects as backend. > > So "GASqlite3FFI" copies many methods of the

[Pharo-users] Garage and SQLite file databases, general project structure

2015-05-12 Thread Torsten Bergmann
Hi Guille, I had a short look at Garage [1]. Nice initiative! Looks like using a file is not supported for the SQLite3 backend in Garage: GADriver fromConnectionString: 'sqlite3://file://C:/temp/test.db' GADriver fromConnectionString: 'sqlite3://C:/temp/test.db' Maybe GASqlite3Driver>>