Follow Slashdot stories on Twitter


Forgot your password?
Check out the new SourceForge HTML5 internet speed test! No Flash necessary and runs on all devices. ×

Comment Re:Dynamic Relational [Re: That's not how it works (Score 1) 213

Darwen and Date tend to be pedantic and don't focus on things shops actually care about. They spend far more time on chalkboards than in the field.

Plus, SQL, or a variant of it, can be adjusted to fit most of their complaints. That would be more practical than entirely throwing out an established standard and starting over again from scratch.

Again, I have gripes about SQL also, but something typically has to be significantly better to replace a standard, not merely somewhat better. And the SQL standard can be adjusted and expanded as new actual lessons are learned.

Comment Re: Dynamic Relational [Re: That's not how it work (Score 1) 213

Interesting. But they do seem like second-class citizens compared to "regular" columns in Maria-DB. It's extra syntax to use them. My approach would allow formality to be incrementally added without changing a column's "type" (mode?) from dynamic to static.

They also seem to require explicit type declarations. I prefer implied or WYSIWYG typing, a bit more like perl's typing model, even if it does complicate comparisons to some degree. (Different readers had diff opinions on how to handle dynamically-typed comparisons. I prefer a symbol next to the comparison operator, such as "#" for numeric: it's short and easy.)

Comment Re:Dynamic Relational [Re: That's not how it works (Score 1) 213

Sounds awfully like Prolog.

Not really. Prolog is mostly a query-like language; I'm not defining a language. SQL, or at least some variant of it, is good enough; no need for users to relearn the entire wheel.

(I've proposed an alternative to SQL, but it's probably not significantly better enough to dethrone the de-facto standard: SQL, for most uses. But that's a different topic.)

Comment Re:Dynamic Relational [Re: That's not how it works (Score 1) 213

Oh dear gods, you want dynamic schema because planning is hard and relational database normalization is too complicated for you. Nobody sees the value in your asinine idea because you're an idiot.

Sometimes planning is hard. I've been in many situations where the customer doesn't quite know what they want yet, and/or some trial-and-error is needed to settle on an optimum design. Think of it as a prototyping tool.

Have you memorized every domain and customer preference in the world?

Comment Re: Dynamic Relational [Re: That's not how it work (Score 1) 213

and there's no distinction between a missing column and one that didn't exist, how does hashing work?

Same way as before. I don't see that as a practical stumbling block, but maybe you have a specific use-case in mind that would muck things up?

Informal categorisation and structuring has its place, but that's an entirely different beast to a relational database.

Indeed with regard to informal structuring: something easy to get going is often useful for prototyping. One can then lock down this tool incrementally as things settle (or migrate to a static RDBMS).

I've been in rather long debates about the definition of "relational database", and found no clear-cut "failure" to match. Language is subject to interpretation.

Anyhow, the idea is to produce a useful tool. It's formal category or definition is secondary to being useful.

Comment Re:We love functional languages except using them. (Score 1) 184

Maybe with enough training and experience, one may be able to pull it off, but a future maintenance programmer may not be able to follow your technique well. It increases the hiring and training burden for your organization.

There are techniques that work better under ideal conditions, but ideal conditions are hard to come by.

Comment Re:That's not how it works... (Score 2) 213

I have to agree. You have to make it yourself. I've been trying to evangelize the idea of "dynamic relational" databases but nobody seems to see the value enough to care until they actually have something to try. You gotta make it first and THEN others will kick the tires to see if it piques their interest.

Slashdot Top Deals

Consider the postage stamp: its usefulness consists in the ability to stick to one thing till it gets there. -- Josh Billings