WikidPad and SQLite

[maristaran]

Hi everyone,

I've started working on making WikidPad work with a SQLite database
instead of Gadfly. Fortunatetly both Gadfly and SQLite respect Python
DBApi guidelines, so it wasn't too hard.

So far, the switch seems to improve speed noticeably; specially on
startup.

If anyone is interested I can make a diff out my changes and post it
here.

Cheers,

--
Manuel Aristarán
http://jazzido.freezope.org/jazzido
Buenos Aires, Argentina

[Thierry Lalinne]

Manuel,

How cool !
I'm very interested in your diff.

Cheers,

-
Thierry Lalinne
Brussels, Belgium

[Andrey Nikanorov]

I do it, week ago. And work on Unicode now. :)

On 7/8/05, maristaran <maris...@gmail.com> wrote:
>

--
Nikanorov Andrey <nika...@gmail.com>
http://nikanorov.com
This email is: [ ] blogable [ x ] ask first [ ] private

[maristaran]

Andrey,

As far as I know, pysqlite stores content as Unicode objects. I'm
having some trouble with that.

How did you convert the Gadfly DB to SQLite? Did you do some kind of
conversion?

Regards,

[Andrey Nikanorov]

Yes, main problem is in wxPython (unicode, WikiTxtCtrl). To port
wikiPad to sqlite i take pysqlite (from track:
http://initd.org/tracker/pysqlite) & of course fix some
"introspective" queries.

Don't forget to store wiki files as unicode too.

On 7/8/05, maristaran <maris...@gmail.com> wrote:
>

[maristaran]

Andrey,

Are the sources of your modification available? I want to develop to a
full patch for wikidPad, and I'd like to view what others did.

Just for the record, It seems there's another programmer using sqlite
in wikidPad: http://www.mbutscher.nextdesigns.net/wikidpadCompact/

Cheers,