Tag Info

New answers tagged

0

To put it simply - it would work if only one of you were editing the database at a time. If both of you were to edit the database, it could corrupt the file, discard each other changes or cause sync issues. By the way, have you considered Google Docs?


0

No, as defined, a Blob is "a binary large object that can hold a variable amount of data." It can hold between 0 and 2^16 - 1 bytes (65535). A LONGBLOB can hold up to 4,294,967,295 bytes (or 4GB). In most engines, blobs are implemented dynamically, meaning that it will only take its actual size plus some extra bytes for lenght/addressing, etc. In fact, ...


0

Well, technically I'd solved the problem, although there's still question about weird sqliosim behavior. It appears that sqliosim do creates it's files in shared NAS folder (sqliosim.mdx, sqliosim.mdx) but for some reason I can't explain, it fails to resize files and aborts. Workaround: Create files before sqliosim run, with exactly the same size it ...


0

You should take a look at SciDB - a database designed for precisely this use case. It has as as its major driver Michael Stonebraker, a man who knows a lot about databases - it would be an exaggeration to say that he's been involved with more database systems than most people have had hot dinners, but not by much :-)! "including Ingres, Illustra, Cohera, ...


4

Your question reminds me of PostgreSQL. It has a feature called TOAST (The Outside Attribute Storage Technique). PostgreSQL features TOAST tables in the event the length of the row data is too small. I have discussed TOAST before in the DBA StackExchange May 01, 2012 : what is bigger than a longblob? Mar 21, 2012 : Are many NULL columns harmful in mysql ...



Top 50 recent answers are included