Or select * from pg_tables; if you really want to. \d and the variations thereof are the quickets choice though. Use \? from psql to see what's available.
A lot of mysql people seem to complain about the lack of the nonstandard "show tables" type commands in postgresql. But "show tables" being non-standard means you had to read the documenation to find that. If you read the postgresql documentation also instead of expecting postgresql to have the mysql non-standard extensions you'd find that in fact postgresql is much more flexible and powerful when it comes to finding system information.
Giddy with a shiny new computer a few weeks ago was happy to finally have an excuse to upgrade from 4.x to the glorious world of FreeBSD 5... but, alas, I also had big problems with 5.0-RELEASE.
It's pretty bad with your system won't boot at all unless you (i'm amazed i found this info at all) tweak the kernel to turn off DMA on the hard drive during boot up).
I had other problems as well. It seems just certain hardware causes problems. Others have no problems. My problems were so severe though, I heart brokenly was contemplating the descent back to the blessed safety of STABLE-land...
But first I figured i'd give the latest snapshot build a chance... i snagged a small ISO and put it on an RW... installation went smoothly... and all my problems disappeared!
I was hoping that 5.0 would be stable enough to install on a dev server, but my experience scared me significantly. Even though the snapshot I now have installed is running like a dream... still i'm too nervous about using this now on any non-home server.
But, if the progress they've made between 5.0 and the snapshot i have is any indication of the rate of progress being made, maybe i'll give 5.1 a shot in a few more places... whilst still looking forward to a hopefully STABLE tagged 5.2.
God save us from a Max Payne movie. But then God save us from just about any Video Game movie. Nevertheless, I say this as a big fan of Max Payne the game. The game was so good that even the dialog became tolerable after a while... and then a while after that, immensely enjoyable.
When I first started into Max Payne I could barely tolerate the dialog. It was soooo bad. It is predicable that some here would stick up for it and try to convince us it was good, using various arguments. I don't buy the "parody" argument. Nor do I buy the "cleverness"... though it was occassionally clever merely in pushing cliche seriously to a new level (if the writers were really clever then they would have come up with some cleverness in the plot rather than cliche after cliche turns of events).
Anyhow, the actual game play was very nice. The controls were annoyingly simplified at first compared to other FPS's.... But for running and shooting... it was great. The "New York Minute" mode was a blast. The bullet time was excellentely implemented, even if it too was by that time a cliche.
Anyhow, the writing was so outrageous that my wife (a graduate of comparative literature) actually got into it too, for the shere unbelievable level of cheesiness of it. I'd go around shooting everything, but i'd be calling "hurry!" to her when a cut scene was coming. And we'd sit together laugh and laugh, and groan and groan at what idiocy would come out of Max's lips next...
It was a lot of fun.
But I'd never, ever, ever, sit through a movie of it. Not conscious, at least.
KOffice's new "Kexi" aims at this. And looks like it might eventually even be half decent as well (depending how comprehensive and well the report tools integrate).
Grim Fandango was fantasic. The plot was cliche, but still the world and details (and final scene!) were incredible. The production was pure class, as you say.
For another similar game which is quite recent, weak story, but amazing details... Syberia. Also Syberia 2 is coming.
DOTT is still the best there has been though, alas.
4) Companies, as a matter of practice (but not without exception) are soley there to make money
There's the problem. That this point of view is even entertained as the most bizarre fancy, let alone taken for granted in society. If you care at all.
But that's okay. I'm personally willing to do better work than you for at least $5 per hour less. So happy starving, noble martyr for the cause of commerce and fat ass CEOs.
Good God, mysql doesn't have intervals either? I never even realised how much i take intervals for granted in postgresql until i read this. It's hard to imagine life (for very long) without them.
But of course it's probably just another thing mysqlers will claim that "90% of people would never use anyhow". Well, 100% of mysqler's, anyhow.
I was going to d/l this to have a boo at it, but the soulless, utterly expressionless, faces on the web site graphics frightened me off. (I'm having enough nightmares today about soulless heads of state.) Perhaps some story could overcome this impression if I gave it a chance; but the fact that the only selling point on the site is the supposed "photo realism" angle, it doesn't really inspire any hope.
(PS. against all odds, i actually really liked the FF movie, though, for some reason even I have a hard time figuring out).
Having browsed this thread I notice there are certain common arguments frequently employed to defend mysql. But what kind of defense are they?
Its good enough for 90% of the web applications out there. However. 90% of the web applications out there are moronic, programmed by people without clues. This is a defense?
Similar to above: Most people have no need for the "advanced features" of ACID databases. However, most people actually don't realise what excellent use those tools frequently are, and with mysql they will never have a chance to learn them.
People don't always chose software purely on technical merit. One poster actually (apparently defending MySQL) held up microsoft as an example for this. I think this previous "defense" shall by the only comment I will make on this point.
Mysql is blazing fast. This has been debunked so many times, it is just tiresome to do so again. I'll merely rephrase another reply in this thread: sure, because it doesn't have to do half the things a real database does to ensure integrity, and functionality. Nearly any database server can be tuned for speed by disabling (or just not using) features, and proper index maintenance. Mysql on the other hand, can't be tuned for the features it is missing.
Mysql is easier to use. In my experience as a database hosting provider, pretty much the only reason this seems to be true is because unfortunately the majority of users got their feet wet in mysql first, and their brains apparently became irrevocably corrupted from the experience; they no longer are able to recognise the proper way of doing things even when it is shown them.
None of the above is new information. Just my personal summary. In short, (ie. in troll) the argument seems to be simply: "Yes, mysql is pathetic, but so are most of us." Great.
Good grief, MySQL 5.1?! I just scurried over to mysql.com to check this out. As I thought... 4.x isn't even released yet (the download page says 4.0 is "gamma", and 4.1 is "alpha"), and already the myfanatics are flaunting the 5.1 features?!
Based on this, I think the big boys should definitely be afraid of mysql. Mysql, it seems, is blowing them all away in the vapourware arena!
Background vacuuming is on the TODO list. You're probably aware that as of version 7.2 vacuuming no longer requires table locking, so it seems quite feasable to vacuum in the background to me. There is also a 3rd party daemon available which will automatically vacuum tables based on a configurable activity threshold (i've never tried this though).
Not really an IDE, but GForge (the opensource fork of SourceForge), which certainly is a collaborative development system, had some discussion about add Jabber support. I'm not sure what the nature of the support is, but it appears there must be some as they have a link to jabber on their main page.
Though I don't know a lot of the implementation details, this sounds fairly similar to the Zope Object Database (ZODB) which the Zope application is built on top of. There is also a standalone distribution for it, to work with any Python program. It is an object database, serialised to disk. While normally everything is serialised to disk fairly quickly I believe there are memory cache (and thread) settings which can be used to optimise the speed.
I read the whole article, and while at points I wondered why i was wasting time on such a long pointless piece, in the end I was very glad I did. The ironies within ironies within ironies contained in this tail... were amazing. The obvious ironies like the bit about Loebner co-opting Minsky's "prize" to be a part of his own. Brilliant. The irony of Loebner suddenly comparing identifying sexual discrimination against his associations with that of those against Turing! Awesome. All of this irony-within-irony monkey business leading finally up to the ALICE bot creator (and prize winner) who denies there is likely any human intelligence let alone computer intelligence. Fascinating irony of ironies! And of course over all wrapping irony of the seemingly childish behavior of virtually everyone... the article was called "Artificial Stupidity", but could easily have been reversed as: "Stupid Artificiallity".
Even if the whole story was biased and proved to be a pack of lies, it was excellent writing, well worth the read, and worthy of much ironic ponderance on many levels.
They say one of the signs of intelligence is a sense of humour. Obviously most of the commentators here failed to intelligently read this piece.
Have no fear, dear Joe D.! Relax. It was just the line they give to emotionally mollify the incredulous masses. They'll make sure their tech gets spread as widely and as evenly as possible, and we'll all be getting calls from them (if the thing actually works). No doubt their announcment at that time will contain some mumbo jumbo about free speach, etc. Yawn.
You guys all forgot what may well be recognised in the future as some of the most innovative (for the time) 3D technology broadcast on television. I speak of none other than "Dr. Tongues 3D House of Stewardesses" (can't remember if that one was shot also in smell-o-rama, or not?). With SCTV's amazing technology you didn't even need the special glasses (sorry, Count Floyd) to enjoy the startling realism and eye-poking drama.
(P.S. Why oh why are none of these classics to be found on any P2P network? Just a bunch of file sharing hosers out there, it seems, alas).
Actually Lotus's Ami Pro was the best word processor at the time, and for functionality pre-dated these other upstarts in the GUI word processing field. God only knows why Lotus fumbled with their amazing products so badly.
That's funny, all this time I had been under the impression that Linux is for kids! I mean, with that ridiculous puffy cartoon penguin plastered embarrassingly everywhere, surely no one takes it seriously?
Slashdot Mirror
A lot of mysql people seem to complain about the lack of the nonstandard "show tables" type commands in postgresql. But "show tables" being non-standard means you had to read the documenation to find that. If you read the postgresql documentation also instead of expecting postgresql to have the mysql non-standard extensions you'd find that in fact postgresql is much more flexible and powerful when it comes to finding system information.
It's pretty bad with your system won't boot at all unless you (i'm amazed i found this info at all) tweak the kernel to turn off DMA on the hard drive during boot up).
I had other problems as well. It seems just certain hardware causes problems. Others have no problems. My problems were so severe though, I heart brokenly was contemplating the descent back to the blessed safety of STABLE-land...
But first I figured i'd give the latest snapshot build a chance... i snagged a small ISO and put it on an RW... installation went smoothly... and all my problems disappeared!
I was hoping that 5.0 would be stable enough to install on a dev server, but my experience scared me significantly. Even though the snapshot I now have installed is running like a dream... still i'm too nervous about using this now on any non-home server.
But, if the progress they've made between 5.0 and the snapshot i have is any indication of the rate of progress being made, maybe i'll give 5.1 a shot in a few more places... whilst still looking forward to a hopefully STABLE tagged 5.2.
When I first started into Max Payne I could barely tolerate the dialog. It was soooo bad. It is predicable that some here would stick up for it and try to convince us it was good, using various arguments. I don't buy the "parody" argument. Nor do I buy the "cleverness"... though it was occassionally clever merely in pushing cliche seriously to a new level (if the writers were really clever then they would have come up with some cleverness in the plot rather than cliche after cliche turns of events).
Anyhow, the actual game play was very nice. The controls were annoyingly simplified at first compared to other FPS's.... But for running and shooting... it was great. The "New York Minute" mode was a blast. The bullet time was excellentely implemented, even if it too was by that time a cliche.
Anyhow, the writing was so outrageous that my wife (a graduate of comparative literature) actually got into it too, for the shere unbelievable level of cheesiness of it. I'd go around shooting everything, but i'd be calling "hurry!" to her when a cut scene was coming. And we'd sit together laugh and laugh, and groan and groan at what idiocy would come out of Max's lips next...
It was a lot of fun.
But I'd never, ever, ever, sit through a movie of it. Not conscious, at least.
These constant dupes, from no less than the founder of the site, are just depressing.
For another similar game which is quite recent, weak story, but amazing details... Syberia. Also Syberia 2 is coming.
DOTT is still the best there has been though, alas.
It would be interesting if there were a site like this which would also compare with alternate GUIs from the same period.
There's the problem. That this point of view is even entertained as the most bizarre fancy, let alone taken for granted in society. If you care at all.
But that's okay. I'm personally willing to do better work than you for at least $5 per hour less. So happy starving, noble martyr for the cause of commerce and fat ass CEOs.
But of course it's probably just another thing mysqlers will claim that "90% of people would never use anyhow". Well, 100% of mysqler's, anyhow.
They don't know what they're missing.
(PS. against all odds, i actually really liked the FF movie, though, for some reason even I have a hard time figuring out).
None of the above is new information. Just my personal summary. In short, (ie. in troll) the argument seems to be simply: "Yes, mysql is pathetic, but so are most of us." Great.
PostgreSQL has vast searchable "interactive documentation" as well.
Based on this, I think the big boys should definitely be afraid of mysql. Mysql, it seems, is blowing them all away in the vapourware arena!
Background vacuuming is on the TODO list. You're probably aware that as of version 7.2 vacuuming no longer requires table locking, so it seems quite feasable to vacuum in the background to me. There is also a 3rd party daemon available which will automatically vacuum tables based on a configurable activity threshold (i've never tried this though).
Not really an IDE, but GForge (the opensource fork of SourceForge), which certainly is a collaborative development system, had some discussion about add Jabber support. I'm not sure what the nature of the support is, but it appears there must be some as they have a link to jabber on their main page.
Even if the whole story was biased and proved to be a pack of lies, it was excellent writing, well worth the read, and worthy of much ironic ponderance on many levels.
They say one of the signs of intelligence is a sense of humour. Obviously most of the commentators here failed to intelligently read this piece.
Bzzt! Failed the test. Next contestant please.
Have no fear, dear Joe D.! Relax. It was just the line they give to emotionally mollify the incredulous masses. They'll make sure their tech gets spread as widely and as evenly as possible, and we'll all be getting calls from them (if the thing actually works). No doubt their announcment at that time will contain some mumbo jumbo about free speach, etc. Yawn.
(P.S. Why oh why are none of these classics to be found on any P2P network? Just a bunch of file sharing hosers out there, it seems, alas).
Don't be silly; that's step 1. in the case of microsoft. All else follows...
Actually Lotus's Ami Pro was the best word processor at the time, and for functionality pre-dated these other upstarts in the GUI word processing field. God only knows why Lotus fumbled with their amazing products so badly.
(Wheee! my first troll!)