we use one from inetsoftware.de, which we have found to be pretty solid. Certainly more solid than the mySQL driver (sorry,havent done enough with the postgres one to know)
You are right that the MS one isnt really up to it yet though.
OK, firstly, the disclaimer. I dont know everything there is to know about all of these databasen, and have spent far more time on SQLServer than anything else.
SQLServer has somethings that are just wonderful, for me as a developer. Enterprise manager is quite simply, fantastic. The comparison to Oracle's equivalent is rather... amusing. I havent used postgreSQL's configuration tools much. I also like to be able to run my queries, and it gives me a nice big table that shows where it is spending its time, were there any row scans, and please, sir, can you suggest any indices I'm missing? We will be doing an installation of our product soon that will be really seriously stressing the software, 100s of (web)requests per second. This is java talking to SQLServer. We can cluster the SQLServers if need be.
MySQL is an interesting one. It really is designed for a different purpose, to be a fast, file based database. It really can't cope with the mission critical type installations, but is excellent in its domain.
I dont have performance benchmarks, but for me, SQLServer has an overwhelming number of tools and works, very very well. In my experience, that there can be an entire job title called "Oracle DBA", speaks volumes about how easy it is to administer.
Im just the poor monkey, i dont make the decisions about whether servers should be "open" or not, all that I really care about is if the driver always works, the DB always goes fast, and there are some nice and easy tools for me to use.
show that there are free alternatives that works as well as SQL server.
Ive used all three databases you mention. Without a doubt, SQL Server is by far the "best" database. I think you do have to temper what you say, because if you run around making statements like that, then it puts doubt on the other things you say.
I dont mean to cast dispersions on MySQL or PostreSQL, they are very good databases, but not in the same league as SQLServer, IMHO.
Heh, i had a PcTel winmodem, and an S3 Virge video card. I had been having intermitten connection problems, and finally traced it to the combination of those two. The video card saturated the PCI bus, leaving not enough bandwidth of the damned modem, which would then promptly hangup.
Ever since that fiasco, i started actually looking at what i was buying, though it seems to be impossible to get a non win PCI modem these days.
Just as well we have the good ole external DSL modem now:-)
Why is it that for code to be secure, it must be open, accessible, visibile for everyone to see, yet for real physical security, it seems like a terrible thing when the authorities want to do just this, allow more recording of what people are doing?
Arent these two ideals in total contradiction to each other? what am I missing?
IE 5 and upwards have an XSLT engine, though the IE 5.0 one is a little rough still. We are using it in a project i have been working on recently, but have had to supply an upgrade of the XSLT engine for the 5.0 browsers out there.
You can even get your XML directly out of a SQLServer database (via IIS for, ahem, security..:-) ), and then perform the XSLT in IE, or if you prefer, it can be done serverside instead. It's quite bare bones, but it works. A little annoying that you cant (AFAIK) find out the html that it produced...
Ask yourself if Microsoft would have turned Windows 2000 into Windows 2001 if a significant security hole was found on the eve of the launch.
They claim that with windows 2000, they didnt ship until there were no known security holes. Dont know about winXP. Do recall that windows 2000 was significantly later than they had been touting.
Heh, well, that was useful. Convert it from a decent unit to a confusing one...
Now, the question on everyone's lips is...
What is that in (gallons)^1/2 / (century * sqrt(lightyears) )?
There was a comic moment in there
on
Time Travel
·
· Score: 2
But Alan Guth, a physics professor at MIT who has studied the theory of time machines, says he isn't sure it's even theoretically possible to travel through time. As far as whether time travel is a possibility, he says: ''Definitely not within our lifetimes.''
Dr. Guth, do I detect the hidden talents of a comic physicist?
Slashdot Mirror
About a DIY operating system, but I'm danged if I can remember what it was called.
He probably meant 1000l at atmospheric temperature and pressure.
Who modded this as insightful? It's a joke.
More or less, i think so too :-). But oracle is pretty much top of the pops, so that probably isnt a bad thing.
You are right that the MS one isnt really up to it yet though.
SQLServer has somethings that are just wonderful, for me as a developer. Enterprise manager is quite simply, fantastic. The comparison to Oracle's equivalent is rather... amusing. I havent used postgreSQL's configuration tools much. I also like to be able to run my queries, and it gives me a nice big table that shows where it is spending its time, were there any row scans, and please, sir, can you suggest any indices I'm missing? We will be doing an installation of our product soon that will be really seriously stressing the software, 100s of (web)requests per second. This is java talking to SQLServer. We can cluster the SQLServers if need be.
MySQL is an interesting one. It really is designed for a different purpose, to be a fast, file based database. It really can't cope with the mission critical type installations, but is excellent in its domain.
I dont have performance benchmarks, but for me, SQLServer has an overwhelming number of tools and works, very very well. In my experience, that there can be an entire job title called "Oracle DBA", speaks volumes about how easy it is to administer.
Im just the poor monkey, i dont make the decisions about whether servers should be "open" or not, all that I really care about is if the driver always works, the DB always goes fast, and there are some nice and easy tools for me to use.
Ive used all three databases you mention. Without a doubt, SQL Server is by far the "best" database. I think you do have to temper what you say, because if you run around making statements like that, then it puts doubt on the other things you say.
I dont mean to cast dispersions on MySQL or PostreSQL, they are very good databases, but not in the same league as SQLServer, IMHO.
Or something like that.
Yes, i suppose that is a major difference. Thank you.
Ever since that fiasco, i started actually looking at what i was buying, though it seems to be impossible to get a non win PCI modem these days.
Just as well we have the good ole external DSL modem now :-)
Arent these two ideals in total contradiction to each other? what am I missing?
Sun sells big servers.
Sun wants people to buy more servers.
You dont run swing on a server.
Sounds painful.
It is interesting, regardless of a knee-jerk downwards moderation for promoting christianity.
I can just image in it, though, the clash of titans, it would be fun to watch :-) I think they need a celebrity death match on this topic myself.
Win2k has always been very good for this. Use windows scripting host if there isnt a command line tool for everything.
Any other countries bursting with people to work from home?
Yeah, well pity the site's gone down so we can't check.
You can even get your XML directly out of a SQLServer database (via IIS for, ahem, security.. :-) ), and then perform the XSLT in IE, or if you prefer, it can be done serverside instead. It's quite bare bones, but it works. A little annoying that you cant (AFAIK) find out the html that it produced...
They claim that with windows 2000, they didnt ship until there were no known security holes. Dont know about winXP. Do recall that windows 2000 was significantly later than they had been touting.
Whether you see this as a good thing or a bad thing depends on your point of view.
bigger than yours.
Now, the question on everyone's lips is...
What is that in (gallons)^1/2 / (century * sqrt(lightyears) )?
Dr. Guth, do I detect the hidden talents of a comic physicist?
there appears to be no britney pic on that one.
No doubt emacs will support this functionality soon.