Small Database Needed

[Kevin McBrearty]

Hello All,

I'm looking at implementing DB in my program for
analysis of CAD (STL Files). This database will
require the basic functionality.

Query
Sort
Delete/Add Records


I did some looking at the DB packages out there. But,
I'm not interseted in setuping up some huge thing. It
would be great if it is fast, but I can live with a
sub-optimal solution for the present. My interest is
in getting it up and running.

Since, I'm new to Python so please don't hold back on
the comments.

Regards,
Kevin



__________________________________
Do you Yahoo!?
Meet the all-new My Yahoo! - Try it today!
http://my.yahoo.com

 

[Istvan Albert]

I'm looking at implementing DB in my program for
analysis of CAD (STL Files). This database will
require the basic functionality.

PySQLite to the rescue:

http://pysqlite.sourceforge.net/manual.html

Istvan.

 

[=?iso-8859-1?Q?Tim_R=F8nning?=]

Gadfly!

rgds
Tim R.

På Sun, 21 Nov 2004 06:54:40 -0800 (PST), skrev Kevin McBrearty

Hello All,

I'm looking at implementing DB in my program for
analysis of CAD (STL Files). This database will
require the basic functionality.

Query
Sort
Delete/Add Records


I did some looking at the DB packages out there. But,
I'm not interseted in setuping up some huge thing. It
would be great if it is fast, but I can live with a
sub-optimal solution for the present. My interest is
in getting it up and running.

Since, I'm new to Python so please don't hold back on
the comments.

Regards,
Kevin

Using Opera's revolutionary e-mail client: http://www.opera.com/m2/

 

[Dan Perl]

I haven't used it myself, but at some point when I was looking for a
database I thought this was a very interesting alternative:
http://www.equi4.com/metakit.html. Eventually, I chose to forego databases
and just pickle a data structure. Take a look at it and maybe it will suit
you. On the other hand, I would like to hear any opinions from people who
have used it, I may decide to use it myself someday.

Dan

 

[Dan Perl]

Considering some recent discussions in this newsgroup about doing a search
before asking questions, I realized I may just have been guilty of that
myself. So I did a search, even though it was after posting that previous
message. I found a few recent threads that are relevant also for the OP's
question:
http://groups.google.com/groups?hl=...86704144.6949.python-list%40python.org&rnum=8

http://groups.google.com/groups?hl=...oring=d&selm=405109CE.503%40zoran.com&rnum=16

http://groups.google.com/groups?hl=...698893.12720.python-list%40python.org&rnum=26

Hope this helps and my apologies for the long formatted links.

Dan

 

[Robert]

PySQLite to the rescue:

http://pysqlite.sourceforge.net/manual.html

Istvan.

SQLite is very nice.

Another embedded one that you could look at it Metakit
(http://www.equi4.com/metakit.html). It also has very good Python
support. It is not an "SQL" type database though. It is easy to use
though.

Robert

 

[Michael J. Fromberger]

Considering some recent discussions in this newsgroup about doing a search
before asking questions, I realized I may just have been guilty of that
myself. So I did a search, even though it was after posting that previous
message. I found a few recent threads that are relevant also for the OP's
question:
http://groups.google.com/groups?hl=en&lr=&c2coff=1&threadm=mailman.711.1086704
144.6949.python-list%40python.org&rnum=8&prev=/groups%3Fq%3Dmetakit%26hl%3Den%
26lr%3D%26group%3Dcomp.lang.python.*%26c2coff%3D1%26scoring%3Dd%26selm%3Dmailm
an.711.1086704144.6949.python-list%2540python.org%26rnum%3D8

http://groups.google.com/groups?hl=en&lr=&c2coff=1&threadm=405109CE.503@zora
n.com&rnum=16&prev=/groups%3Fq%3Dmetakit%26start%3D10%26hl%3Den%26lr%3D%26grou
p%3Dcomp.lang.python.*%26c2coff%3D1%26scoring%3Dd%26selm%3D405109CE.503%2540zo
ran.com%26rnum%3D16

http://groups.google.com/groups?hl=en&lr=&c2coff=1&threadm=mailman.255.1073698
893.12720.python-list%40python.org&rnum=26&prev=/groups%3Fq%3Dmetakit%26start%
3D20%26hl%3Den%26lr%3D%26group%3Dcomp.lang.python.*%26c2coff%3D1%26scoring%3Dd
%26selm%3Dmailman.255.1073698893.12720.python-list%2540python.org%26rnum%3D26

Hope this helps and my apologies for the long formatted links.

Dan

Meet a couple of helpful friends:

http://shorl.com/
http://tinyurl.com/

I hope this helps!

-M

 

[Dan Perl]

Meet a couple of helpful friends:

http://shorl.com/
http://tinyurl.com/

I hope this helps!

Thanks! Never felt the need for tools like that before, but with 3 long
URLs they come in real handy!

Dan

 

[William Park]

Hello All,

I'm looking at implementing DB in my program for analysis of CAD (STL
Files). This database will require the basic functionality.

