1&2: You are right, but still doesn't support BLOBS in tuples, which simplifies a lot the maintenance and programming.
3. AFAIK, if you are sorting a table, which is very common in web pages, indexes reduces a lot the complexity of the sort. According to the PG docs, it's even makes use of temporary files for sorting data in case the output it's too big for doing it in memory.
6. It means that the file is available in the client or server side. It's important if you want to "download" a file from the client or import the contents from a server side file. It affects access privileges as well.
Regarding the remaining issues... you are right too.
I am one of the team doing PHP development for the Balearic Islands LUG. The current system runs with PostgreSQL and we were analysing the convenience of migrating to MySQL.
Find enclosed some of the conclusions:
PG does treat BLOBs as part of a tuple, MySQL does.
There are serious problems with PHP and PG transactions for reading and writing BLOBs in the database. PG forces to use transactions, MySQL doesn't.
PG doesn't use any index to speed up sorts (ORDER BY clauses), MySQL does. This is a problem for web pages were most of the result are ordered according to articles IDs or modification dates.
PG, as in V7, doesn't accept tuples of more the 8KB, 32 KB support can be selected at compilation time but speed is seriously affected. There is not this kind of restrictions in MySQL.
PG does not accept "full-text" indexing and queries.
In MySQL you can choose if a file to be imported is being read by the backend or the frontend.
You have to run VACCUM ANALYZE in PG from time to time in order to get your queries optimised.
PG doesn't allow to do BLOB content search, MySQL does.
PG accept RULES for executing SQL sentences on table insert or updates, MySQL doesn't.
NASA has migrated one of their webs to MySQL;-)
We found that the previous reasons justify the migration to MySQL.
In short, in the new Windows system and API architecture and development framework. Ramarkable points: an new bytecoded language (C#) to compite againts Sun/Java, integration with XML and deprecation of COM/DCOM...
Besides VStudio.NET, the rest it's still vapourware, or promises in the best case.
Nevertheless, according to recent stories such as Netscape/IE, RVideo/MSMedia, Citrix/Terminal Server, sure it will occur. We will call you the Sun Java/.NET story.
One of the problem it's data consistency among the different processors cache... I believe. Sometimes it's hard to avoid ping-pong effect of the different threads. Also, for threaded applications, they normally use the same memory, which means the data is replicated among the caches, which enforces consistency mechanisms.
I hope Bush tries to do something about this ludicrous situation, but knowing politicians, I won't be holding my breath
Poor guy... Bush's brother already filed in Florida offices for a patent on Non-click shopping for elders. This apparatus allows senior people to buy travel tickets and fishing equipment by mean of a tactile screens that avoid the use of computer mouse.
I don't want to comment about his Apparatus for decoding voting intentions patent filing. It's offtopic.
this is complicated by the attitude and orbit of the satellite
It was obvious from the beginning, the satellite it's a bad boy and doesn't have any consideration to earth's orders. He doesn't want to boot, he'd prefer tenniss', going to a higher orbit? Common on... it's warmer here...
Last days satellites are so respectful as the old ones. AI brought them to an undesirable stage...
Funny, I though that "shotgun" approach was what made Linux, and the whole Open-Source movement, so reliable and powerful.
The shotgun approach served well for those areas that are more attractive, have lot of fun, not very tedious, and results can be observed almsot inmediately: i.e. kernel development.
But the above is not true for applications that need a lot of research, tedious works, comprehensive testing and documentation for allowing further development: programming frameworks, software engineering tools (CASE and the likes), user interface, hardware development toolds (drivers), etc.
This is being demonstrated every simple day:
There is/was no development tools comparable to VS, Delphi, CASE tools, etc. For example, give an example of CASE and DB development tools for Linux comparable to Oracle for MS or Sun.
User interactive applications are much more tedious and need a lots of research compared to the kernel. Why Linux doesn't have yet a unique or compatible user interface system? Why the open source community couldn't develop a web browser comparable to IE5?
I can find a common denominator for those issues: it needs research, tedious work, it takes a long time to finish a single product, it requires lot of documentation and standarisation procedures. In few words, it needs formal software engineering approaches.
Just before the States supported the anti M$ trial, they were going to use a nice, although a little fatty, brunette fellowship face as their mascot. The message of the mascot was: Someone else sucks, Microsoft doesn't.
-> some may confuse this with the word comparison... this is a result of looking at flashing banner adds at the top of the web...
Yeah!!! I am feeling good. Rob is suffering the/. flashing ads banners effects. I was afraid I was the only one mispelling words in my messages. It's comfortable to know that/. is the guilty;-).
Nobody would believe this history if it were told few years ago...
And it's impressive how a bunch of well paid managers and pseudo-artists can change the digital landscape in the whole world.
Obviously they have a well formed and powerful lobby. Are American senators aware of how they are affecting (negatively) the future of not only technology, but every basic principle achieved in the last century?
These kind of things should, although they didn't, decide who are your representatives and president. W. Gates III looks naive compared to the Hollywood lobby.
--ricardo
Re:.NET might be very good to us
on
Perl and .NET
·
· Score: 2
And also, I don't see.NET as a threat but a HUGE opportunity for Linux and some OS languages.
Does Linux (or xxxBSD) do the right thing with Apache and HTTP? What about HTTP for RPC standard? Isn't sound better than Corba?
Do you already have a SOAP module for PERL? Isn't Perl (and Python) a good language for building [text, XML] parsers?
Ooops... How long it will take until you get same modules for Python, PHP, TCL/Tk and the likes?
Do you think O'Reilly is not interested in compiling Perl to the IL? Do you think it will be slower? Don't think so...
Do you think is very hard to have in short time a kind of xml-inetd for Unix/Linux/BSD?.
This will be heaven for many of us.
--ricardo
Re:.NET might be very good to us
on
Perl and .NET
·
· Score: 2
Well, that sounds great and all, but you know that Microsoft will work day and night to try and screw us over...
Although moderators might think it's a flamebait and burn my karma, I will say it:
We read this kind of crying many many times... Stop crying and help:
- write good OS code or
- write documentation or
- translate existing docs to other laguages or
- teach Linux in your classrooms or
- install Linux in your student labs or
- install Linux in your friend's computers or
-... just use Linux and OS software.
And mainly, accept and do self criticism, M$ might be an evil, but they _do_ also good things, and it's very convenient to recognize what's good and what rubish. OTH, OS developers, sometimes also write craps and bloated software.
But please, don't read it, I just knew that the original writer, Michael Crichton III, it's mining slahsdot disks recovered from the "big one" to present the results as evidences in the appeal against one of my grandchildren.
Not every disappearing technology deserves that fate. Sometimes the "losers" have an elegance and simplicity the "winners" lack. Here are ten examples.
MS Word
The sparse and tightfisted Word processor from the extinguished Microsoft company shaped the future of modern Speech Processors (SP) and user hyperinterface: thousand of icons and buttons in the screen, random behaviour, ill-behaviour with large document, the talking clipper. It lacks of features is considered, nowdays, more a virtue rather than a defect.
ISDN and ADSL
Copperlines, the 20th-century analog of today's quantic-optic fibers, had their own "last mile" problem. One 20th-century solution: small electron quantums pushed along expensive copper cables via porting in unhealthy high-frequencies that acted as carriers.
CDs and DVDs
Audiophiles lament the passing of digital sounds and MPEG audio, which they perceive as having a richer sound than the holographic pild. But the recorded disc was in its own day an upstart technology, elbowing out a superior medium for recording sound: the dic-shaped vinyl first manufactured by RCA in the middle of last century.
Personal Computers
In 1979, Commodore brought the Personal Computers to consumers. Two years later, the final shaped of old and bloated hardware born with the name of IBM Personal Computers, which lasted for 30 years until the quantic processor won its own position in the market.
Internet
The appeareance of this technology in the general-public market, 25 years later from its invention, was believed as the greater revolution since the Gutember invention. Nowadays, it is hard to believe that such a unreliable networks technology, still based in moving electrons along copper cables and optic fiber, and therefore anti-ecologic until its own bones, could last for 30 years with no opposition from the mithyc Greenpeace. Additionally, the primitive protocol used for reliable transmission, because networks weren't reliable at all, didn't allow for bandwidth aggregation and reservation, according to the amount of "electron packets" needed for the, already dissapeared, 2D plus sound streamed movies.
... still five more, but I don't want to put them all, just in case, to avoid a the original writer sueing to my grandchildren.
second, seeing what's in your yard? please, anything that flies
Come on... it's forbiden (and much more expensive) to a plane/chopter to fly over my house (I clarify it, it's forbiden to fly over the city) whithout a special permission.
best that you'll see is maybe what kind of fountain Madonna has in her yard or something
Or forbidden satellital TV antennas in some asiatic countries...
The wife example was, as I mentioned in the original, a naive and perhaps stupid example... But half a meter today means few milimeters in few years.
Nevertheless, whith that resolution you can get enough information about goods productions, plantations, petrol explorations, building surfaces, electric/energy installations, radio installations, satellital antennas (which are forbidden in some countries), and so on.
Ask Putin (replace this for any president you'd prefer) which method is cheaper to control his opposites: to maintain a satellite infrastructure and research? Or to buy the photograph?
I am not afraid of my privacity, I don't have anything important to hide, but privacity, in the sense that is technological expensive to peep you, is a fundamental value in most of "western minds"*.
* Tried to avoid "democracy" or "economy" overused words.
So, my neighbors can buy a phot to see what the hell I've got in my yard. Or to peep to my nude wife tanning in our roof.
Aside from those naive examples, it means that healthy companies and individuals are now able to buy valued information about smaller or poorer counterparts.
So, the world has become a enourmous peep show for those who can afford it.
Definitevely not an argument to cheers, although not worse that when only few countries' governments were able to peek to the whole world.
Old PDPs keyboards had problems with the keyboard which affected to the most frequently keys. At that time keyboards were used mainly for writing Multic technical reports, obscure long shell commands (see www.multicians.org) and programs in rare PLI-like languages which overused the "u" (MUltics, procedUre, modUle, sUbmodUle, Use, sUbset, checkoUt, bUlletins, etc).
Due to the systematic problems with the U key, Unix developers have avoided its use. For that reason, most of the primitive Unix commands and C keywords did not use U:
cat, ed, vi, emac, find, grep, w, ls, awk, sh, login, rm, ar, cc, sed, sort, cp, dd, df, ex, pwd, man, whatis...
While the U was reserved for infrequent and administrative commands (the overuse of "U" in those command was intended to deter their use to non-experimented users):
su, du, mount, umount, unlink, uname, update, setup, quota, uucp, uucico, uuname, uulog, uustat, uuto, uux, dump, shutdown, showmount, route, cu...
Naturally, all interconnects are superconducting and therefore lossless, at least at dc, and the losses remain low, compared to metals at room temperature, up to clock frequencies of about 750 GHz.
It also says they _could_ achieve more than 100 GHz... and 750 Mbits per second _has been_ experimented.
BTW, at 750 GHz that light goes _only_ 0.4mm (0.016 inches) in one cycle. That's impressive, but it also means there is still some margin to increase frequencies.
I wonder if there are enough particles in the universe to run a finite elements simulation for more than 4 hours in a 750 GHz CPU.
(nevertheless, we will need all that power to run Windows.NET 2010 Blackholesweeper;-).
You are missing a point. There are many companies wishing to migrate their application, developed on top of commercial software platforms, to Linux.
It's far more cheaper to them to use the same development framework/libraries for Linux than migrating to a new one, i.e. a DB2 application to Postgress. No company will do that!!!
Slashdot Mirror
3. AFAIK, if you are sorting a table, which is very common in web pages, indexes reduces a lot the complexity of the sort. According to the PG docs, it's even makes use of temporary files for sorting data in case the output it's too big for doing it in memory.
6. It means that the file is available in the client or server side. It's important if you want to "download" a file from the client or import the contents from a server side file. It affects access privileges as well.
Regarding the remaining issues... you are right too.
--ricardo
Find enclosed some of the conclusions:
- PG does treat BLOBs as part of a tuple, MySQL does.
- There are serious problems with PHP and PG transactions for reading and writing BLOBs in the database. PG forces to use transactions, MySQL doesn't.
- PG doesn't use any index to speed up sorts (ORDER BY clauses), MySQL does. This is a problem for web pages were most of the result are ordered according to articles IDs or modification dates.
- PG, as in V7, doesn't accept tuples of more the 8KB, 32 KB support can be selected at compilation time but speed is seriously affected. There is not this kind of restrictions in MySQL.
- PG does not accept "full-text" indexing and queries.
- In MySQL you can choose if a file to be imported is being read by the backend or the frontend.
- You have to run VACCUM ANALYZE in PG from time to time in order to get your queries optimised.
- PG doesn't allow to do BLOB content search, MySQL does.
- PG accept RULES for executing SQL sentences on table insert or updates, MySQL doesn't.
- NASA has migrated one of their webs to MySQL
;-)
We found that the previous reasons justify the migration to MySQL.--ricardo
Besides VStudio .NET, the rest it's still vapourware, or promises in the best case.
Nevertheless, according to recent stories such as Netscape/IE, RVideo/MSMedia, Citrix/Terminal Server, sure it will occur. We will call you the Sun Java/.NET story.
--ricardo
--ricardo
Poor guy... Bush's brother already filed in Florida offices for a patent on Non-click shopping for elders. This apparatus allows senior people to buy travel tickets and fishing equipment by mean of a tactile screens that avoid the use of computer mouse.
I don't want to comment about his Apparatus for decoding voting intentions patent filing. It's offtopic.
--ricardo
It was obvious from the beginning, the satellite it's a bad boy and doesn't have any consideration to earth's orders. He doesn't want to boot, he'd prefer tenniss', going to a higher orbit? Common on... it's warmer here...
Last days satellites are so respectful as the old ones. AI brought them to an undesirable stage...
--ricardo
--ricardo
The shotgun approach served well for those areas that are more attractive, have lot of fun, not very tedious, and results can be observed almsot inmediately: i.e. kernel development.
But the above is not true for applications that need a lot of research, tedious works, comprehensive testing and documentation for allowing further development: programming frameworks, software engineering tools (CASE and the likes), user interface, hardware development toolds (drivers), etc.
This is being demonstrated every simple day:
- There is/was no development tools comparable to VS, Delphi, CASE tools, etc. For example, give an example of CASE and DB development tools for Linux comparable to Oracle for MS or Sun.
- User interactive applications are much more tedious and need a lots of research compared to the kernel. Why Linux doesn't have yet a unique or compatible user interface system? Why the open source community couldn't develop a web browser comparable to IE5?
I can find a common denominator for those issues: it needs research, tedious work, it takes a long time to finish a single product, it requires lot of documentation and standarisation procedures. In few words, it needs formal software engineering approaches.--ricardo
--ricardo
-> some may confuse this with the word comparison... this is a result of looking at flashing banner adds at the top of the web ...
Yeah!!! I am feeling good. Rob is suffering the /. flashing ads banners effects. I was afraid I was the only one mispelling words in my messages. It's comfortable to know that /. is the guilty ;-).
Moderators: note the smiley.
--ricardo
And it's impressive how a bunch of well paid managers and pseudo-artists can change the digital landscape in the whole world.
Obviously they have a well formed and powerful lobby. Are American senators aware of how they are affecting (negatively) the future of not only technology, but every basic principle achieved in the last century?
These kind of things should, although they didn't, decide who are your representatives and president. W. Gates III looks naive compared to the Hollywood lobby.
--ricardo
Does Linux (or xxxBSD) do the right thing with Apache and HTTP? What about HTTP for RPC standard? Isn't sound better than Corba?
Do you already have a SOAP module for PERL? Isn't Perl (and Python) a good language for building [text, XML] parsers?
Ooops... How long it will take until you get same modules for Python, PHP, TCL/Tk and the likes?
Do you think O'Reilly is not interested in compiling Perl to the IL? Do you think it will be slower? Don't think so...
Do you think is very hard to have in short time a kind of xml-inetd for Unix/Linux/BSD?.
This will be heaven for many of us.
--ricardo
Although moderators might think it's a flamebait and burn my karma, I will say it:
We read this kind of crying many many times... Stop crying and help:
- write good OS code or ... just use Linux and OS software.
- write documentation or
- translate existing docs to other laguages or
- teach Linux in your classrooms or
- install Linux in your student labs or
- install Linux in your friend's computers or
-
And mainly, accept and do self criticism, M$ might be an evil, but they _do_ also good things, and it's very convenient to recognize what's good and what rubish. OTH, OS developers, sometimes also write craps and bloated software.
--ricardo
--ricardo
Ten Passed Technologies
Not every disappearing technology deserves that fate. Sometimes the "losers" have an elegance and simplicity the "winners" lack. Here are ten examples.
MS Word
The sparse and tightfisted Word processor from the extinguished Microsoft company shaped the future of modern Speech Processors (SP) and user hyperinterface: thousand of icons and buttons in the screen, random behaviour, ill-behaviour with large document, the talking clipper. It lacks of features is considered, nowdays, more a virtue rather than a defect.
ISDN and ADSL
Copperlines, the 20th-century analog of today's quantic-optic fibers, had their own "last mile" problem. One 20th-century solution: small electron quantums pushed along expensive copper cables via porting in unhealthy high-frequencies that acted as carriers.
CDs and DVDs
Audiophiles lament the passing of digital sounds and MPEG audio, which they perceive as having a richer sound than the holographic pild. But the recorded disc was in its own day an upstart technology, elbowing out a superior medium for recording sound: the dic-shaped vinyl first manufactured by RCA in the middle of last century.
Personal Computers
In 1979, Commodore brought the Personal Computers to consumers. Two years later, the final shaped of old and bloated hardware born with the name of IBM Personal Computers, which lasted for 30 years until the quantic processor won its own position in the market.
Internet
The appeareance of this technology in the general-public market, 25 years later from its invention, was believed as the greater revolution since the Gutember invention. Nowadays, it is hard to believe that such a unreliable networks technology, still based in moving electrons along copper cables and optic fiber, and therefore anti-ecologic until its own bones, could last for 30 years with no opposition from the mithyc Greenpeace. Additionally, the primitive protocol used for reliable transmission, because networks weren't reliable at all, didn't allow for bandwidth aggregation and reservation, according to the amount of "electron packets" needed for the, already dissapeared, 2D plus sound streamed movies.
--ricardo
Good and very polite argument.
for starters, the "wife tanning" example is terrible
Read http://slashdot.org/comments.pl?sid=00/12/16/22182 09&cid=54
second, seeing what's in your yard? please, anything that flies
Come on... it's forbiden (and much more expensive) to a plane/chopter to fly over my house (I clarify it, it's forbiden to fly over the city) whithout a special permission.
best that you'll see is maybe what kind of fountain Madonna has in her yard or something
Or forbidden satellital TV antennas in some asiatic countries...
--ricardo
Nevertheless, whith that resolution you can get enough information about goods productions, plantations, petrol explorations, building surfaces, electric/energy installations, radio installations, satellital antennas (which are forbidden in some countries), and so on.
Ask Putin (replace this for any president you'd prefer) which method is cheaper to control his opposites: to maintain a satellite infrastructure and research? Or to buy the photograph?
I am not afraid of my privacity, I don't have anything important to hide, but privacity, in the sense that is technological expensive to peep you, is a fundamental value in most of "western minds"*.
* Tried to avoid "democracy" or "economy" overused words.
--ricardo
Aside from those naive examples, it means that healthy companies and individuals are now able to buy valued information about smaller or poorer counterparts.
So, the world has become a enourmous peep show for those who can afford it.
Definitevely not an argument to cheers, although not worse that when only few countries' governments were able to peek to the whole world.
--ricardo
Oh not at all, it was just a second of mis-inspiration.
If it isn't, then I'm pretty impressed that you came up with it.
I am happy you liked it, I have no idea how it came to me. May be because I also noticed the lack of the U and I had a telnet next windows.
--ricardo
Due to the systematic problems with the U key, Unix developers have avoided its use. For that reason, most of the primitive Unix commands and C keywords did not use U:
cat, ed, vi, emac, find, grep, w, ls, awk, sh, login, rm, ar, cc, sed, sort, cp, dd, df, ex, pwd, man, whatis...
While the U was reserved for infrequent and administrative commands (the overuse of "U" in those command was intended to deter their use to non-experimented users):
su, du, mount, umount, unlink, uname, update, setup, quota, uucp, uucico, uuname, uulog, uustat, uuto, uux, dump, shutdown, showmount, route, cu...
--ricardo
I don't have moderator points left, please someone moderate it up.
--ricardo
Naturally, all interconnects are superconducting and therefore lossless, at least at dc, and the losses remain low, compared to metals at room temperature, up to clock frequencies of about 750 GHz.
It also says they _could_ achieve more than 100 GHz... and 750 Mbits per second _has been_ experimented.
BTW, at 750 GHz that light goes _only_ 0.4mm (0.016 inches) in one cycle. That's impressive, but it also means there is still some margin to increase frequencies.
I wonder if there are enough particles in the universe to run a finite elements simulation for more than 4 hours in a 750 GHz CPU. (nevertheless, we will need all that power to run Windows .NET 2010 Blackholesweeper ;-).
--ricardo
--ricardo
Damm it!!, I would prefer Fortran 80 instead. We were lucky Java (and Java beans) wans't invented at that time.
--ricardo
It's far more cheaper to them to use the same development framework/libraries for Linux than migrating to a new one, i.e. a DB2 application to Postgress. No company will do that!!!
--ricardo