File DB instead of real database?

[Jia Lu]

Hello all

I donot want to use a real DB like MySQL ... But I need something to
save about more than 1000 articles.
Is there any good ways?

Thanx

Jia Lu

[Paul McNett]

Jia Lu wrote:

I donot want to use a real DB like MySQL ... But I need something to
save about more than 1000 articles.
Is there any good ways?

(in Python 2.5):

#-- begin
import sqlite3.dbapi2 as sqlite

con = sqlite.connect("path/to/new/filename.db")
cur = con.cursor()
cur.executescript("""
create table articles (id integer primary key autoincrement,
name text,
content clob);
create index articles_name on articles (name);

insert into articles (name, clob)
values ("My new article", "Article text. blah blah");

""")

con.commit()

#-- end

--
pkm ~ http://paulmcnett.com

[Richard Jones]

Jia Lu wrote:

I donot want to use a real DB like MySQL ... But I need something to
save about more than 1000 articles.
Is there any good ways?

import anydbm
Richard

[fumanchu]

On Apr 13, 9:14 pm, "Jia Lu" <[e-mail]:

I do not want to use a real DB like MySQL ...
But I need something to save about more than
1000 articles. Is there any good ways?

The latest version of Dejavu includes a filesystem backend. See
"Folders" at http://projects.amor.org/docs/dejavu...age.html#other
Robert Brewer
System Architect
Amor Ministries
fu******@amor.org

[Pierre Quentel]

On 14 avr, 06:14, "Jia Lu" <[e-mail]:

Hello all

I donot want to use a real DB like MySQL ... But I need something to
save about more than 1000 articles.
Is there any good ways?

Hi,

For small sets of data PyDbLite is a good alternative to full-blown db
engines

>>import PyDbLite
db = PyDbLite.Base("records").create('title','artist')
db.insert('Ok Computer','Radiohead')

0

>>db.insert('Night On Earth','Rialto')

1

>>db.insert('Employment','Kaiser Chiefs')

2

>>print [ r['title'] for r in db ]

['Ok Computer', 'Night On Earth', 'Employment']

>>print [ r['artist'] for r in db if r['artist'].startswith('R') ]

['Radiohead', 'Rialto']

>>>

The syntax is intuitive for Python programmers (list comprehensions) ;
it's a single, small Python module downloable at
http://quentel.pierre.free.fr/PyDbLite/index.html

Regards,
Pierre

[Bruno Desthuilliers]

Jia Lu a e'crit :

Hello all

I donot want to use a real DB like MySQL ...

Whether MySQL is qualifies as a "real DB" is still an open question. But
you can use SQLite, which is an embedded SQL database.

[Sebastian Bassi]

On 13 Apr 2007 21:14:36 -0700, Jia Lu <Ro*****@gmail.comwrote:

I donot want to use a real DB like MySQL ... But I need something to
save about more than 1000 articles.
Is there any good ways?

SQLite is a good option, as you were told. But what about put them in
a dictionary and then cPickle it to disk? (using 2 as optimization
setting in cPickle command).