Torsten has given me the answer on how to install the new SQLite bridge
for UFFI (with the proper disclaimer about being work in progress ;-) ).
Gofer it
smalltalkhubUser: 'TorstenBergmann' project: 'UDBC';
configuration;
load.
(Smalltalk at: #ConfigurationOfUDBC) loadBleedingEdge
Cheers,
Offray
On 13/04/16 08:33, Offray Vladimir Luna Cárdenas wrote:
Thanks Mariano,
So my suspicion was right and I was managing improperly the SQLite
connections and not making a explicit closing of them. I could improve
the code, but I can't find the package which provides SQLiteConnection
(on pharo 4 it was NBSQLite). How can I find/install it?
Cheers,
Offray
On 12/04/16 20:03, Mariano Martinez Peck wrote:
What looks not related to memory issue is that the crash seems to
happen in #close:
Smalltalk stack dump:
0xffc655d4 SqliteLibrary>close: 0x9726108: a(n) SqliteLibrary
0xffc655f4 SQLiteConnection>close 0xc672d08: a(n) SQLiteConnection
0xffc65610 SQLiteConnection>finalize 0xc672d08: a(n) SQLiteConnection
0xffc65630 WeakFinalizerItem>finalizeValues 0xc692b60: a(n)
WeakFinalizerItem
The idea is obvious...and I did exactly the same for SqueakDBX (now
OpenDBXDriver / Garage).... register the connections into the
WeakRegistry so that they are automatically closed without having the
user to manually do so. I remember I had a case where the user WAS
already doing an explicit close and I would crash very much like this
case when I was trying to close a connection that was already closed.
I don't have Sqlite library handy, but could it be something similar?
On Tue, Apr 12, 2016 at 9:49 PM, Offray Vladimir Luna Cárdenas
<offray.l...@mutabit.com> wrote:
Hi,
On 12/04/16 16:51, Stephan Eggermont wrote:
On 12/04/16 22:44, Offray Vladimir Luna Cárdenas wrote:
I'm working with visualizations a external dataset which
contains 270k
records. So the best strategy seems to bridge pharo with
SQLite to keep
requirements low while using Roassal to visualize
aggregated information
that is obtained from querying the database.
It won't fit in image?
I tried with RTTabTable and NeoCVS but they can not load the
data. I made a test drawing 150k points and the image starts to
lag and trying to query the data becomes inefficient compared to
query the data on SQLite. For the moment I'll export the query
results to CVS, but I'll hope to have the SQLite bridge working soon.
Offray
--
Mariano
http://marianopeck.wordpress.com
