Do not store files in a database.
Everyone, without exception, that can run any RDBMS on the market already has a database specifically for storing files, and the RDBMS itself is using it! That database is the filesystem.
No filehandes to files in the database. With the exception of PostgreSQL...
Ever try to refer back to an old comment conversation only to find that someone had deleted all their replies leaving you talking to yourself?
Now imagine that in chat, where conversations might go on for hours or days...
And yes, there are plenty of people who would do this, either out of fear...
For the odd exceptions, just ask a room owner to move the message(s) to trash, or ask a moderator to delete (for a good reason). Or just don't post messages you regret later.
@EvanCarroll I guess what I'm saying is, with rights to delete ANY data, I always come from the point of view of "What conditions should mean that the user should be given that right"
Not the point of view of "Why doesn't the user already have that right?"
So I guess it's more to do with the DBA background than anything
but no it's not necessarily an is-ought problem. Again, it's just an observation.
I'm not stating how something should or shouldn't be. Just how I see it currently, based on how I understand the society around these concepts
Clearly we're not yet in the position of sending the employees of StackExchange to reducation camps. Hopefully some day, but I agree -- we're not there... YET.
That doesn't mean in any meaningful sense they ought to "own" anything.
If I was born with 10 hundred gazillion dollars I ought to have no right in the ideas, and management of the world. Thought clearly I would. Hopefully you can see the connection.
I think there's a subtle distinction between having no right, and no automatic seat at the table of decision making. The latter, I agree with partially. If I buy something, I have and should have a say of what happens with that thing.
@EvanCarroll shrug sorry you view me that way. I don't.
@EvanCarroll Then again we barely know eachother - perhaps making broad strokes about another persons beliefs made based on brief conversations in chat isn't a particularly accurate method for observing political views?
I'm just saying you're delegating moral judgement to people that have capital, because they have capital. That's problematic. It's not the most problematic thing, but it's certainly an issue. We agree that's the way it is now. We agree the government, in the USA (but not in Europe), has declared our identities, contributions, and privacy things corporations can "own" in perpetuity.
I don't acknowledge that form of ownership as valid.
I think the moral thing to do would be to round up all of the admins of Stack Exchange and to reopen a re-education camp in Siberia and send them to go build me a rail road, somewhere.
@EvanCarroll I've got a meeting now. At any rate Evan you're sure of your morals and political views, which I respect. I just don't agree with all of them (note - that shouldn't be read that I disagree with all of them either). And yes I do. again, most of the time. The world is complex and rules don't always work for every scenario.
I'm looking into using Query Notifications as a light(er) weight way of identifying when data in a table changes. I know they use Service Broker, and (although I have difficulty explaining exactly why) they do look like they'd be preferable to something like CDC or Triggers.
Query Notifications ...
That may have a lot to do with me just having experience knowing where to look to find SQL Problems.
@JackDouglas Do you have some sites you go to pretty regularly for reading up on Oracle articles? I'd love to have some on my list like I currently have SQL Performance and a fews others.
PostgreSQL is the best for documentation -- nothing is even remotely close in the RDBMS world. Oracle is damn good, their docs are usually exceptional. The indexing for their docs is hilariously bad. I've seen some docs Oracle has put out on things that absolutely nothing to do with Oracle, and they're the best docs on the net.
But when it comes to searching for anything Oracle touches, I have to dig through sometimes 3 pages of marketing wank and badly labeled stuff to find what I'm looking for as a developer.
Just searching for resources provided in an answer to an Oracle question, I see that there seems to be two distinct things "Oracle Streams", and "Oracle Stream Class" I'm fairly certain they have nothing to do with themselves, and trying to find clarification on that brings up 100 pages of brochures and release notes about Oracle none of which are technical
I was doing some work with the ELF spec and I was kind of floored that some of the best documentation on a spec about an executable format would be hosted by a company that has nothing to do with it. It's just a relic from the Sun days. docs.oracle.com/cd/E19683-01/816-1386/index.html
I wonder if that's actually the confusion here, maybe Sun was just exceptional with documentation and everytime I read something with the Oracle logo it was written by a Sun developer a decade ago, and they just keep it around.
@EvanCarroll Haven't really had much opportunity to work with that. Most everywhere I've been has been mostly using SQL Server, Oracle, some ancient sybase, and once a place tried to dabble in MySQL but that was the pits.
It's been something that's peaked my interest for a while. My last gig they were pretty content to keep doing Mirroring in tandum with replication when we could have really benefited from having a Primary/BCP/ReadOnly kind of set up.
