Re: searching for a nice database

From: javamad (dontwantnospam_at_nospam.com)
Date: 03/17/04

  • Next message: javamad: "Re: newbie JDBC SP exec"
    Date: Wed, 17 Mar 2004 11:39:28 GMT
    
    

    > It is an option although it does not meet all my wishes I have.
    > It is not object oriented in the sense that I cannot directly store
    > objects in the database.

    You could serialize the objects and then save them as blobs within a MySQL
    database. a LONGBLOB, for example can cope with 4294967295 characters (2^32
    - 1).

    Just remember that serialized objects belong to the class that they were
    created with. So if you modify the class and re-compile, this is classed
    (internally) as a different class and your previously serialized objects
    will be unreadable!

    Hope this helps.

    Fabricio


  • Next message: javamad: "Re: newbie JDBC SP exec"

    Relevant Pages

    • Re: [PHP] Writing my own web based user forum
      ... Since it seems you are using a database there is no need to serialize. ... In your original post you did not mention a "picture upload site" so I ... I am looking at writing my own web based user forum somewhat for my own ...
      (php.general)
    • Re: Whats a good database for a really simple app?
      ... you could also create the stuff as a object database and just serialize ... > if it's on disk at startup, create it if not, and serialize it as the ... > anyone needing even a two user app, but for a single user app it ...
      (microsoft.public.dotnet.languages.vb)
    • Serialization/Compression
      ... envisaged that we are going to run out of database space if more users start ... approach is when the user modifies the data. ... If the user has edited the data i will have to find out which chunk he ... serialize and compress only that portion of the data. ...
      (microsoft.public.dotnet.general)
    • Re: Serialization/Compression
      ... We are developing an application that allows users to take a snapshot of the some database tables and save them another set set of tables and work with them. ... To solve this problem i suggetsed to split the records that go into the model tables in chunks of say 5000,binary serialize the data, compress it and store the compressed form of the data in a blob field in the database. ... If the user has edited the data i will have to find out which chunk he has modified, serialize and compress only that portion of the data. ... I don't want to serialize all the chunks of data if the user just modifies only one chunk of the data. ...
      (microsoft.public.dotnet.general)
    • Re: Big database: many SQL tables vs. object serialization
      ... Alessandro Ranellucci wrote: ... Thus each page view requires many SQL queries and/or joins. ... > getting a very PHP-specific database or limiting retrival to IDs. ... But if you're going to serialize the object, why keep it in a database ...
      (comp.lang.php)