Hi! I need a very simple DB in Zope, a table with 5 columns, less than 100 entries, to write, read and update, nothing else. Is Gadfly a serious option? Do l loose my database if Zope is restarted? Which other option, easy to use? A tutorial? Many thinks in advance. Cheers, Alan -- Alan Wilter S. da Silva, D.Sc. - Research Associate Department of Biochemistry, University of Cambridge. 80 Tennis Court Road, Cambridge CB2 1GA, UK.
En/na Alan ha escrit:
Hi!
I need a very simple DB in Zope, a table with 5 columns, less than 100 entries, to write, read and update, nothing else. Is Gadfly a serious option? Do l loose my database if Zope is restarted? Which other option, easy to use? A tutorial?
Take a look at PropertyTools: http://iungo.org/products/PropertyTools HTH
Alan wrote:
I need a very simple DB in Zope, a table with 5 columns, less than 100 entries, to write, read and update, nothing else. Is Gadfly a serious option? Do l loose my database if Zope is restarted? Which other option, easy to use? A tutorial?
Don't use Gadfly. I'd probably just do this with a Folder full of File objects (storing the columns as properties on the File objects) and a ZCatalog to give you the searching. Otherwise, just hook up MySQL or Postgres and away you go... Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk
Alan wrote:
Hi!
I need a very simple DB in Zope, a table with 5 columns, less than 100 entries, to write, read and update, nothing else. Is Gadfly a serious option? Do l loose my database if Zope is restarted? Which other option, easy to use? A tutorial?
If it's going to be that small I suggest you write your own Zope product. Skip ZClasses. If you know what it is, take my word for it. If you don't, just forget it :) Gadly is not a serious option. If you're going for SQL you should go for something more real like Postgresql (powerful) or Mysql (trendy) etc.
Many thinks in advance.
Cheers, Alan
-- Peter Bengtsson, work www.fry-it.com home www.peterbe.com hobby www.issuetrackerproduct.com
At Tuesday 25/7/2006 14:02, Peter Bengtsson wrote: I need a very simple DB in Zope, a table with 5 columns, less than 100
entries, to write, read and update, nothing else. Is Gadfly a serious option? Do l loose my database if Zope is restarted? Which other option, easy to use? A tutorial? Gadly is not a serious option. If you're going for SQL you should go for something more real like Postgresql (powerful) or Mysql (trendy) etc.
Another option could be SQLite: SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine. http://www.sqlite.org/ Gabriel Genellina Softlab SRL __________________________________________________ Pregunt�. Respond�. Descubr�. Todo lo que quer�as saber, y lo que ni imaginabas, est� en Yahoo! Respuestas (Beta). �Probalo ya! http://www.yahoo.com.ar/respuestas
On Tue, Jul 25, 2006 at 05:10:26PM -0300, Gabriel Genellina wrote:
At Tuesday 25/7/2006 14:02, Peter Bengtsson wrote:
I need a very simple DB in Zope, a table with 5 columns, less than 100
entries, to write, read and update, nothing else. Is Gadfly a serious option? Do l loose my database if Zope is restarted? Which other option, easy to use? A tutorial? Gadly is not a serious option. If you're going for SQL you should go for something more real like Postgresql (powerful) or Mysql (trendy) etc.
Another option could be SQLite: SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine. http://www.sqlite.org/
Probably fine for this job. ZSqliteDA works fine, I used it for some testing recently. (side note: don't use sqlite as a testing-only stand-in for whatever database you actually deploy to. I tried that, it's a dead end IMO. Sooner or later you will run up against feature or syntax differences.) -- Paul Winkler http://www.slinkp.com
Alan wrote at 2006-7-24 19:06 +0100:
I need a very simple DB in Zope, a table with 5 columns, less than 100 entries, to write, read and update, nothing else.
Is Gadfly a serious option?
I would not use it. When I tried it (a long time ago) the version that came with Zope had serious problems (among others, it was not thread safe).
Do l loose my database if Zope is restarted?
No.
Which other option, easy to use? A tutorial?
Maybe, "TinyTable[Plus]" is an option for you? -- Dieter
participants (7)
-
Alan -
Alexis Roda -
Chris Withers -
Dieter Maurer -
Gabriel Genellina -
Paul Winkler -
Peter Bengtsson