Small Database Needed

**Istvan Albert** · Jul 18 '05, 05:57 PM

Re: Small Database Needed

Kevin McBrearty wrote:
[color=blue]
> I'm looking at implementing DB in my program for
> analysis of CAD (STL Files). This database will
> require the basic functionality.[/color]

PySQLite to the rescue:

404 Not Found

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

Istvan.

**Tim Rønning** · Jul 18 '05, 05:57 PM

Re: Small Database Needed

Gadfly!

rgds
Tim R.

På Sun, 21 Nov 2004 06:54:40 -0800 (PST), skrev Kevin McBrearty
<kmcbrearty@yah oo.com>:
[color=blue]
> 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[/color]

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

**Dan Perl** · Jul 18 '05, 05:58 PM

Re: Small Database Needed

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

"Kevin McBrearty" <kmcbrearty@yah oo.com> wrote in message
news:mailman.66 69.1101048884.5 135.python-list@python.org ...[color=blue]
> 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
>
>[/color]

**Dan Perl** · Jul 18 '05, 05:58 PM

Re: Small Database Needed

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.1086704144.6949.python-list%40python.org&rnum=8&prev=/groups%3Fq%3Dmetakit%26hl%3Den%26lr%3D%26group%3Dcomp.lang.python.*%26c2coff%3D1%26scoring%3Dd%26selm%3Dmailman.711.1086704144.6949.python-list%2540python.org%26rnum%3D8

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

http://groups.google.com/groups?hl=en&lr=&c2coff=1&threadm=mailman.255.1073698893.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

"Dan Perl" <danperl@rogers .com> wrote in message
news:m7-dnTCpSK1MqDzcRV n-sA@rogers.com.. .[color=blue]
>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
>
> "Kevin McBrearty" <kmcbrearty@yah oo.com> wrote in message
> news:mailman.66 69.1101048884.5 135.python-list@python.org ...[color=green]
>> 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
>>
>>[/color]
>
>[/color]

**Robert** · Jul 18 '05, 05:58 PM

Re: Small Database Needed

Istvan Albert <ialbert@mailbl ocks.com> wrote in message news:<U-ydnTSaW_NELT3cR Vn-hA@giganews.com >...[color=blue]
> Kevin McBrearty wrote:
>[color=green]
> > I'm looking at implementing DB in my program for
> > analysis of CAD (STL Files). This database will
> > require the basic functionality.[/color]
>
> PySQLite to the rescue:
>
> http://pysqlite.sourceforge.net/manual.html
>
> Istvan.[/color]

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** · Jul 18 '05, 05:58 PM

Re: Small Database Needed

In article <FsydnTHKM5qLpz zcRVn-uA@rogers.com>,
"Dan Perl" <danperl@rogers .com> wrote:
[color=blue]
> 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=e...an.711.1086704
> 144.6949.python-list%40python.o rg&rnum=8&prev =/groups%3Fq%3Dme takit%26hl%3Den %
> 26lr%3D%26group %3Dcomp.lang.py thon.*%26c2coff %3D1%26scoring% 3Dd%26selm%3Dma ilm
> an.711.10867041 44.6949.python-list%2540python .org%26rnum%3D8
>
> http://groups.google.com/groups?hl=e...9CE.503%40zora
> n.com&rnum=16&p rev=/groups%3Fq%3Dme takit%26start%3 D10%26hl%3Den%2 6lr%3D%26grou
> p%3Dcomp.lang.p ython.*%26c2cof f%3D1%26scoring %3Dd%26selm%3D4 05109CE.503%254 0zo
> ran.com%26rnum% 3D16
>
> http://groups.google.com/groups?hl=e...an.255.1073698
> 893.12720.pytho n-list%40python.o rg&rnum=26&prev =/groups%3Fq%3Dme takit%26start%
> 3D20%26hl%3Den% 26lr%3D%26group %3Dcomp.lang.py thon.*%26c2coff %3D1%26scoring% 3Dd
> %26selm%3Dmailm an.255.10736988 93.12720.python-list%2540python .org%26rnum%3D2 6
>
> Hope this helps and my apologies for the long formatted links.
>
> Dan[/color]

Meet a couple of helpful friends:

shorl.com

http://shorl.com/

http://tinyurl.com/

I hope this helps!

-M

--
Michael J. Fromberger | Lecturer, Dept. of Computer Science
http://www.dartmouth.edu/~sting/ | Dartmouth College, Hanover, NH, USA

**Dan Perl** · Jul 18 '05, 05:58 PM

Re: Small Database Needed

"Michael J. Fromberger" <Michael.J.From berger@Clothing .Dartmouth.EDU> wrote
in message news:Michael.J. Fromberger-95B81B.20470421 112004@localhos t...[color=blue]
> Meet a couple of helpful friends:
>
> http://shorl.com/
> http://tinyurl.com/
>
> I hope this helps![/color]

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

Dan

**William Park** · Jul 18 '05, 05:58 PM

Re: Small Database Needed

Kevin McBrearty <kmcbrearty@yah oo.com> wrote:[color=blue]
> 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.[/color]

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

--
William Park <opengeometry@y ahoo.ca>
Linux solution for data management and processing.

**Michel Claveau - abstraction méta-galactique non t** · Jul 18 '05, 05:58 PM

Re: Small Database Needed

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** · Jul 18 '05, 05:59 PM

Re: Small Database Needed

Am Sun, 21 Nov 2004 06:54:40 -0800 schrieb Kevin McBrearty:
[color=blue]
> Hello All,
>
> I'm looking at implementing DB in my program for
> analysis of CAD (STL Files). This database will
> require the basic functionality.[/color]

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** · Jul 18 '05, 06:00 PM

Re: Small Database Needed

Dan Perl schreef:
[color=blue]
> Hope this helps and my apologies for the long formatted links.[/color]

They don't have to be _that_ long:

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

http://groups.google.com/groups?threadm=405109CE.503%40zoran.com

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

--
JanC

"Be strict when sending and tolerant when receiving."
RFC 1958 - Architectural Principles of the Internet - section 3.9

**Josiah Carlson** · Jul 18 '05, 06:04 PM

Re: Small Database Needed

"Michel Claveau - abstraction méta-galactique non triviale en fuite
perpétuelle." <unseulmcmcmcmc @msupprimerlepo int.claveauPOIN Tcom> wrote:[color=blue]
>
> 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 ?[/color]

(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** · Jul 18 '05, 06:04 PM

Re: Small Database Needed

"Tim Rønning" <tim.ronning@st art.no> wrote in message
news:opshtqgtnr 38clfj@buktu1.. .[color=blue]
> Gadfly![/color]

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

**Gerhard Haering** · Jul 18 '05, 06:04 PM

Re: Small Database Needed

On Thu, Nov 25, 2004 at 11:43:09AM +0100, Frithiof Andreas Jensen wrote:[color=blue]
> "Tim Rønning" <tim.ronning@st art.no> wrote:[color=green]
> > Gadfly![/color]
>
> GadFly - as far as I got with it - does not support SQL relational
> table constraints.[/color]

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)

iD8DBQFBpcLwdIO 4ozGCH14RAlsFAK CL9DGcPebXYbqqB WxjT7w2grFImgCg iG3i
QEXdHzhf+gJA/1897bbFG1o=
=oy5/
-----END PGP SIGNATURE-----

Small Database Needed

Small Database Needed

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment