|
I've been quite pleased with Postgres. While many of the points in that article seem like minutiae to me, I will say that it is painless to install (can't say that for SQL Server and all its variants running on my computer), it's easy to connect to (again, I've fought all sorts of TCP/IP, Pipe, etc. crap trying to connect to SQL Server), there's a free .NET client, and again, I've never had problems connecting to a database in pgAdmin, while I've had nightmares trying to get the path exactly right in SSMS, verify that right services are running (or not), etc. etc.
The one thing that I don't like about pgAdmin is that it's 6 clicks to drill down from "Databases" into the specific database schema table collection.
And I've got Postgres installed on my Beaglebone Black. How cool is that?
Marc
|
|
|
|
|
Kent Sharkey wrote: SELECT TOP 1;
 That's so last century.
SELECT ... FROM ... ORDER BY ... FETCH FIRST 1 ROW ONLY
|
|
|
|
|
It gets even better, PostgreSQL supports ranges, so you can do this:
SELECT …
FROM …
WHERE (time_stamp, id) < (?, ?)
ORDER BY time_stamp DESC, id DESC
FETCH FIRST 10 ROWS ONLY So you get paging that's always the same speed no matter what page you are on. Well, assuming that you have an index on time_stamp, id
Wrong is evil and must be defeated. - Jeff Ello
Any organization is like a tree full of monkeys. The monkeys on top look down and see a tree full of smiling faces. The monkeys on the bottom look up and see nothing but assholes.
|
|
|
|
|
Postgres is excellent, but this review made me barf - there was no attempt to create a balanced view, no instrumentation to back up claims, and generally a lot of MS bashing.
Should try harder.
"If you don't fail at least 90 percent of the time, you're not aiming high enough."
Alan Kay.
|
|
|
|
|
I was fine with his, admittedly biased, arguments until he threw in a curve-ball and introduced christians and muslims in there, and his quote that 2.7bn people are wrong. I'm now trying to work out whether he thinks that's the number of SQL Server users, or the religious count. Either way, it really had no place in the post.
|
|
|
|
|
No sync placeholders in Windows 10; testers accuse company of again not heeding feedback. You can't please all the customers, all the time
|
|
|
|
|
Don't ever put all your eggs in one basket, especially if you don't control the basket.
|
|
|
|
|
Welcome to the cloud 
I foresee a great future for coders, writing and rewriting the same stuff over and over again.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Sources for the Financial Times understand that the internet giant is developing "Facebook at Work," a professional take on its familiar formula. No. No, no, no, no NO. No.
|
|
|
|
|
Yeah, ain't gonna happen.
|
|
|
|
|
|
Microsoft has collected all the stats about its products and services into a report which was released on November 13th. These numbers provide insight into the massive amount of users Microsoft has across the company. "All the lonely people, where do they all belong?"
|
|
|
|
|
Is Windows really used by 1.5 billion people? Or are they talking merely about "licenses sold" here? I mean, how do you accurately count the number of people using Windows? What about people with multiple devices? What about the people using pirated copies? I know, it's all about the money in the end, so 1.5 billion licenses sold is 1.5 billion licenses sold. But it doesn't mean there are 1.5 billion people using them. It's maybe more, due to piracy, but most likey less than that.
|
|
|
|
|
Code-Fight.Club is a project built by Andrew Hathaway with the aim to help fellow developers learn how to write their code in the nicest, most efficient and preferred way they can. To decide which code is the most preferred way, users can comment and vote against a fight for their favourite contender. We support 84 different languages, a mix between programming languages and templating syntaxes, be sure to look through the list. The first rule of code-fight club is... uh, forget I mentioned it
|
|
|
|
|
Becoming a Microsoft Certified Professional is no easy task, let alone if one is only 5 years old! But that’s exactly what young Ayan Qureshi managed to accomplish. Something to think about next time you want to put MCP on your business cards
|
|
|
|
|
|
|
|
|
Think about it; and think about it carefully. Nothing happens in our society without software. Nothing. "With great power comes great responsibility"
|
|
|
|
|
Interesting reading with some very good points. In fact something that should be thinked about very slowly.
Thanks
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Very nice. However, I take offense with this statement:
Our software will be well-written for it's purpose and lifetime.
Everyone knows it should read:
Our software will be well-written for its purpose and lifetime.
/ravi
|
|
|
|
|
Uncle Bob wrote: We write the rules. We hold the strings. Now we have to decide what to do with them.
Hum. Let's not abuse them.
Wonde Tadesse
|
|
|
|
|
He makes some good points, but there are some massively hubristic claims there. Programmers don't rule the world (at least no more than any other relatively useful profession such as surgeons or automotive engineers).
The idea that we could all unite and hold the world to ransom is ludicrous.
|
|
|
|
|
Without software: Phones don't ring. Cars don't start. Planes don't fly. Bombs don't explode. Ships don't sail. Ovens don't bake. Garage doors don't open. Money doesn't change hands. Electricity doesn't get generated. And we can't find our way to the store.
You know, all that worked before software, before transistors, and money certainly changed hands even before electricity. As to finding our way to the store, there's this archaic concept of actually communicating with your fellow man and asking directions.
And when the earth gets a direct hit from a sufficiently powerful CME (which is inevitable) will all discover again how to ask directions, grow our own food, and spin wool.
Marc
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
