[ANN] Glorp-SQLite3 for Pharo 5

Hi all,

I'm pleased to announce the release of Glorp-SQLite3 for Pharo 5.

Written and tested on 64-bit Linux Mint 17. You'll need to place the 32-bit
libsqlite3.so where your Pharo 5 VM can find it.

Take a fresh Pharo 5 image. Run the following:

    Gofer it  
        smalltalkhubUser: 'TorstenBergmann' project: 'UDBC';
        configuration;
        load.
        (Smalltalk at: #ConfigurationOfUDBC) loadBleedingEdge.
   
    Gofer it
        smalltalkhubUser: 'DBXTalk' project: 'Garage';
        configurationOf: 'GarageGlorp';
        load.
        #ConfigurationOfGarageGlorp asClass project stableVersion load.
   
    Gofer it
        smalltalkhubUser: 'DBXTalk' project: 'Glorp';
        package: 'Glorp-SQLite3';
        load.
   
    GlorpSQLite3CIConfiguration new configureSqlite3.
    GlorpDemoTablePopulatorResource invalidateSetup.

Then run the Glorp tests in TestRunner. You should get 889 passing tests, with
12 tests skipped. The database file is sodbxtestu.db in your image directory.

Feedback welcome.

Pierce

tested on windows 7 with sqlite 32 bit and test run. with sqlite 64 bit pharo 5 crash running test.

2016-06-05 18:29 GMT-03:00 francescoagati <[hidden email]>:
> tested on windows 7 with sqlite 32 bit and test run. with sqlite 64 bit pharo
> 5 crash running test.

I think the crash might have to do with the 64 bit library, Pharo
being 32 bit won't be able to bind it.

Regards!

Esteban A. Maringolo

yes with 32 bits is ok. i try to use this tutorial for pharo 4. but some references are changed.

http://lists.pharo.org/pipermail/pharo-users_lists.pharo.org/2015-January/015809.html

NBSQLite3DatabaseAccessor isn't present. i have substitute with DatabaseAccessor.
but i have this error unable to connect

The Glorp port Pierce is refering to, as well as its UDBC-SQLite3
library are meant to be used in Pharo 5.

The NB (for NativeBoost) are Pharo 4 things.

Regards!
Esteban A. Maringolo


2016-06-05 19:38 GMT-03:00 francescoagati <[hidden email]>:

On Sun, Jun 05, 2016 at 03:38:17PM -0700, francescoagati wrote:
> NBSQLite3DatabaseAccessor isn't present. i have substitute with
> DatabaseAccessor.
> but i have this error unable to connect

Try this:

  | login accessor |
  login := Login new
    database: UDBCSQLite3Platform new;
    host: SmalltalkImage current imagePath asFileReference parent fullName,
      FileSystem disk delimiter asString;
    port: '';
    username: '';
    password: '';
    databaseName: 'sodbxtestu.db';
    yourself.
  PharoDatabaseAccessor DefaultDriver: GlorpSQLite3Driver.
  accessor := PharoDatabaseAccessor forLogin: login.
  accessor login.
  (accessor executeSQLString: 'select * from sqlite_master') explore.
  accessor logout.
 

Pierce

sorry for late response. yes this work thanks :-)