Query
Sort
Delete/Add Records

I did some looking at the DB packages out there. But, I'm not
interseted in setuping up some huge thing. It would be great if it is
fast, but I can live with a sub-optimal solution for the present. My
interest is in getting it up and running.

Since, I'm new to Python so please don't hold back on the comments.

In the order preference,
- ASCII text file
- GDBM (but, you can't sort)
- SQLite
all of which are supported by Bash shell and Python.

 

[Michel Claveau - abstraction méta-galactique non t]

Hi !

MetaKit doc :

Iadaptive integer (becomes Python int)
L64-bit integer (becomes Python long)
FC float (becomes Python float)
DC double (is a Python float)
SC null terminated string (becomes Python string)
BC array of bytes (becomes Python string)

no date or datetime ?

 

[Thomas Guettler]

Am Sun, 21 Nov 2004 06:54:40 -0800 schrieb Kevin McBrearty:

Hello All,

I'm looking at implementing DB in my program for
analysis of CAD (STL Files). This database will
require the basic functionality.

Hi,

I like ZODB. It is an object database for python.
It has the advantage, that you only need to know
one language: python. You don't need SQL.

The drawback: You can search in the database
with a loop over all objects, or you develop
yourself a small catalog which maps values
of attributes to a list (or btree) of objects.

If ZODB is too big for you (tgz is 1 MB), you might
try durus.

HTH,
Thomas

 

[JanC]

Dan Perl schreef:

Hope this helps and my apologies for the long formatted links.

They don't have to be _that_ long:

http://groups.google.com/groups?threadm=mailman.711.1086704144.6949.python-list@python.org

http://groups.google.com/[email protected]

http://groups.google.com/groups?threadm=mailman.255.1073698893.12720.python-list@python.org

 

[Josiah Carlson]

"Michel Claveau - abstraction méta-galactique non triviale en fuite

Hi !

MetaKit doc :

Iadaptive integer (becomes Python int)
L64-bit integer (becomes Python long)
FC float (becomes Python float)
DC double (is a Python float)
SC null terminated string (becomes Python string)
BC array of bytes (becomes Python string)

no date or datetime ?

(pardon if someone already posted the equivalent, I'm going through 900
messages because I've been not reading the list for 5 days)

Use a float and time.time(), then you don't need to convert back and
forth between date/datetime strings/objects. If you ever need to get a
string formatted time, there is always time.asctime().

- Josiah

 

[Frithiof Andreas Jensen]

Gadfly!

GadFly - as far as I got with it - does not support SQL relational table
constraints.

 

[Gerhard Haering]

GadFly - as far as I got with it - does not support SQL relational
table constraints.

SQLite does not enforce referential integrity either. But both Gadfly
and (py)sqlite support transactions, so it's not a show-stopper.

-- Gerhard

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFBpcLwdIO4ozGCH14RAlsFAKCL9DGcPebXYbqqBWxjT7w2grFImgCgiG3i
QEXdHzhf+gJA/1897bbFG1o=
=oy5/
-----END PGP SIGNATURE-----