Data storage?

wxPython Users
1

Hi,

I'm in planning stages of a program which will need to store filenames
found on the CD that is in the drive. I'd like some opinions of what
would be a good means of storing the data. I've already considered some
kind of SQL database although MySQL, PostgreSQL etc. would definitely be
an overkill for this app because it is intended for use by end users on
single PC's. The data must be searchable.

Regards,
Wayne

2

SQLite is very nice... I haven't use it from Python, but works great from C ( http://www.sqlite.org/ )

/Ronald Jaramillo

···

On Monday, July 28, 2003, at 01:46 PM, Wayne Koorts wrote:

Hi,

I'm in planning stages of a program which will need to store filenames
found on the CD that is in the drive. I'd like some opinions of what
would be a good means of storing the data. I've already considered some
kind of SQL database although MySQL, PostgreSQL etc. would definitely be
an overkill for this app because it is intended for use by end users on
single PC's. The data must be searchable.

Regards,
Wayne

---------------------------------------------------------------------
To unsubscribe, e-mail: wxPython-users-unsubscribe@lists.wxwindows.org
For additional commands, e-mail: wxPython-users-help@lists.wxwindows.org

3

SQLite is very nice... I haven't use it from Python, but works great
from C ( http://www.sqlite.org/ )

/Ronald Jaramillo

> Hi,
>
> I'm in planning stages of a program which will need to store filenames
> found on the CD that is in the drive. I'd like some opinions of what
> would be a good means of storing the data. I've already considered
> some
> kind of SQL database although MySQL, PostgreSQL etc. would definitely
> be
> an overkill for this app because it is intended for use by end users
> on
> single PC's. The data must be searchable.
>
> Regards,
> Wayne

It works very well with Python and wxPython using PySQLite. See:

Regards,

David Hughes
Forestfield Software Ltd
www.forestfield.co.uk

···

On Monday, July 28, 2003, at 01:46 PM, Wayne Koorts wrote:

4

hth
Tertius

···

----- Original Message -----
From: "Wayne Koorts" <waynek@hotpop.com>
To: "wxPython" <wxpython-users@lists.wxwindows.org>
Sent: Monday, July 28, 2003 1:46 PM
Subject: [wxPython-users] Data storage?

Hi,

I'm in planning stages of a program which will need to store filenames
found on the CD that is in the drive. I'd like some opinions of what
would be a good means of storing the data. I've already considered some
kind of SQL database although MySQL, PostgreSQL etc. would definitely be
an overkill for this app because it is intended for use by end users on
single PC's. The data must be searchable.

Regards,
Wayne

---------------------------------------------------------------------
To unsubscribe, e-mail: wxPython-users-unsubscribe@lists.wxwindows.org
For additional commands, e-mail: wxPython-users-help@lists.wxwindows.org

5

I'm in planning stages of a program which will need to store filenames
found on the CD that is in the drive. I'd like some opinions of what
would be a good means of storing the data. I've already considered some
kind of SQL database although MySQL, PostgreSQL etc. would definitely be
an overkill for this app because it is intended for use by end users on
single PC's. The data must be searchable.

I'm using Metakit and find it very easy and lightweight. It doesn't have an
SQL interface - just database and view objects.

www.equi4.com

-Rick King

6

Wayne Koorts kirjutas E, 28.07.2003 kell 14:46:

Hi,

I'm in planning stages of a program which will need to store filenames
found on the CD that is in the drive. I'd like some opinions of what
would be a good means of storing the data.

You could check out ZODB (Zope Object DataBase) see
http://zodb.sourceforge.net/

···

I've already considered some
kind of SQL database although MySQL, PostgreSQL etc. would definitely be
an overkill for this app because it is intended for use by end users on
single PC's. The data must be searchable.

Regards,
Wayne

---------------------------------------------------------------------
To unsubscribe, e-mail: wxPython-users-unsubscribe@lists.wxwindows.org
For additional commands, e-mail: wxPython-users-help@lists.wxwindows.org

7

Thanks for all the suggestions guys :slight_smile:

I'll check out all the links you provided.

Regards,
Wayne

Hannu Krosing wrote:

···

Wayne Koorts kirjutas E, 28.07.2003 kell 14:46:

Hi,

I'm in planning stages of a program which will need to store filenames
found on the CD that is in the drive. I'd like some opinions of what
would be a good means of storing the data.
   
You could check out ZODB (Zope Object DataBase) see
http://zodb.sourceforge.net/

I've already considered some
kind of SQL database although MySQL, PostgreSQL etc. would definitely be
an overkill for this app because it is intended for use by end users on
single PC's. The data must be searchable.

Regards,
Wayne

---------------------------------------------------------------------
To unsubscribe, e-mail: wxPython-users-unsubscribe@lists.wxwindows.org
For additional commands, e-mail: wxPython-users-help@lists.wxwindows.org
   
---------------------------------------------------------------------
To unsubscribe, e-mail: wxPython-users-unsubscribe@lists.wxwindows.org
For additional commands, e-mail: wxPython-users-help@lists.wxwindows.org

8

Rick King wrote:

I'm in planning stages of a program which will need to store filenames
found on the CD that is in the drive. I'd like some opinions of what
would be a good means of storing the data. I've already considered some
kind of SQL database although MySQL, PostgreSQL etc. would definitely be
an overkill for this app because it is intended for use by end users on
single PC's. The data must be searchable.

I'm using Metakit and find it very easy and lightweight. It doesn't have an
SQL interface - just database and view objects.

Not true:

http://www.mcmillan-inc.com/mksqlintro.html

Is a very nice sql wrapper for metakit, although in general you can do the searches in raw metakit. I have had no complaints with metakit, it pretty much rocks. A bit of an initial learning curve however.

Brian

9

This might interest you, I have used wxGrid to wrap metakit databases. It comes bundled with some useful features. Take a look at the bottom for KitViewer

http://staffa.wi.mit.edu/people/kelley/

Brian

10

I'm glad to hear someone else is using Metakit because I share your opinion
of it.

···

Not true:

HOAX.COM: unravelling the truth from fiction, past to present...

Is a very nice sql wrapper for metakit, although in general you can do
the searches in raw metakit. I have had no complaints with metakit, it
pretty much rocks. A bit of an initial learning curve however.

Brian