PunQlite problems

On 06 Sep 2016, at 00:37, PBKResearch <[hidden email]> wrote:

Hi – just tried a further experiment, with more mysterious results. I created a database in memory with a subset of my data. This time the program will retrieve the values as well as the keys. However, the value presented is just the first 1024 bytes, i.e. the first buffer full. In addition, in the majority of cases the correct bytes are each followed by three zero bytes, e.g. the data begins:

3C 00 00 00 68 00 00 00

74 00 00 00 6D 00 00 00

6C 00 00 00 20 00 00 00

63 00 00 00 6C 00 00 00

Rather than the expected:

3C 68 74 6D 6C 20 63 6C.

This affects 75 of the 88 cases in my trial database.

 

I presume the insertion of the zero bytes took place in the writing stage, but I have no idea what is going on. Are there any known problems with PunQLite on pharo 5?

 

 

 

Hello

 

I am using Moose 6.0 (Pharo 5.0 Latest update: #50761) on Windows 10. I have installed PunQLite following the instructions in https://github.com/mumez/PunQLite. I have run all the examples that involve using files, and everything seems OK. I have tried creating a database using my own data, which seemed to run OK. The database will display its keys successfully, but whenever I try to retrieve a value I get PqFetchError. The debug information shows that an ffi fetch operation has given a return value of -10. I have searched for any information on unQLite return codes, but so far I have nothing.

 

I tried the PqDatabaseBrowser in the Tools section. This recognised the database, opened it and displayed all the keys correctly. However, clicking on any key gave the same PqFetchError.

 

Does anyone have any idea of what I have done wrong?

 

Thanks for any help.

 

Peter Kenny

On 06 Sep 2016, at 12:42, PBKResearch <[hidden email]> wrote:

Hi Esteban

 

Well, I tried re-installing from your repo, but now I cannot even run the tests in the mumez repo. Whatever I try, I get an error message

in trying to open the database, saying I cannot get a pointer to a byte array.

 

Previously, my Monticello browser said I was using PunQLite-Core(TorstenBergmann.28); now it shows the version as Estebanlorenzano.17. I don’t understand the naming and numbering, but surely the version number shouldn’t go backwards?

 

Should I give upon PunQLite, and maybe try Voyage-UnqLite instead? Basically all I need is a database that looks like a large dictionary, with rather lengthy entries (mainly in XML).

 

Thanks.

 

Peter Kenny

 

 

From: Pharo-users [[hidden email]] On Behalf Of Esteban Lorenzano
Sent: 06 September 2016 10:21
To: Any question about pharo is welcome <[hidden email]>
Subject: Re: [Pharo-users] PunQlite problems

 

Hi, 

 

most probably not related to the problem, but the currently maintained (for us) PunQLite is now here: https://github.com/pharo-nosql/PunQLite

 

and correct way to install it is: 

 

Metacello new 

    repository: '<a href="github://pharo-nosql/PunQLite/repository'" style="color: purple; text-decoration: underline;" class="">github://pharo-nosql/PunQLite/repository';

    baseline: 'PunQLite';

    load.

 

… even if it is basically the same (and we submit changes to mumez repository too), this is the correct place for us :)

 

cheers, 

Esteban

 

On 06 Sep 2016, at 00:37, PBKResearch <[hidden email]> wrote:

 

Hi – just tried a further experiment, with more mysterious results. I created a database in memory with a subset of my data. This time the program will retrieve the values as well as the keys. However, the value presented is just the first 1024 bytes, i.e. the first buffer full. In addition, in the majority of cases the correct bytes are each followed by three zero bytes, e.g. the data begins:

3C 00 00 00 68 00 00 00

74 00 00 00 6D 00 00 00

6C 00 00 00 20 00 00 00

63 00 00 00 6C 00 00 00

Rather than the expected:

3C 68 74 6D 6C 20 63 6C.

This affects 75 of the 88 cases in my trial database.

 

I presume the insertion of the zero bytes took place in the writing stage, but I have no idea what is going on. Are there any known problems with PunQLite on pharo 5?

 

 

 

Hello

 

I am using Moose 6.0 (Pharo 5.0 Latest update: #50761) on Windows 10. I have installed PunQLite following the instructions in https://github.com/mumez/PunQLite. I have run all the examples that involve using files, and everything seems OK. I have tried creating a database using my own data, which seemed to run OK. The database will display its keys successfully, but whenever I try to retrieve a value I get PqFetchError. The debug information shows that an ffi fetch operation has given a return value of -10. I have searched for any information on unQLite return codes, but so far I have nothing.

 

I tried the PqDatabaseBrowser in the Tools section. This recognised the database, opened it and displayed all the keys correctly. However, clicking on any key gave the same PqFetchError.

 

Does anyone have any idea of what I have done wrong?

 

Thanks for any help.

 

Peter Kenny