Please create an account to participate in the Slashdot moderation system

 



Forgot your password?
typodupeerror
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 work (Score 1) 201

https://mariadb.com/kb/en/mariadb/dynamic-columns/

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) 201

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) 201

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) 201

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) 143

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) 201

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.

Comment Re:Why does this come as a surprise? (Score 1) 471

Meanwhile we have a "recovery" that's not actually a recovery but a bubble fueled by low interest rates and the Fed printing more and more money.

I see no evidence of "money printing". Inflation has been sub-par. Perhaps we should try it.

Automation and the Internet seem to be the main culprit of job loss. The economy can make and ship more stuff, but there are no consumers to buy it because their jobs shrank. Printing money may fill in the new capacity. We have sluggish inflation because the GDP, at least potential GDP, is growing faster than the money supply.

Slashdot Top Deals

Only through hard work and perseverance can one truly suffer.

Working...