To be honest, (until today!) I last used FORTRAN when it was version IV, in the early 70's! I have even seen FORTRAN II code.
I just went looking on Google for 'FORTRAN database' etc. - next to nothing turned up.
In my searching, I came across a comment that FORTRAN compiles into smaller, and far more efficient code, for extensive number crunching - than C++. I suspect that Java (with its vicious optimising JIT) might do better, as it can optimise based on the run time execution profile - in terms of speed.
I suspect that in supercomputing, they use massive in memory data structures, and rely on flat files to store data - maybe they can store memory data structures on disk?
Just compiled my first FORTRAN program for over 30 years, using gfortran under Linux! If I have to pick another language to learn, for fun rather than commercial gain, I would pick a dialect of Lisp rather than FORTRAN.
[...]And I mock you for your love of Python! A language where your editor's tab settings can change the meaning!! A language without semicolons!!! Everyone know that the only language without semicolons was (visual) basic and that is a bad thing. By association, Python must be bad.[...]
Visual Basic is the only language that I have written a program in and never succeeded in getting a program to run (with, or without, errors)!
While Python is a very poor relative of Java, it is orders of magnitude nicer than Visual Basic - IMnsHO.
Java can also be used in Oracle (the db), but PL/SQL works better. It still is very messy though. At this moment, I prefer to do the data massaging in Java and keep the sprocs to a very bare skeleton. A bit of aggregation ok. But where I work now, complex reporting stuff is done in PL/SQL and that is not a nice sight.
I think that the disadvantages of Java outweigh its many advantages, when used in stored procedures - not that I ever used Java for such, so I could be wrong...
I once wrote a stored procedure in Sybase TransactSQL of over 3000 lines, using 7 temporary tables that accessed at least 15 tables from 2 databases for a reporting program. I would have preferred to do the bulk of the logic id Java, but it was not practical - partly because of political reasons.
I've got about 20 years experience in C++. I installed the first preprocessor on a Sun workstation (there's that Oracle connection again) if memory serves, and it didn't work well. Stroustrup certainly made a mess out of it, multiple inheritance and all. And then he scorned the most elegant thing in the language, templates.
Objective-C is mainly a mac thing, but it does compile on other platforms. It's a pretty interesting language. And rather efficient. However, there is nothing comparable to Tomcat/JBoss/... or Active Mqueue or any of that stuff that makes Java so versatile. On the other hand, perhaps there is, but it might be expensive. Objective-C totally rules for GUI development though.
Oh! Another ancient one, but I bet I am more ancient than you!!!:-)
I probably have the dubious distinction of developing the last commercial paper tape application in New Zealand in the late 70's. Some bright spark noticed Teletypes produced paper tape and realized computers could read it... Do you know that an 8 track paper tape reader can read 5 track paper tape 4 different ways? The program was in COBOL for the business logic with a module I wrote in assembly language to interface with the paper tape reader - it ran on an ICL 4/72 mainframe with a massive 1MB of memory and a fast 2MHz processor (you try telling that to the younger generation, they won't believe you...). Fun and games getting a computer program to process data typed in by humans. It was about inputting details of inward collect phone calls from Australia to New Zealand.
And I mock you for your love of Python! A language where your editor's tab settings can change the meaning!! A language without semicolons!!! Everyone know that the only language without semicolons was (visual) basic and that is a bad thing. By association, Python must be bad.
Java 1.1 I/O... there's something to be improved. Or Calendar, my goodness. Thank The Force for JodaTime.
Such ignorant comments I would expect from a mere Oracle lackey! I fart in your general direction (The Python documentation says that references to Monty Pythin, are not only permitted, but encouraged!)!
//////
I think I have far exceeded my 6 monthly quota for writing comments to Slashdot, for this one article! Now I really need to concentrate on pretending to work...
Well, to bring it back on topic briefly: Java is one of over 10 languages that stored procedures can be written in for PostgreSQL - but I have only ever used pgsql PostgreSQL stored procedures.
With respect to frameworks: I've found that Objective-C(++) scales pretty well, and is very, very friendly in terms of multithreading.
I once got offered a six month contract in C++ - on the basis of a little C++ experience at university as part of a course in Object Oriented databases (having gone back to University and just completed a post grad diploma in computer science) and having read 'The Book' by the creator of C++ - mind you, I had many years prior development experience in several other languages. However, I chose to get into Java.
I have heard of Objective-C, but never seen it, I have seen it mentioned at in the release notes for a version of gcc. Is this a purely Mac thing?
But I agree that Java has an edge in ease of deployment. And I quite like the braces and semicolons...
In the best traditions of slashdot, I should focus on off-topic trivia and deride you vehemently for liking "braces and semicolons", because that differs from my preferences and therefore obviously makes you inferior - but I can't be bothered!:-)
Anyway, Java is not Oracle's product, just as MySQL really isn't. These were conceived and grown elsewhere, just to end up in the portfolio of a company that took 8 versions just to improve SQL*Plus a bit...
I started programming in Java just after Java 1.1 came out. I was learning it in my own time and giving seminars to interested colleagues after hours. I remember struggling with the understanding of the Java I/O classes, and the next day presenting a seminar on it as though I was an expert...
Note that all the problems I mentioned are specific issues I found with Fedora 14
I am using Fedora 14, as well!
There you have config files in var
Being outside of etc is not a showstopper, but strange to say the least.
You're right! I had forgotten that I had manually moved the configuration file to/etc, with a symbolic link in the original data directory!
The issue with MD5 passwords is that in Ubuntu, for example, you have "the magical line":
local all postgres ident
Whereas in F14 (no line present) if you try to change it, to use MD5, for local connections, you can't (because you'll set a 'ident' password, switch to md5 and it stops working) So either you set it for tcp only or you configure it like Ubuntu (took me a while to figure this). Anyway it makes you set the config file one way, do something then change it again.
I have done stuff in Ubuntu with MySQL with SQL, but only used PostgreSQL on Red Hat and Fedora.
If you find similar problems in Fedora, raise it with the Postgres folk, else with the Ubuntu crowd.
Anyway, I've found PGSQL more difficult overall than MYSQL for most admin operations (and no, I have very little experience with both, maybe it's the docs, but pgsql seems to be 'more picky' especially with the sql syntax (where you have to use quotes or double quotes accordingly),
As a general rule, I prefer software frameworks to be strict (or 'picky' in your terminology) as this tends to lead to fewer surprises with unintended consequences - such unexpected ambiguities where a developer interprets something one way and the software interprets it another way, you may usually get the same results except in some special corner cases (that knowing Sod's Law, will only turn up once you get into production!).
but I have to say that Pgadmin ROCKS
For example, select * from table where field=blah works with single quotes and double quoeta in MySQL but only with single quotes in PostgreSQL (Also, I don't get dt instead of show tables)
And yes, I've been bitten by MySQL table types as well.
The way I see it, PostgreSQL is a great SQL Database. If you need SQL features, if you'll use every nook and cranny of the SQL spec go for it. If you're a bank for example.
I have been developing with databases for about 30 years, and PostgreSQL for about 10, but I probably know less than 1% of what PostgreSQL can do. Reading the PostgreSQL mailing lists is a great way to erase any pretensions of expertise about PostgreSQL!!!:-)
I think it is worth while using PostgreSQL even for simple or 'toy' projects, as it leads to better habits and a greater understanding of what is involved in serious database work. And as PostgreSQL is reasonably standards compliant, the knowledge can carry over to Oracle and other databases. Not to mention that a 'toy' project might one day grow up and be quite substantial - and during a period of rapid growth there will be no time to change your RDBMS!
PostgreSQL gives far more options, so that it might be best to use it from the beginning to save being painted into a corner - a little extra pain at the beginning to avoid major pain later!
MySQL is a great 'thing that stores data' that presents a basic SQL interface. But it's ok, I'm not writing SQL by hand, I'm using an ORM. I don't need all the security features, the ORM supports only one user. The ORM optimizes the queries. It's not going to be very fast, but that's ok. And in this case it's better to move the 'intelligence' outside of the DB.
From an application developer's viewpoint I agree with you 100%, as a DBA I disagree 100%! As a software architect, I would first look at the business case and the volume and other performance requirements - before deciding which ways I would jump, both aproaches may be valid to some extent.
FORTRAN is extensively used on supercomputers and is still in active development (each new version of gcc has tons of new features for FORTRAN, not just enhancements to C, and C++ etc. see http://gcc.gnu.org/gcc-4.7/changes.html).
Java is a great language for building serious Enterprise applications, and has a really ferocious JIT that compiles frequently used Java byte code into native machine instructions.
How many software frameworks are there, that can make effective use of a Terrabyte of memory and multiple cores, other than Java? See: http://blogs.oracle.com/java/entry/java_7_celebration_begins
[...]
A representative from the Royal Bank of Scotland explained that RBS relies on the JVM, a TB (Terrabyte!) of in-memory data 24 x 7, and is looking forward to Java 7 improvements.
[...]
I have written software in over 15 different languages in a variety of operating systems, and I prefer Java to all the others. Though I wish I could write Java without the curly brackets and semicolons 1ike python - but Python does not scale, nor does it handle multi threading very well, nor has much of the functionality, library support, and performance aspects, that Java has.
You can always find another language that has features that are superior to Java, but you cannot find another language that is overall superior to Java for serious software.
Though I admit I am not keen on the Oracle connection!
To be honest I don't like Facebook either, especially their cavalier attitude to their users' privacy and their attempts to lock up their users' data - compare these aspects with the Google+ approach. I have also seen too many security issues relating to Facebook use data.
I find pgsql very easy to use, but I use it in conjunction with other tools. For SQL queries I use gedit to create and edit an SQL script which I then execute in psql. I have used GUI applications to create and run SQL, but I find pgsql much more practical in conjunction with a good editer that is SQL aware.
I make full use of the advantages of Linux to apply a range of tools to my development process, so I don't expect one tool to fulfil all my development needs. Though Eclipse, with additional plugins, comes close for Java development (although, when I teach Java, I get students to use an editer rather than a full blown IDE like Eclipse when they start off).
For really complicated SQL tasks, I use several SQL scripts. Note that you can cause execution of several other SQL scripts from a master SQL script, breaking down SQL into logically coherent files makes understanding and maintenance easier. Perhaps I should never admit to having written a single stored procedure in Sybase TansactSQL of over 3000 lines of code in a single file (in a Microsoft environment, shudder)!:-)
If you have any problems with (or concerns about) PostgreSQL, then I suggest that you either file a bug report or post to the appropriate PostgreSQL forum or mailing list. You can see all the mailing lists for PostgreSQL at http://archives.postgresql.org/ and anyone can post to them. The PostgreSQL developers appreciate feedback and thoughtful suggestions.
I have run various versions of PostgreSQL on both 32 & 64 bit machines, for over 10 years - and never had strange problems running ininitdb that were not PEBKAC (a fancy term for user error!). Strange things happen to the best of software. Did you raise a bug report? was it reproducible? I once had a weird problem with another software package - that after much investigation, was put down to a transient RAM failure.
There are other software packages that do not store their config files under/etc, such as moodle and ultimatestunts.
Note that the rpm for Fedora does use/etc for the postgresql.conf. However, for evaluation purposes, I have run several different versions of postgreSQL installed concurrently, which I downloaded and compiled myself - so it not automatically on insisting on storing its config file under/etc is good thing.
I have had no problems with configuring it to use MD5 passwords - once I read the documentation properly, but then it was quite simply to do so. What were your problems?
You have not mentioned anything really significant. Whereas, there are plenty of gotchas setting up and running MySQL - like choosing the right engine, and the numerous 'quirks' in its SQL. Both MySQL and PostgreSQL require modifications to their configuration files for proper production running.
I read the mailing lists for PostgreSQL on a daily basis, so I am aware of problems with it. However, in my experience, all major software packages have problems, including the Oracle RDBMS. I am sure that if I read the MySQL forums or mailing lists that I would find further problems with that RDBMS as well. Note that several big corporations have, or are in the process of, migrating for an Oracle RDBMS to PostgreSQL - you can be assured that they did due diligence first.
Over the last 30 years I have used at least 6 different RDBMS, not counting different versions of each under a variety of different Operating Systems, and I much prefer PostgreSQL. I know that whatever one's preferred RDBMS, one can always find at least one feature that is better on some other RDBMS (for an example, there is one aspect of using variables in stored procedures that is superior in Sybase transactSQL than in PostgreSQL pgSQL). I am quite happy to accept that in some situations, that MySQL is better than PostgreSQL.
The key is to use the most appropriate database technology for the business case, allowing for current and likely future needs.
Parent is mine, I had not realized I wasn't logged in!
I read the PostgreSQL Forums, so I'm aware of the shortcomings of PostgreSQL and some of what is being worked on, but I'm also aware of its benefits.
Hence, I would always advise businesses to do a pilot before committing to change from one RBDMS to another, unless there are compelling reasons not too.
Hmm...
I can do reasonable stuff in PostgreSQL without buying any books; but when I got a client using MySQL I found it necessary to buy a book on it.
Now I've been using database from my Mainframe days, and have experience on Oracle and Progress RDBMS's, plus Sybase. Writing SQL queries and stored procedures in PostgreSQL, is generally far better than any other RDBMS (you can almost always find situations where another RDBMS is better, no matter what your current RDBMS is!).
So I would far rather create and maintain a database using PostgreSQL, than any other RDBMS that I have ever used.
But Newton's model makes no sense when asking questions such as "what would happen to the Earth if the Sun suddenly disappeared. It doesn't predict the bending of light, nor does it properly describe certain orbital phenomenon.
Actually, Newton's Gravitational laws _DID_ predict the bending of light by the Sun, but by a different amount!
There is a factor of 2 difference (can't remember which predicted the greater bending!).
The desktop does not matter it is only a device on which to run a web browser. The average user spends most of his online time running pages served from linux. Then he goes and sits in front of his tv powered by linux, plays with his phone powered by linux, scrolling through his dvr running linux.
The average user spends most of her [females now outnumber male Internet users] online time running pages served from linux [connected via cable or DSL modem using VxWorks, on core Internet infrastructure using IOS or FreeBSD]. Then she goes and sits in front of her tv powered by linux, plays with her phone powered by Nokia OS [most phones aren't smart phones], scrolling through her dvr running linux. She also listens to her iPod (running iOS) while driving a car containing many embedded microprocessors, which don't run Linux. Nor do the processors in her air conditioner, washing machine, microwave etc..
My point being that computers are now ubiquitous, and most of them don't run Windows, or Linux.
The average user spends most of their [there are both females and male Internet users, and gender is irrelevant to this discussion] online time running pages served from linux [connected via cable or DSL modem using VxWorks, on core Internet infrastructure using IOS or FreeBSD]. Then they go and sit in front of their tv powered by linux, play with their phone powered by Nokia OS [most phones aren't smart phones], scrolling through their dvr running linux. They also listen to their iPod (running iOS) while driving a car containing many embedded microprocessors, which don't run Linux. Nor do the processors in their air conditioner, washing machine, microwave etc..
Actually April Fool's jokes apply to the whole day.
It was just that schools like to limit the 'damage' to the morning.
At one time the year ended on March 31st. So when it first came in, people were sent on fool's errands on the 'first day' of the New Year. So people who had not accepted, or remembered, that April 1st was not the first day of the year were made fun of. Hence April Fool's jokes apply to the whole day.
There is a problem on the Internet, I got told off, because I had published an April Fool's joke on March 31st according to someone - but they failed to realize that some parts of the planet have different time zones, and I had posted it when it was Friday April 1st in New Zealand.
On a more serious note, have a look at: http://nzopensource.blogspot.com/2011/04/windroid-announced.html
WARNING: Smilies omitted due to budget constraints...
> but what I was buying I found on mp3.com back in the day. I like power metal, but it's so hard
> to find new bands. I know there out there, but there's lots of pretty lousy acts and even if funds
eeeeeeeeeeeeeeeeeeee --- they're ---
alternately
eeeeeeeeeeeeeeeeeeee --- they are ---
> were unlimited (there not) it's just too much
eeeeeeeeeeee --- they're ---
alternately
eeeeeeeeeeee --- they are ---
> bother to find them. I miss being able to just pull down a bunch of cool demo tracks from mp3.com
? from up and coming bands. Stuff like Dragonforce, Power Quest, Frostweaver (anyone but me
> heard of 'em? Only had 5 tracks).
Some grammar/spelling mistakes are more irritating than others...
Sorry about the massive number of e's - Slahdor won't let me format it prioperly!
>>>
How can I get rid of this silly slider business???
Or how can I communicate with the slashdot people to discuss this?
I've spent time looking at all the preferences, I can't see any help there.
Slashdot Mirror
I looked at equipment recently for wireless using the 'n' protocl - but noticed no mention of IPv\6.
No point of gertting new communications equipment, if it cannot be suicessfully usec with IPv6!
So make IPv6 part of the requirments.
UFO: Unidentified Freezing Object
I meant: Version 6 Update 27
Version 6 Update 23 is due to be released soon, it is already at beta 3.
http://jdk6.java.net/6uNea.html
Drop old battery out & insert fully charged battery - ten minutes?
Batteries can be charged independently of the aircraft.
To be honest, (until today!) I last used FORTRAN when it was version IV, in the early 70's! I have even seen FORTRAN II code.
I just went looking on Google for 'FORTRAN database' etc. - next to nothing turned up.
In my searching, I came across a comment that FORTRAN compiles into smaller, and far more efficient code, for extensive number crunching - than C++. I suspect that Java (with its vicious optimising JIT) might do better, as it can optimise based on the run time execution profile - in terms of speed.
I suspect that in supercomputing, they use massive in memory data structures, and rely on flat files to store data - maybe they can store memory data structures on disk?
Just compiled my first FORTRAN program for over 30 years, using gfortran under Linux! If I have to pick another language to learn, for fun rather than commercial gain, I would pick a dialect of Lisp rather than FORTRAN.
[...]And I mock you for your love of Python! A language where your editor's tab settings can change the meaning!! A language without semicolons!!! Everyone know that the only language without semicolons was (visual) basic and that is a bad thing. By association, Python must be bad.[...]
Visual Basic is the only language that I have written a program in and never succeeded in getting a program to run (with, or without, errors)!
While Python is a very poor relative of Java, it is orders of magnitude nicer than Visual Basic - IMnsHO.
Java can also be used in Oracle (the db), but PL/SQL works better. It still is very messy though. At this moment, I prefer to do the data massaging in Java and keep the sprocs to a very bare skeleton. A bit of aggregation ok. But where I work now, complex reporting stuff is done in PL/SQL and that is not a nice sight.
I think that the disadvantages of Java outweigh its many advantages, when used in stored procedures - not that I ever used Java for such, so I could be wrong...
I once wrote a stored procedure in Sybase TransactSQL of over 3000 lines, using 7 temporary tables that accessed at least 15 tables from 2 databases for a reporting program. I would have preferred to do the bulk of the logic id Java, but it was not practical - partly because of political reasons.
I've got about 20 years experience in C++. I installed the first preprocessor on a Sun workstation (there's that Oracle connection again) if memory serves, and it didn't work well. Stroustrup certainly made a mess out of it, multiple inheritance and all. And then he scorned the most elegant thing in the language, templates.
Objective-C is mainly a mac thing, but it does compile on other platforms. It's a pretty interesting language. And rather efficient. However, there is nothing comparable to Tomcat/JBoss/... or Active Mqueue or any of that stuff that makes Java so versatile. On the other hand, perhaps there is, but it might be expensive. Objective-C totally rules for GUI development though.
Oh! Another ancient one, but I bet I am more ancient than you!!! :-)
I probably have the dubious distinction of developing the last commercial paper tape application in New Zealand in the late 70's. Some bright spark noticed Teletypes produced paper tape and realized computers could read it... Do you know that an 8 track paper tape reader can read 5 track paper tape 4 different ways? The program was in COBOL for the business logic with a module I wrote in assembly language to interface with the paper tape reader - it ran on an ICL 4/72 mainframe with a massive 1MB of memory and a fast 2MHz processor (you try telling that to the younger generation, they won't believe you...). Fun and games getting a computer program to process data typed in by humans. It was about inputting details of inward collect phone calls from Australia to New Zealand.
And I mock you for your love of Python! A language where your editor's tab settings can change the meaning!! A language without semicolons!!! Everyone know that the only language without semicolons was (visual) basic and that is a bad thing. By association, Python must be bad.
Java 1.1 I/O... there's something to be improved. Or Calendar, my goodness. Thank The Force for JodaTime.
Such ignorant comments I would expect from a mere Oracle lackey! I fart in your general direction (The Python documentation says that references to Monty Pythin, are not only permitted, but encouraged!)!
//////
I think I have far exceeded my 6 monthly quota for writing comments to Slashdot, for this one article! Now I really need to concentrate on pretending to work...
The topic was of course relational databases.
Well, to bring it back on topic briefly: Java is one of over 10 languages that stored procedures can be written in for PostgreSQL - but I have only ever used pgsql PostgreSQL stored procedures.
With respect to frameworks: I've found that Objective-C(++) scales pretty well, and is very, very friendly in terms of multithreading.
I once got offered a six month contract in C++ - on the basis of a little C++ experience at university as part of a course in Object Oriented databases (having gone back to University and just completed a post grad diploma in computer science) and having read 'The Book' by the creator of C++ - mind you, I had many years prior development experience in several other languages. However, I chose to get into Java.
I have heard of Objective-C, but never seen it, I have seen it mentioned at in the release notes for a version of gcc. Is this a purely Mac thing?
But I agree that Java has an edge in ease of deployment. And I quite like the braces and semicolons...
In the best traditions of slashdot, I should focus on off-topic trivia and deride you vehemently for liking "braces and semicolons", because that differs from my preferences and therefore obviously makes you inferior - but I can't be bothered! :-)
Anyway, Java is not Oracle's product, just as MySQL really isn't. These were conceived and grown elsewhere, just to end up in the portfolio of a company that took 8 versions just to improve SQL*Plus a bit...
I started programming in Java just after Java 1.1 came out. I was learning it in my own time and giving seminars to interested colleagues after hours. I remember struggling with the understanding of the Java I/O classes, and the next day presenting a seminar on it as though I was an expert...
Just noticed I got a bit confused when responding to your md5 comments!
Great answer, thanks
Note that all the problems I mentioned are specific issues I found with Fedora 14
I am using Fedora 14, as well!
There you have config files in var
Being outside of etc is not a showstopper, but strange to say the least.
You're right! I had forgotten that I had manually moved the configuration file to /etc, with a symbolic link in the original data directory!
The issue with MD5 passwords is that in Ubuntu, for example, you have "the magical line": local all postgres ident
Whereas in F14 (no line present) if you try to change it, to use MD5, for local connections, you can't (because you'll set a 'ident' password, switch to md5 and it stops working) So either you set it for tcp only or you configure it like Ubuntu (took me a while to figure this). Anyway it makes you set the config file one way, do something then change it again.
I have done stuff in Ubuntu with MySQL with SQL, but only used PostgreSQL on Red Hat and Fedora.
If you find similar problems in Fedora, raise it with the Postgres folk, else with the Ubuntu crowd.
Anyway, I've found PGSQL more difficult overall than MYSQL for most admin operations (and no, I have very little experience with both, maybe it's the docs, but pgsql seems to be 'more picky' especially with the sql syntax (where you have to use quotes or double quotes accordingly),
As a general rule, I prefer software frameworks to be strict (or 'picky' in your terminology) as this tends to lead to fewer surprises with unintended consequences - such unexpected ambiguities where a developer interprets something one way and the software interprets it another way, you may usually get the same results except in some special corner cases (that knowing Sod's Law, will only turn up once you get into production!).
but I have to say that Pgadmin ROCKS
For example, select * from table where field=blah works with single quotes and double quoeta in MySQL but only with single quotes in PostgreSQL (Also, I don't get dt instead of show tables)
And yes, I've been bitten by MySQL table types as well.
The way I see it, PostgreSQL is a great SQL Database. If you need SQL features, if you'll use every nook and cranny of the SQL spec go for it. If you're a bank for example.
I have been developing with databases for about 30 years, and PostgreSQL for about 10, but I probably know less than 1% of what PostgreSQL can do. Reading the PostgreSQL mailing lists is a great way to erase any pretensions of expertise about PostgreSQL!!! :-)
I think it is worth while using PostgreSQL even for simple or 'toy' projects, as it leads to better habits and a greater understanding of what is involved in serious database work. And as PostgreSQL is reasonably standards compliant, the knowledge can carry over to Oracle and other databases. Not to mention that a 'toy' project might one day grow up and be quite substantial - and during a period of rapid growth there will be no time to change your RDBMS!
PostgreSQL gives far more options, so that it might be best to use it from the beginning to save being painted into a corner - a little extra pain at the beginning to avoid major pain later!
MySQL is a great 'thing that stores data' that presents a basic SQL interface. But it's ok, I'm not writing SQL by hand, I'm using an ORM. I don't need all the security features, the ORM supports only one user. The ORM optimizes the queries. It's not going to be very fast, but that's ok. And in this case it's better to move the 'intelligence' outside of the DB.
From an application developer's viewpoint I agree with you 100%, as a DBA I disagree 100%! As a software architect, I would first look at the business case and the volume and other performance requirements - before deciding which ways I would jump, both aproaches may be valid to some extent.
FORTRAN is extensively used on supercomputers and is still in active development (each new version of gcc has tons of new features for FORTRAN, not just enhancements to C, and C++ etc. see http://gcc.gnu.org/gcc-4.7/changes.html).
So don't knock FORTRAN!
Java is a great language for building serious Enterprise applications, and has a really ferocious JIT that compiles frequently used Java byte code into native machine instructions.
How many software frameworks are there, that can make effective use of a Terrabyte of memory and multiple cores, other than Java? See: http://blogs.oracle.com/java/entry/java_7_celebration_begins
[...]
A representative from the Royal Bank of Scotland explained that RBS relies on the JVM, a TB (Terrabyte!) of in-memory data 24 x 7, and is looking forward to Java 7 improvements.
[...]
I have written software in over 15 different languages in a variety of operating systems, and I prefer Java to all the others. Though I wish I could write Java without the curly brackets and semicolons 1ike python - but Python does not scale, nor does it handle multi threading very well, nor has much of the functionality, library support, and performance aspects, that Java has.
You can always find another language that has features that are superior to Java, but you cannot find another language that is overall superior to Java for serious software.
Though I admit I am not keen on the Oracle connection!
An unfair comment you made, but you were funny!
To be honest I don't like Facebook either, especially their cavalier attitude to their users' privacy and their attempts to lock up their users' data - compare these aspects with the Google+ approach. I have also seen too many security issues relating to Facebook use data.
Hmm...
:-)
I find pgsql very easy to use, but I use it in conjunction with other tools. For SQL queries I use gedit to create and edit an SQL script which I then execute in psql. I have used GUI applications to create and run SQL, but I find pgsql much more practical in conjunction with a good editer that is SQL aware.
I make full use of the advantages of Linux to apply a range of tools to my development process, so I don't expect one tool to fulfil all my development needs. Though Eclipse, with additional plugins, comes close for Java development (although, when I teach Java, I get students to use an editer rather than a full blown IDE like Eclipse when they start off).
For really complicated SQL tasks, I use several SQL scripts. Note that you can cause execution of several other SQL scripts from a master SQL script, breaking down SQL into logically coherent files makes understanding and maintenance easier. Perhaps I should never admit to having written a single stored procedure in Sybase TansactSQL of over 3000 lines of code in a single file (in a Microsoft environment, shudder)!
If you have any problems with (or concerns about) PostgreSQL, then I suggest that you either file a bug report or post to the appropriate PostgreSQL forum or mailing list. You can see all the mailing lists for PostgreSQL at http://archives.postgresql.org/ and anyone can post to them. The PostgreSQL developers appreciate feedback and thoughtful suggestions.
/etc, such as moodle and ultimatestunts.
/etc for the postgresql.conf. However, for evaluation purposes, I have run several different versions of postgreSQL installed concurrently, which I downloaded and compiled myself - so it not automatically on insisting on storing its config file under /etc is good thing.
I have run various versions of PostgreSQL on both 32 & 64 bit machines, for over 10 years - and never had strange problems running ininitdb that were not PEBKAC (a fancy term for user error!). Strange things happen to the best of software. Did you raise a bug report? was it reproducible? I once had a weird problem with another software package - that after much investigation, was put down to a transient RAM failure.
There are other software packages that do not store their config files under
Note that the rpm for Fedora does use
I have had no problems with configuring it to use MD5 passwords - once I read the documentation properly, but then it was quite simply to do so. What were your problems?
You have not mentioned anything really significant. Whereas, there are plenty of gotchas setting up and running MySQL - like choosing the right engine, and the numerous 'quirks' in its SQL. Both MySQL and PostgreSQL require modifications to their configuration files for proper production running.
I read the mailing lists for PostgreSQL on a daily basis, so I am aware of problems with it. However, in my experience, all major software packages have problems, including the Oracle RDBMS. I am sure that if I read the MySQL forums or mailing lists that I would find further problems with that RDBMS as well. Note that several big corporations have, or are in the process of, migrating for an Oracle RDBMS to PostgreSQL - you can be assured that they did due diligence first.
Over the last 30 years I have used at least 6 different RDBMS, not counting different versions of each under a variety of different Operating Systems, and I much prefer PostgreSQL. I know that whatever one's preferred RDBMS, one can always find at least one feature that is better on some other RDBMS (for an example, there is one aspect of using variables in stored procedures that is superior in Sybase transactSQL than in PostgreSQL pgSQL). I am quite happy to accept that in some situations, that MySQL is better than PostgreSQL.
The key is to use the most appropriate database technology for the business case, allowing for current and likely future needs.
Hmm...
Parent is mine, I had not realized I wasn't logged in!
I read the PostgreSQL Forums, so I'm aware of the shortcomings of PostgreSQL and some of what is being worked on, but I'm also aware of its benefits.
Hence, I would always advise businesses to do a pilot before committing to change from one RBDMS to another, unless there are compelling reasons not too.
Hmm...
I use Fedora, I still prefer to use PostgreSQL to MySQL. I have yet to find anything easier to do in MySQL than PostgreSQL.
People keep saying MySQL is easier than PostgreSQL, but I have yet to see an example.
Hmm... I can do reasonable stuff in PostgreSQL without buying any books; but when I got a client using MySQL I found it necessary to buy a book on it.
Now I've been using database from my Mainframe days, and have experience on Oracle and Progress RDBMS's, plus Sybase. Writing SQL queries and stored procedures in PostgreSQL, is generally far better than any other RDBMS (you can almost always find situations where another RDBMS is better, no matter what your current RDBMS is!).
So I would far rather create and maintain a database using PostgreSQL, than any other RDBMS that I have ever used.
[...]
But Newton's model makes no sense when asking questions such as "what would happen to the Earth if the Sun suddenly disappeared. It doesn't predict the bending of light, nor does it properly describe certain orbital phenomenon.
Actually, Newton's Gravitational laws _DID_ predict the bending of light by the Sun, but by a different amount!
There is a factor of 2 difference (can't remember which predicted the greater bending!).
The desktop does not matter it is only a device on which to run a web browser. The average user spends most of his online time running pages served from linux. Then he goes and sits in front of his tv powered by linux, plays with his phone powered by linux, scrolling through his dvr running linux.
The average user spends most of her [females now outnumber male Internet users] online time running pages served from linux [connected via cable or DSL modem using VxWorks, on core Internet infrastructure using IOS or FreeBSD]. Then she goes and sits in front of her tv powered by linux, plays with her phone powered by Nokia OS [most phones aren't smart phones], scrolling through her dvr running linux. She also listens to her iPod (running iOS) while driving a car containing many embedded microprocessors, which don't run Linux. Nor do the processors in her air conditioner, washing machine, microwave etc..
My point being that computers are now ubiquitous, and most of them don't run Windows, or Linux.
The average user spends most of their [there are both females and male Internet users, and gender is irrelevant to this discussion] online time running pages served from linux [connected via cable or DSL modem using VxWorks, on core Internet infrastructure using IOS or FreeBSD]. Then they go and sit in front of their tv powered by linux, play with their phone powered by Nokia OS [most phones aren't smart phones], scrolling through their dvr running linux. They also listen to their iPod (running iOS) while driving a car containing many embedded microprocessors, which don't run Linux. Nor do the processors in their air conditioner, washing machine, microwave etc..
At the LHC, physicists often work through the night!
Actually April Fool's jokes apply to the whole day.
It was just that schools like to limit the 'damage' to the morning.
At one time the year ended on March 31st. So when it first came in, people were sent on fool's errands on the 'first day' of the New Year. So people who had not accepted, or remembered, that April 1st was not the first day of the year were made fun of. Hence April Fool's jokes apply to the whole day.
There is a problem on the Internet, I got told off, because I had published an April Fool's joke on March 31st according to someone - but they failed to realize that some parts of the planet have different time zones, and I had posted it when it was Friday April 1st in New Zealand.
On a more serious note, have a look at:
http://nzopensource.blogspot.com/2011/04/windroid-announced.html
WARNING: Smilies omitted due to budget constraints...
> but what I was buying I found on mp3.com back in the day. I like power metal, but it's so hard
> to find new bands. I know there out there, but there's lots of pretty lousy acts and even if funds
eeeeeeeeeeeeeeeeeeee --- they're ---
alternately
eeeeeeeeeeeeeeeeeeee --- they are ---
> were unlimited (there not) it's just too much
eeeeeeeeeeee --- they're ---
alternately
eeeeeeeeeeee --- they are ---
> bother to find them. I miss being able to just pull down a bunch of cool demo tracks from mp3.com
? from up and coming bands. Stuff like Dragonforce, Power Quest, Frostweaver (anyone but me
> heard of 'em? Only had 5 tracks).
Some grammar/spelling mistakes are more irritating than others...
Sorry about the massive number of e's - Slahdor won't let me format it prioperly!
>>> How can I get rid of this silly slider business??? Or how can I communicate with the slashdot people to discuss this? I've spent time looking at all the preferences, I can't see any help there.