Python database

[@(none)]

Facts:

(1) I don't know anything about data bases

(2) I don't have much time to learn about them (but I do have SOME time)

(3) I need to store (and retrieve) thousands of pages for a wiki, and
need to be able to perform simple searches in the data base (but nothing
else)

(4) I want to have open source free of charge programs

Can someone recommend a simple, easy-to-program data base? As far as I
have understood there is no standard data base in Python. Why is this
so? Do people have too different needs?

/ Any help is much appreciated!

[Leopold Schwinger]

Re: Python database

none wrote:[color=blue]
>
> Facts:
>
> (1) I don't know anything about data bases
>
> (2) I don't have much time to learn about them (but I do have SOME time)
>
> (3) I need to store (and retrieve) thousands of pages for a wiki, and
> need to be able to perform simple searches in the data base (but nothing
> else)
>
> (4) I want to have open source free of charge programs
>
> Can someone recommend a simple, easy-to-program data base? As far as I
> have understood there is no standard data base in Python. Why is this
> so? Do people have too different needs?
>
> / Any help is much appreciated!
>[/color]

If you want to make a Wiki-Page with full-text-search:
==> http://moin.sourceforge.net/
and: its based on python and Apache

greetings Leo

[@(none)]

Re: Python database

> If you want to make a Wiki-Page with full-text-search:[color=blue]
> ==> http://moin.sourceforge.net/
> and: its based on python and Apache[/color]

I've been checking that out already. It's not quite what I want. To be
honest, I want to reinvent the wheel :) I would like to make my own
wiki-clone (it's fun!) but I don't want to spend to much time with the
data base so I need something simple.

Maybe I'm too rude who is asking questions here without first reading
online manuals and tutorials in-depth. It's just that after like one
hour of browsing the web (and skimming Steve Holdens book) there doesn't
seem to be any clear winner. I would like something standard and I had
hoped that there would be a standard Python module which would help me,
but there is not, or so it seems to me.

/ Have a nice day!

[David M. Cooke]

Re: Python database

At some point, "@(none)" <""daniel\"@(no ne)"> wrote:
[color=blue]
> Facts:
>
> (1) I don't know anything about data bases
>
> (2) I don't have much time to learn about them (but I do have SOME time)
>
> (3) I need to store (and retrieve) thousands of pages for a wiki, and
> need to be able to perform simple searches in the data base (but
> nothing else)
>
> (4) I want to have open source free of charge programs[/color]

The original Wiki at http://c2.com/cgi/wiki uses the filesystem as
its database (see http://c2.com/cgi/wiki?MoreAboutTheDatabase).
You can get ideas by looking at what other people have done at

http://c2.com/cgi/wiki?WikiWikiClones

There's a small Wiki clone in Python at

http://sourcefrog.net/projects/piki/

which MoinMoin is based on. It's filesystem based also. I use a custom
version of this for my personal use.

You don't need much of a database. You can probably get away with
one-page-per-file, maybe with an external indexer (like Lupy?). Have a
look at the speed of the original wiki; a full-text search of 26738
pages takes a few seconds -- and it's a cgi script.
[color=blue]
> Can someone recommend a simple, easy-to-program data base? As far as I
> have understood there is no standard data base in Python. Why is this
> so? Do people have too different needs?[/color]

There are database modules in the standard Python distribution, just
not relational databases. Look at the anydbm, gdbm, and shelve
modules. Also look at the bsddb module, which is a wrapper around the
Berkeley DB library.

The TCL wiki (http://wiki.tcl.tk/) uses Metakit, which is another
non-relational database (although not included with Python), for which
there are Python wrappers.

--
|>|\/|<
/--------------------------------------------------------------------------\
|David M. Cooke
|cookedm(at)phy sics(dot)mcmast er(dot)ca

[BBands]

Re: Python database

"@(none)" <""daniel\"@(no ne)"> wrote in message news:<4050647e$ 1@puffinus.its. uu.se>...[color=blue]
> Can someone recommend a simple, easy-to-program data base? As far as I
> have understood there is no standard data base in Python. Why is this
> so? Do people have too different needs?
>
> / Any help is much appreciated![/color]


Simple and powerful:

SQLite

http://www.hwaci.com/sw/sqlite/

and a python driver for SQLite

http://sourceforge.net/projects/pysqlite

Enjoy,

--jab

[Miki Tebeka]

Re: Python database

Hello None,
[color=blue]
> Can someone recommend a simple, easy-to-program data base?[/color]
IIRC `metakit' is very simple to use.
[color=blue]
> As far as I have understood there is no standard data base in Python.
> Why is this so? Do people have too different needs?[/color]
I think the `anydbm' module is what you're looking for.

HTH.
Miki

[Miki Tebeka]

Re: Python database

Hello None,
[color=blue]
> Can someone recommend a simple, easy-to-program data base?[/color]
IIRC `metakit' is very simple to use.
[color=blue]
> As far as I have understood there is no standard data base in Python.
> Why is this so? Do people have too different needs?[/color]
I think the `anydbm' module is what you're looking for.

HTH.
Miki

[Miki Tebeka]

Re: Python database

Hello None,
[color=blue]
> Can someone recommend a simple, easy-to-program data base?[/color]
IIRC `metakit' is very simple to use.
[color=blue]
> As far as I have understood there is no standard data base in Python.
> Why is this so? Do people have too different needs?[/color]
I think the `anydbm' module is what you're looking for.

HTH.
Miki