Pardon the self-promotion, but you can find DBI-Link at http://pgfoundry.org/projects/dbi-link/ and on EPEL for RHEL/CentOS. Oh, and it's not restricted to MySQL. You can use any DBD with a certain minimal feature set, and I'm trying to reduce that minimum.
I agree 100%. It's not a coincidence that some of the worst bad actors of the current junta were staffers in the Nixon white house. Nor is it a coincidence that a lot of them were involved in Iran/Contra on the way to their current misdeeds.
Rule of law has to be for everybody, not just those without the power to adjust the judicial process to their taste.
> > You mean the magic Darwen/Date/Pascal relational model? The one nobody has > > managed to implement despite the 25 years it's been around?
> Ahh yes, the old canard. Actually, several companies and individuals have > implemented the relational model MUCH more faithfully than the typical SQL > vendor.
Name one, and make sure it's one that's disallowed NULLs completely. Date, Darwen and Pascal's fear of recording states of ignorance is ill-founded in real-world conditions. Codifying that fear isn't even well-founded in last century's mathematical theory. Yes, it's true that multi-value logics are just a teensy tad more complicated theoretically than 2VL. That does not imply that they're less useful, or that the systems built around them are more complicated than the truly wackily byzantine things D, D & P suggest as workarounds for not having NULLs.
> The problem is not one of difficulty, but rather of popularity and > marketing.
Nope. See below.
> In fact, several solo-developer projects have implemented it on the logical > level much better than your typical SQL vendor. The problem is that those > guys don't have a) the marketing budget and 20 years of industry buy-in, and > b) the developer team to implement all the "enterprisey" features like > clustering, failover, etc...
> And by the way, there is nothing about the "true relational model" that > makes those things harder to implement.
That it's been 25 years and nobody has implemented it, despite resources in industry, government, academia and open source, flatly contradicts your assertion.
> They are if anything LESS difficult to implement with a true relational DBMS > than with an SQL DBMS, which has to handle all kinds of oddities like > duplicate rows, position-dependent syntax, pointers, and many other > nonsensical rules of SQL.
> I know lots of you database pros out there hate to hear from guys like > Date,Darwen and co.
Nonsense. It's not that we don't like to hear from theoreticians. It's that we don't want to hear from doctrinaire ideologues like D, D & P, especially when they have only "angels dancing on the head of a pin" to show for their side. One theoretican whose stuff is actually worth reading is Leonid Libkin . There are plenty of others.
> but the thing is they are right: the DBMS world has opted for mediocrity and > over-complexity.
You know, this is really dumb prima facie. Something that you need to have a 130 IQ and a math degree to use even at the most basic level is something that's pretty fragile. A *really* well-designed tool is one that a person who's not very bright can pick up and use, while not muzzling the expression of somebody who is bright and has lots of experience. SQL qualifies.
> Of course, that's the way it is with most things in life:(.
You mean the magic Darwen/Date/Pascal relational model? The one nobody has managed to implement despite the 25 years it's been around?
Maybe it's because the thing can't be made to work, and its limitations (i.e. being equivalent to first-order logic, a limitation not in SQL DBMSs) make it silly even to keep trying.
> You mean legalie meth, coke, heroin, crack? That will never happen. > Nor should it... I doubt we want any more crackheads around.
You are stating that legalization would increase these numbers. Could you provide some evidence, based, for example, on legalization programs in other countries, where this has actually happened?
> Legalize weed? It may happen in our lifetime, but I'm sure the DEA > spends vast amounts more on cocaine interdiction than weed.
The old saying goes, "It ain't what you don't know that kills ya. It's what you know that ain't so." This is a perfect example. Well over 80% of 'drug war' money is spent on cannabis.
which helps do the job by making data sources easily available, one to the other. Of course, it's not done yet, but it's a long way in the right direction:)
I hope that "INSERT" is a typo, because it's just plain wrong. The only thing that needs vacuuming is dead tuples, and the only operations that create dead tuples are UPDATEs and DELETEs. Furthermore, pg_autovacuum has been integrated into the back-end since 8.0.
I don't believe so, but please feel free to exercise what you imagine are your Second Amendment rights. Maybe you'll get off with life in prison, but I doubt it.
Constitutional rights only protect you from government -- private property rights trump constitutional ones.
And that's why you can hang a sign that says, "No Kikes, Niggers, Chinks or Faggots Allowed" on your store. Oh, wait a second. You can't.
Who's been giving out the insane idea that property somehow raises you above every rule in society? Small hint here: "property" is shorthand for "a set of rights and obligations between you and the rest of your society, mediated through objects."
It's a moot point anyway, everyone knows a database is only a persistence layer and frameworks like Hibernate are going to do away with developers ever needing to know how or what database is used. Knowing nothing about the systems you connect to always results in better software.
I really hope that's sarcasm. While it's possible to do as you describe above, it doesn't scale in any direction: size, performance, or maintainability.
Aspergers isn't an illness -- it's a neurodevelopmental disorder on the autism spectrum. It's also not "shortcomings" to be designed to do things differently than most people.
According to experts on autism Baron-Cohen, Atwood, and Wing, people identifying as being on the autism spectrum are accurate 99% of the time, because the internal characteristics are so striking. They can include severe sensory sensitivity, extreme motor clumsiness, weak or lacking depth perception, difficulty speaking (often with loss of speech under stress), extreme difficulty changing from one task to the other even if we want to, native use of different (autistic) body language that is incompatible with that of non-autistics, having multiple senses report one sense's information (like seeing colors for sounds)...
Speaking as somebody who's spent a fair amount of time with Bram in person, watched him juggle skillfully and heard him carry on quite coherent conversations while maintaining eye contact, I assure you that he has none of the afore-mentioned characteristics. I hate to knock you off your favorite hobby horse, but allegations about Bram's alleged autism-spectrum disorders just plain don't hold any water.
Really? Postgres -- fully functional, powerful RDBMS that routinely competes with the Big Boys in terms of speed and features, but has a funky maintenance system (vacuum) and doesn't run natively on Windows.
Actually, autovacuum has been around for awhile, and the native Windows version of PostgreSQL started with 8.0:)
I know one thing for sure. People are very bad at figuring out their own motives in general, whether that's what they want, what they don't, what they're attracted to, what they're not... For a long time, philosophers have encouraged us to try. By doing so, they were recognizing the essential truth that this is somewhere between extremely difficult and impossible.
Not so. However, there is a limited degree to which you have influence over your rent, and for the similar reasons, only magnified, there is a limited degree to which you as an individual or even a less-than-majority group can have influence over your taxes. You must nevertheless choose either to pay the taxes (aka rent) or to suffer the consequences of not doing so in any given location.
If you really don't like taxes, move to a place like Somalia where they don't have any. Any argument against taxes is also an argument against rent. You live in a place, you pay the fees. End of story.
According to the FAQ, it's POST-gress-cue-ell.
Other pronunciations include "POST-gress," "Pee GEE," "POST-gress-equal" and "Oracle Killer."
Some people get really annoyed when you try for any of the pronunciations of "Postgre" because it reminds them of an ogre-like creature spouting bits of postmodern gibberish.
Slashdot Mirror
Better still, install DBI-Link http://pgfoundry.org/projects/dbi-link/ inside PostgreSQL, migrate once and have done ;)
> Surely reducing the minimal feature-set isn't a step forward?
:)
DBI-Link adds on the ability to access external data sources for read and write. It doesn't reduce any of PostgreSQL's capabilities
Pardon the self-promotion, but you can find DBI-Link at http://pgfoundry.org/projects/dbi-link/ and on EPEL for RHEL/CentOS. Oh, and it's not restricted to MySQL. You can use any DBD with a certain minimal feature set, and I'm trying to reduce that minimum.
No more ironic than that slashdot runs on the .org TLD, which in turn runs atop PostgreSQL.
I agree 100%. It's not a coincidence that some of the worst bad actors of the current junta were staffers in the Nixon white house. Nor is it a coincidence that a lot of them were involved in Iran/Contra on the way to their current misdeeds.
Rule of law has to be for everybody, not just those without the power to adjust the judicial process to their taste.
> > You mean the magic Darwen/Date/Pascal relational model? The one nobody has
:(.
> > managed to implement despite the 25 years it's been around?
> Ahh yes, the old canard. Actually, several companies and individuals have
> implemented the relational model MUCH more faithfully than the typical SQL
> vendor.
Name one, and make sure it's one that's disallowed NULLs completely. Date,
Darwen and Pascal's fear of recording states of ignorance is ill-founded in
real-world conditions. Codifying that fear isn't even well-founded in last
century's mathematical theory. Yes, it's true that multi-value logics are
just a teensy tad more complicated theoretically than 2VL. That does
not imply that they're less useful, or that the systems built around
them are more complicated than the truly wackily byzantine things D, D & P
suggest as workarounds for not having NULLs.
> The problem is not one of difficulty, but rather of popularity and
> marketing.
Nope. See below.
> In fact, several solo-developer projects have implemented it on the logical
> level much better than your typical SQL vendor. The problem is that those
> guys don't have a) the marketing budget and 20 years of industry buy-in, and
> b) the developer team to implement all the "enterprisey" features like
> clustering, failover, etc...
> And by the way, there is nothing about the "true relational model" that
> makes those things harder to implement.
That it's been 25 years and nobody has implemented it, despite
resources in industry, government, academia and open source, flatly
contradicts your assertion.
> They are if anything LESS difficult to implement with a true relational DBMS
> than with an SQL DBMS, which has to handle all kinds of oddities like
> duplicate rows, position-dependent syntax, pointers, and many other
> nonsensical rules of SQL.
> I know lots of you database pros out there hate to hear from guys like
> Date,Darwen and co.
Nonsense. It's not that we don't like to hear from theoreticians. It's that
we don't want to hear from doctrinaire ideologues like D, D & P, especially
when they have only "angels dancing on the head of a pin" to show for their
side. One theoretican whose stuff is actually worth reading is Leonid Libkin
. There are plenty of others.
> but the thing is they are right: the DBMS world has opted for mediocrity and
> over-complexity.
You know, this is really dumb prima facie. Something that you need to
have a 130 IQ and a math degree to use even at the most basic level is
something that's pretty fragile. A *really* well-designed tool is one that a
person who's not very bright can pick up and use, while not muzzling the
expression of somebody who is bright and has lots of experience. SQL
qualifies.
> Of course, that's the way it is with most things in life
Oh, puh-lease!
You mean the magic Darwen/Date/Pascal relational model? The one nobody has managed to implement despite the 25 years it's been around?
Maybe it's because the thing can't be made to work, and its limitations (i.e. being equivalent to first-order logic, a limitation not in SQL DBMSs) make it silly even to keep trying.
Quis custodiet ipsos custodes?
See subject. :P
> You mean legalie meth, coke, heroin, crack? That will never happen.
> Nor should it... I doubt we want any more crackheads around.
You are stating that legalization would increase these numbers. Could
you provide some evidence, based, for example, on legalization
programs in other countries, where this has actually happened?
> Legalize weed? It may happen in our lifetime, but I'm sure the DEA
> spends vast amounts more on cocaine interdiction than weed.
The old saying goes, "It ain't what you don't know that kills ya.
It's what you know that ain't so." This is a perfect example. Well
over 80% of 'drug war' money is spent on cannabis.
I've written a thing called DBI-Link http://pgfoundry.org/projects/dbi-link/
:)
which helps do the job by making data sources easily available, one to the other. Of course, it's not done yet, but it's a long way in the right direction
Just one teensy little problem with "strict mode:" any client can turn it off! Somebody is unclear on the concept of Codd's 12th rule.
Failure to turn on the appropriate automatic vacuuming is a case of "written wrong."
I'm really sorry that your app is written wrong, but that's not a problem with PostgreSQL.
I hope that "INSERT" is a typo, because it's just plain wrong. The only thing that needs vacuuming is dead tuples, and the only operations that create dead tuples are UPDATEs and DELETEs. Furthermore, pg_autovacuum has been integrated into the back-end since 8.0.
I don't believe so, but please feel free to exercise what you imagine are your Second Amendment rights. Maybe you'll get off with life in prison, but I doubt it.
And that's why you can hang a sign that says, "No Kikes, Niggers, Chinks or Faggots Allowed" on your store. Oh, wait a second. You can't.
Who's been giving out the insane idea that property somehow raises you above every rule in society? Small hint here: "property" is shorthand for "a set of rights and obligations between you and the rest of your society, mediated through objects."
Speaking as somebody who's spent a fair amount of time with Bram in person, watched him juggle skillfully and heard him carry on quite coherent conversations while maintaining eye contact, I assure you that he has none of the afore-mentioned characteristics. I hate to knock you off your favorite hobby horse, but allegations about Bram's alleged autism-spectrum disorders just plain don't hold any water.
Actually, autovacuum has been around for awhile, and the native Windows version of PostgreSQL started with 8.0
I know one thing for sure. People are very bad at figuring out their own motives in general, whether that's what they want, what they don't, what they're attracted to, what they're not... For a long time, philosophers have encouraged us to try. By doing so, they were recognizing the essential truth that this is somewhere between extremely difficult and impossible.
Not so. However, there is a limited degree to which you have influence over your rent, and for the similar reasons, only magnified, there is a limited degree to which you as an individual or even a less-than-majority group can have influence over your taxes. You must nevertheless choose either to pay the taxes (aka rent) or to suffer the consequences of not doing so in any given location.
If you really don't like taxes, move to a place like Somalia where they don't have any. Any argument against taxes is also an argument against rent. You live in a place, you pay the fees. End of story.
According to the FAQ, it's POST-gress-cue-ell. Other pronunciations include "POST-gress," "Pee GEE," "POST-gress-equal" and "Oracle Killer." Some people get really annoyed when you try for any of the pronunciations of "Postgre" because it reminds them of an ogre-like creature spouting bits of postmodern gibberish.
Must. Resist. Joke. About. Last Tango in Paris.