Database vs Data Structure?

castironpi at gmail.com castironpi at gmail.com
Fri Apr 18 06:30:33 CEST 2008


On Apr 17, 9:30 pm, erikcw <erikwickst... at gmail.com> wrote:
> Hi,
>
> I'm working on a web application where each user will be creating
> several "projects" in there account, each with 1,000-50,000 objects.
> Each object will consist of a unique name, an id, and some meta data.
>
> The number of objects will grow and shrink as the user works with
> their project.
>
> I'm trying to decided whether to store the objects in the database
> (each object gets it's own row) or to use some sort of data-structure
> (maybe nested dictionaries or a custom class) and store the pickled
> data-structure in a single row in the database (then unpickle the data
> and query in memory).
>
> A few requirements:
> -Fast/scalable (web app)
> -able to query objects based on name and id.
> -will play nicely with versioning (undo/redo)
>
> Any input on the best way to go?
>
> Thanks!
> Erik

When you change an object, what will you do?

1) Changes on disk only.
2) Changes in memory only & flush.

Databases cache a binary in memory, which I find underrated.



More information about the Python-list mailing list