Transaction management is not necessarily a prerequisite for "database" (DBMS). There is no cononical definition of "database" (DBMS).
Dr. E.F. Codd, a then IBM researcher, gave us both a canonical definition of RDBMS and rules explaining why transactional management is essential. Read it here.
Citing from the link, Rule 5: Comprehensive Data Sublanguage Rule: The database must support at least one clearly defined language that includes functionality for data definition, data manipulation, data integrity, and database transaction control. All commercial relational databases use forms of the standard SQL (Structured Query Language) as their supported comprehensive language.
MySQL is failed to be RDBMS. It still helps to manage data, somehow. But the way it pretends to be RDBMS is confusing many uneducated users and thus MySQL should be considered as a very bad phenomena in software industry.
Please define Slashdot's "class" of web application.
A lot of "write" operations changing the result returning by the same URL request (so caching is not a real help).
Few months ago I did the test comparing the overhead of Bugzilla when it's implemented with MySQL vs PostgreSQL (I have to choose between them for very weak hardware). PostgreSQL was keeping up much longer than MySQL on massive concurrent write-requests when increasing amount of concurrent users (actually concurrent test scripts) simultaniously publishing new bugs and new bug comments and changing bug status.
I wonder if Slashdot developers tried similar tests with their software between MySQL and PostgreSQL.
You know that most of end-users do not have any of your X11 software?
The fact is that Windows is sometimes the right tool for the job...
The problem of both Linux and Macosx is that Windows is the right tool for the job for 99% of end-user tasks.
Apple understands it and attempts to fix it as hard as possible. If Linux developers won't understand and fix it than there is no chance for Linux on desktops of end-users. Actually I am negatively surprized how big software player keep feeding their direct mono-competitor.
Hello, IBM! We heard a lot of your Linux support. How about Lotus for Linux? Don't you want to "help" to your "friend" Microsoft to loose more users?
Hello, Sun! You can do better with Star/Open Office in terms of usability, stability and compatibility!
Hello, HP! Can you repeat again why my HP scanner is not recognized by xSANE?
Hello, Adobe! You're so naive tha you really hope that Apple will sell more Macs in future with your software. Don't you have any hope for Photoshop/Illustrator/Premier on Linux?
I understand that opensource developers don't understand end-users. But I don't understand software giants.
The book is about MySQL. Slashdot is based on MySQL and it's way too slow. And now the comment about such fact is moderated as "Offtopic"? That's not very nice. You can moderate it down and down, but you cannot hide the fact that the main reason that Slashdot is slow is b/c it's implemented with MySQL. That was a wrong technology choice for such class of web-applications as Slashdot is you cannot hide using your moderations.
PostgreSQL instead of MySQL is certainly a great improvement. But why stop on it? Python is much better than PHP as well. So, all we need is "Python and PostgreSQL" book. Or prehaps, "Zope and PostgreSQL". Any authors around there? Anyone to volunteer?
Slashdot is really slow today.
I guess two reasons:
it is the perfect illustration that MySQL is BAD for web based *write-intensive* applications. In future, use MySQL only for mostly-read applications.
There are lot's of PHP and MySQL fans yet, who heard that PHP and MySQL are great for web development, but didn't try yet. Well, they didn't try anything else yet. And it's sad that they will begin their web-dev experience with such primitive tools.
It's not a troll. I just disagree that the market is slashdotted by either primitive free tools or expensive commercial tools. Why only few people pay attention on a "middle-way", free but yet power tools, like Python and PostgreSQL? Or such people are so smart that they don't waste their time on Slashdot?
I don't like patriotism. Especially American one.
on
Superbowl XXXVII
·
· Score: 0, Flamebait
Being a patriotic means you like your country more than others. Being a patriot of America means you like your country so much that you are ready to bomb other countries without any serious reason.
Perhaps not all americans are ready to bomb all countries around the globe. But they share the responsibility with their goverment even if they voted against it on recently passed elections. That the nature of democracy, isn't it?
If americans cannot choose right president that means most of americans don't care about the rest of the world. And I don't like such people.
Re:Not to be a troll here but...
on
Superbowl XXXVII
·
· Score: 2, Insightful
Since Sept/11 Bush administration repeats: "If you are not with us then you are against us!".
So, if your country is not bombed yet - it's a matter of time and it will be. Just stay in the line and wait for your turn patiently.
I wonder, will USA recycle already bombed countries to the far end of the evil axis or there is another rule how to treat them?
I agree that 2 GB limit is obsolete today, especially for projects with large databases and with video editing tasks.
However, I would recommend to stay away from > 2GB files in database environment. Even if your FS supports large files, you still loose performance on "double-driver": first your kernel provedes a partition, than it provides a file-system over it. But if you need so big files, why would you need file-system? Just use row partitions!
Of course you still need large files for video, but massive concurrent preformance overhead is not a typical problem in such case.
You don't stop PostgreSQL server to run vacuum in 7.x versions - you can do it in background.
What you'll really missed in PostgreSQL for 24/7 is a good replication. But they are working on it.
By the way, are you sure you want 24/7/365? I think 24/7/52 will be more correct, no? I don't think that 7 years of uptime is a good idea when you want to upgrade your software (usually you stop/restart the service for it) about ever year.
That's the monster who goes after PostgreSQL and forces users to migrate to DB/2.
Sourceforge has been planning to migrate from MySQL to PostgreSQL and even re-wrote part of their software. Untill IBM came. Now it's powered by DB/2.
Under the pressure from IBM Red Hat has dropped PostgreSQL in a flaviour of DB/2, forgeiing that with RedHat Linux they selled PostgreSQL called RedHat Database for few years.
Several open-source projects' bugzilla repositories has been forced to move from PostgreSQL to DB/2.
IBM doesn't afraid Linux as they don't care what OS is installed on their x86 computers and they have the profit on RS6K more from hardware and applications than from AIX. But IBM is really scared by PostgreSQL as a competitor of DB/2. No wonder they use similar methods as Microsoft does being scared by Linux.
So, don't dance congratulating the win. Wait for the monster.
Once America dictates to the rest of the world that let it here at least some comments from the rest of the world.
Seriously, I think they should create a moderation system similar to what Slashdot has implemented here. So, no matter what is your citizenship - your Karma is what's important.
Let freedom of speech be independent from INS decisions!
Re:All this hype about XML
on
DTD vs. XML Schema
·
· Score: 3, Interesting
Great thing about XML, is if you need to convert your communications, you can write XSLT against it to convert it while you convert your XML source.. easily.
Great thing about Lisp, is if you need to convert your communications, you can write Lisp against it to convert it while you convert your Lisp source.. easily.
I plopped an XSLT processor in front of it. Took minutes to implement. In the mean time, I was able to properly rewrite the XML producing code. So I had some flexibility in terms of patching the protocol quickly, while taking the weeks I needed to fix things right.
I plopped a Lisp processor in front of it. Took minutes to implement. In the mean time, I was able to properly rewrite the Lisp producing code. So I had some flexibility in terms of patching the protocol quickly, while taking the weeks I needed to fix things right.
the point is, XML IS descriptive, so long as you use good names.
the point is, Lisp IS descriptive, so long as you use good names.
If you use XML to develop a lower level protocol you end up with bloated 10k messages.
If you use Lisp S-expressions to develop a lower level protocol you don't end up with bloated 10k messages.
Besides, in Common Lisp you'll really appreciate MOP - Meta-Object Protocol. Much better than SOAP.
Trust me, I know well, actively use and actually love both Lisp *AND* XML.
I think that Microsoft can prove that Java really doesn't have any future and that it was just a result of past internet buble, is to include, besides JVM, many other interpreters of other languages.
Who cares about JVM if Python, Perl and Tcl from Active State can run faster and more reliable being interpreted by a native code based interpreter?
Besides Python, Perl and Tcl, there are many good natively (means: safe and fast) working interpreters on Windows: Prolog, Lisp, Haskell, Erlang, Mozart, Mercury, Ruby, and dozens of others.
Why would I need a double interpretation, when the interpreter can work in native codes?
And why should I limit myself to Java centric development, when right language for the right job is much better approach?
By inlcuding other interpreters into Windows and making a good advertisement of it, Microsoft can prove that JVM is not the only choice developers have for cross-platform development.
No need to mention that many of cross platform interpreters are licensed allowing them for being distributed with Windows. I think many developers of those interpreters would be happy to push their software to PC market, especially when the giant is pushing.
Of course, Microsoft can try to bind interpreters to.NET, but that would not be a problem if it would be an option - use it if like it or ignore it.
P.S. I don't like Microsoft's monopoly, although it's the only example of a bad market behaviour - look what Apple is doing. I don't like Windows/NT/2k/XP architectural design, although it wasn't the worst case until now - MacOS-9 was much worse. But I don't like Java either (especially thoughtless decision of most of companies to use Java only b/c Java is hot term on the market) and I don't like what Sun is doing with Java. I am not sure what I dislike more - Microsoft/Windows or Sun/Java, but I like to have more choices in Windows OS, that's for sure.
First, this irritates me because we are talking about animals, not beings with souls (from Christian teaching).
That experiment just proves that Cristian teaching is wrong, or at least it is not complete. All living beings have their souls. Including cats and all other animals. You can ignore it, but ignorance doesn't help your own soul.
Second, and most important, you are saying that identical twins are in serious trouble, because only one of them has the soul, as the clone does not.
No, that post is saying that the clone received its own soul in a way as all we receive ours. It doesn't matter what way original emrion appeared - as a result of sex or of scientific experiment. It's got its own soul or it doesn't live.
The soul is not a bilogical substance, although it lives together with our bilogical bodies. For some period of time. The source of soul is from karma judgement of previous lives. That's why twins and clones has own absolutely independent souls. The similarity of their curent bilogical lives just gives them similar memories, which will disappear after this live anyway.
That's the problem of Christian teaching: it decare the soul existence but it doesn't explain the nature of soul.
If you are interesting in more details about the subject try to read articles on this site. Or, better, find a good teacher.
correction: the spammer will easily prove that s/he is so naive that doesn't know that the person behind email address is living in US.
In fact, many yahoo and hotmail users live outside of US (I do!). Many other doc-com/net/org people as well. No way to say where is the person's country based on the person's email address.
Unless the address is some@ISP.us - there is no way to prove that the spammer has intended to do the business with US residents. How many people in US use email address ending on dot-us?
So, what are you gonna do - move all americans to dot-us domain? Or you gonna protect only people with non-anonymous country-domain in their email addresses?
The only way to protect my house from uninvited people is to use the door. Perhaps with the dog. So, don't waste your time on dreaming to enforce your american laws in other countries - use e-certificates and filters.
Slashdot Mirror
Dr. E.F. Codd, a then IBM researcher, gave us both a canonical definition of RDBMS and rules explaining why transactional management is essential. Read it here.
Citing from the link, Rule 5: Comprehensive Data Sublanguage Rule: The database must support at least one clearly defined language that includes functionality for data definition, data manipulation, data integrity, and database transaction control. All commercial relational databases use forms of the standard SQL (Structured Query Language) as their supported comprehensive language.
MySQL is failed to be RDBMS. It still helps to manage data, somehow. But the way it pretends to be RDBMS is confusing many uneducated users and thus MySQL should be considered as a very bad phenomena in software industry.
Seriously, have you tried PHPpgAdmin?
Features include:
- create and drop databases
- create, copy, drop and alter tables/views/sequences/functions/indicies/trigger
s
- edit and add fields (to the extent Postgres allows)
- execute any SQL-statement, even batch-queries
- manage primary and unique keys
- create and read dumps of tables
- administer one single database
- administer multiple servers
- administer postgres users and groups
Requirements: PHP 3.x+ (4+ suggested), PostgreSQL 7+, PHP enabled web server, Web Browser that supports frames and Javascript.If you want to publish some good news here and it's under password - reprint it if you can do it legally or forget about it.
Otherwise your link is a free way to advertise the closed commercial source of information.
I am not sure, why Slashdot editors allow such free ads here? Or is NY-Times a hidden sponsor of Slashdot?
A lot of "write" operations changing the result returning by the same URL request (so caching is not a real help).
Few months ago I did the test comparing the overhead of Bugzilla when it's implemented with MySQL vs PostgreSQL (I have to choose between them for very weak hardware). PostgreSQL was keeping up much longer than MySQL on massive concurrent write-requests when increasing amount of concurrent users (actually concurrent test scripts) simultaniously publishing new bugs and new bug comments and changing bug status.
I wonder if Slashdot developers tried similar tests with their software between MySQL and PostgreSQL.
You know that most of end-users do not have any of your X11 software?
The fact is that Windows is sometimes the right tool for the job...
The problem of both Linux and Macosx is that Windows is the right tool for the job for 99% of end-user tasks.
Apple understands it and attempts to fix it as hard as possible. If Linux developers won't understand and fix it than there is no chance for Linux on desktops of end-users. Actually I am negatively surprized how big software player keep feeding their direct mono-competitor.
Hello, IBM! We heard a lot of your Linux support. How about Lotus for Linux? Don't you want to "help" to your "friend" Microsoft to loose more users?
Hello, Sun! You can do better with Star/Open Office in terms of usability, stability and compatibility!
Hello, HP! Can you repeat again why my HP scanner is not recognized by xSANE?
Hello, Adobe! You're so naive tha you really hope that Apple will sell more Macs in future with your software. Don't you have any hope for Photoshop/Illustrator/Premier on Linux?
I understand that opensource developers don't understand end-users. But I don't understand software giants.
So basically, we need query-based databases (SQL or XML) instead of filesystems. Perhaps OS400?
The book is about MySQL. Slashdot is based on MySQL and it's way too slow. And now the comment about such fact is moderated as "Offtopic"? That's not very nice. You can moderate it down and down, but you cannot hide the fact that the main reason that Slashdot is slow is b/c it's implemented with MySQL. That was a wrong technology choice for such class of web-applications as Slashdot is you cannot hide using your moderations.
PostgreSQL instead of MySQL is certainly a great improvement. But why stop on it? Python is much better than PHP as well. So, all we need is "Python and PostgreSQL" book. Or prehaps, "Zope and PostgreSQL". Any authors around there? Anyone to volunteer?
- it is the perfect illustration that MySQL is BAD for web based *write-intensive* applications. In future, use MySQL only for mostly-read applications.
- There are lot's of PHP and MySQL fans yet, who heard that PHP and MySQL are great for web development, but didn't try yet. Well, they didn't try anything else yet. And it's sad that they will begin their web-dev experience with such primitive tools.
It's not a troll. I just disagree that the market is slashdotted by either primitive free tools or expensive commercial tools. Why only few people pay attention on a "middle-way", free but yet power tools, like Python and PostgreSQL? Or such people are so smart that they don't waste their time on Slashdot?Perhaps not all americans are ready to bomb all countries around the globe. But they share the responsibility with their goverment even if they voted against it on recently passed elections. That the nature of democracy, isn't it?
If americans cannot choose right president that means most of americans don't care about the rest of the world. And I don't like such people.
So, if your country is not bombed yet - it's a matter of time and it will be. Just stay in the line and wait for your turn patiently.
I wonder, will USA recycle already bombed countries to the far end of the evil axis or there is another rule how to treat them?
However, I would recommend to stay away from > 2GB files in database environment. Even if your FS supports large files, you still loose performance on "double-driver": first your kernel provedes a partition, than it provides a file-system over it. But if you need so big files, why would you need file-system? Just use row partitions!
Of course you still need large files for video, but massive concurrent preformance overhead is not a typical problem in such case.
What you'll really missed in PostgreSQL for 24/7 is a good replication. But they are working on it.
By the way, are you sure you want 24/7/365? I think 24/7/52 will be more correct, no? I don't think that 7 years of uptime is a good idea when you want to upgrade your software (usually you stop/restart the service for it) about ever year.
You mistake Perl with Java.
Sourceforge has been planning to migrate from MySQL to PostgreSQL and even re-wrote part of their software. Untill IBM came. Now it's powered by DB/2.
Under the pressure from IBM Red Hat has dropped PostgreSQL in a flaviour of DB/2, forgeiing that with RedHat Linux they selled PostgreSQL called RedHat Database for few years.
Several open-source projects' bugzilla repositories has been forced to move from PostgreSQL to DB/2.
IBM doesn't afraid Linux as they don't care what OS is installed on their x86 computers and they have the profit on RS6K more from hardware and applications than from AIX. But IBM is really scared by PostgreSQL as a competitor of DB/2. No wonder they use similar methods as Microsoft does being scared by Linux.
So, don't dance congratulating the win. Wait for the monster.
Seriously, I think they should create a moderation system similar to what Slashdot has implemented here. So, no matter what is your citizenship - your Karma is what's important.
Let freedom of speech be independent from INS decisions!
Great thing about Lisp, is if you need to convert your communications, you can write Lisp against it to convert it while you convert your Lisp source.. easily.
I plopped an XSLT processor in front of it. Took minutes to implement. In the mean time, I was able to properly rewrite the XML producing code. So I had some flexibility in terms of patching the protocol quickly, while taking the weeks I needed to fix things right.
I plopped a Lisp processor in front of it. Took minutes to implement. In the mean time, I was able to properly rewrite the Lisp producing code. So I had some flexibility in terms of patching the protocol quickly, while taking the weeks I needed to fix things right.
the point is, XML IS descriptive, so long as you use good names.
the point is, Lisp IS descriptive, so long as you use good names.
If you use XML to develop a lower level protocol you end up with bloated 10k messages.
If you use Lisp S-expressions to develop a lower level protocol you don't end up with bloated 10k messages.
Besides, in Common Lisp you'll really appreciate MOP - Meta-Object Protocol. Much better than SOAP.
Trust me, I know well, actively use and actually love both Lisp *AND* XML.
Who cares about JVM if Python, Perl and Tcl from Active State can run faster and more reliable being interpreted by a native code based interpreter?
Besides Python, Perl and Tcl, there are many good natively (means: safe and fast) working interpreters on Windows: Prolog, Lisp, Haskell, Erlang, Mozart, Mercury, Ruby, and dozens of others.
Why would I need a double interpretation, when the interpreter can work in native codes?
And why should I limit myself to Java centric development, when right language for the right job is much better approach?
By inlcuding other interpreters into Windows and making a good advertisement of it, Microsoft can prove that JVM is not the only choice developers have for cross-platform development.
No need to mention that many of cross platform interpreters are licensed allowing them for being distributed with Windows. I think many developers of those interpreters would be happy to push their software to PC market, especially when the giant is pushing.
Of course, Microsoft can try to bind interpreters to .NET, but that would not be a problem if it would be an option - use it if like it or ignore it.
P.S. I don't like Microsoft's monopoly, although it's the only example of a bad market behaviour - look what Apple is doing. I don't like Windows/NT/2k/XP architectural design, although it wasn't the worst case until now - MacOS-9 was much worse. But I don't like Java either (especially thoughtless decision of most of companies to use Java only b/c Java is hot term on the market) and I don't like what Sun is doing with Java. I am not sure what I dislike more - Microsoft/Windows or Sun/Java, but I like to have more choices in Windows OS, that's for sure.
There will be many interesting (and failed) experiments, a lot of noise in the media and juts a little of real results.
I wonder who will be those hippies trying to run linux/PPC?
At last I found it by myself: Newton used ARM back in 1996
I remember playing with Newton 5 years ago - it recognized my handwriting much better than any modern PDAs and you could teach it to recognize better.
That experiment just proves that Cristian teaching is wrong, or at least it is not complete. All living beings have their souls. Including cats and all other animals. You can ignore it, but ignorance doesn't help your own soul.
Second, and most important, you are saying that identical twins are in serious trouble, because only one of them has the soul, as the clone does not.
No, that post is saying that the clone received its own soul in a way as all we receive ours. It doesn't matter what way original emrion appeared - as a result of sex or of scientific experiment. It's got its own soul or it doesn't live.
The soul is not a bilogical substance, although it lives together with our bilogical bodies. For some period of time. The source of soul is from karma judgement of previous lives. That's why twins and clones has own absolutely independent souls. The similarity of their curent bilogical lives just gives them similar memories, which will disappear after this live anyway.
That's the problem of Christian teaching: it decare the soul existence but it doesn't explain the nature of soul.
If you are interesting in more details about the subject try to read articles on this site. Or, better, find a good teacher.
It will be a trend when MSFT will drop half of its current price at the period when both Nasdaq and Dow will keep the same or even grow.
Now it's not a trend, it's just a subject to discuss on ./
In fact, many yahoo and hotmail users live outside of US (I do!). Many other doc-com/net/org people as well. No way to say where is the person's country based on the person's email address.
Unless the address is some@ISP.us - there is no way to prove that the spammer has intended to do the business with US residents. How many people in US use email address ending on dot-us?
So, what are you gonna do - move all americans to dot-us domain? Or you gonna protect only people with non-anonymous country-domain in their email addresses?
The only way to protect my house from uninvited people is to use the door. Perhaps with the dog. So, don't waste your time on dreaming to enforce your american laws in other countries - use e-certificates and filters.