Best database

Postgresql   3 votes - 33 %
Microsoft SQL Server   0 votes - 0 %
Oracle   3 votes - 33 %
MySQL <- Wrong Answer   0 votes - 0 %
SQLLite <- ??   0 votes - 0 %
Microsoft Access <- Correct Answer   1 vote - 11 %
Foxpro   2 votes - 22 %
9 Total Votes
Nice essay. by ambrosen (2.00 / 0) #1 Wed May 03, 2006 at 02:25:35 AM EST
I'd say that as long as you don't use the table with the images in for much else, then you're right.

Enjoy, anyway.

I actually abstracted it by coryking (2.00 / 0) #5 Wed May 03, 2006 at 06:18:43 AM EST
To just be a "binary" table.  All it's got the data, the size, an MD5 hash and a reference to a "file type" table so I know what the hell is in there.  All the image stuff just keeps a pointer to the binary table.

Worst case is we get some programmer who likes to JOIN every god damn table in the database and then use SELECT *...

Dog food. Snack for some. Feast for others.

[ Parent ]
I'd use a different table per type of binary. by ambrosen (2.00 / 0) #6 Wed May 03, 2006 at 06:36:23 AM EST
Well, that's my instinct. I'm sure your design makes sense, though.

Sadly, I'm getting a headache thinking of the toy database that is used where I work, which it is not in my remit to change, despite its hideous inefficiency and painful data design. You missed FileMaker out of your poll, by the way.

[ Parent ]
binaries by coryking (2.00 / 0) #7 Wed May 03, 2006 at 08:07:06 AM EST
Just out of curiosity, why would you go with a table per binary type?

I did miss out on filemaker.  Never got the "pleasure" of working on it.

Dog food. Snack for some. Feast for others.

[ Parent ]
Assuming they're holding different things, by ambrosen (2.00 / 0) #9 Wed May 03, 2006 at 12:29:57 PM EST
I'd view them as helper tables for the table containing their metadata. If by type you're talking about file formats, then definitely in one table.

But I wouldn't take my advice, anyway.

Filemaker may well be better than Access, I don't know. But it's being used well into "You want a proper DB for that" territory here, and I have neither the credibility (because the original DB work I did was optimistically based around being able to do basic joins, programatically vary search parameters, programatically vary export files, etc.) nor the desire to migrate, nor to refactor. Not at minimum wage, anyway. I'll stick to packing books. I get less ire from the original dyslexic designer of the database that way, too.

[ Parent ]
maybe this is naive, by rmg (2.00 / 0) #2 Wed May 03, 2006 at 04:01:12 AM EST
but it sounds like it's basically a middle of the road content management system/store. perhaps a full-fledged database is overkill. for example, i run my blog on bloxsom, which is basically just a perl script and some flat text files for data storage. it might sound primitive, but it works well, it's fast, and it's easy to hack. it even stayed up when i got slashdotted a couple months ago.

obviously, if you're writing banking software or some kind of genome sequencer, mysql or some similar database is the way to go, but for content management, i think databases are more trouble than they're worth. it's just endless little things and poor full text search performance.

or maybe you could compromise. i hear good things about berkeleyDB...

[t]rolling retards conversation, period.

Good Suggestion, by coryking (4.00 / 1) #3 Wed May 03, 2006 at 06:11:43 AM EST
We looked at BerkeleyDB in planning stage of our project.  Unfortunately our managers are requiring that we run on Linux and not Microsoft Windows NT, the native platform of BerkelyDB.  In addition BerkeleyDB has an incompatible "license" with Linux's "GPL license" that would prevent us from making a port.  Worse, since Linux does not support threading or OLOG(N) transactional safety, our only choice was Postgres.

But thanks for the suggestion anyway.

Dog food. Snack for some. Feast for others.

[ Parent ]
This isn't K5, woman. by MohammedNiyalSayeed (4.00 / 1) #4 Wed May 03, 2006 at 06:12:42 AM EST

Try harder.

You can build the most elegant fountain in the world, but eventually a winged rat will be using it as a drinking bowl.
[ Parent ]
Heheh by kwsNI (2.00 / 0) #8 Wed May 03, 2006 at 08:39:32 AM EST
Pet the cat?  Install Gallery2? Vacation?  Life?  Friends?  Family?  Sorry.  I have to ship first.

I thought you'd like my find of the day. by ambrosen (2.00 / 0) #10 Thu May 04, 2006 at 05:08:02 AM EST
From some site telling you what to do if your SQL's bollixed:
MS Access is characterized by strong data typing;
So near, yet so far.