|
I am a Microsoft developer but have to use PostgreSql for some things. I had to restore a database and in Microsoft Sql Server you just right-click, Restore, pick your file and done. Simple.
In PostgreSql you have to first create a database and then right-click the database and restore a backup into the new database. Seems backwards and non-intuitive. Then in the restore options they have a section of negative boolean fields. I hate negative booleans. 
I also had underscores in the name of my database and was getting a weird error restoring the backup. I finally removed the underscores and the backup restored into the new database fine.
Social Media - A platform that makes it easier for the crazies to find each other.
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.
|
|
|
|
|
ZurdoDev wrote: In PostgreSql you have to first create a database and then right-click the database and restore a backup into the new database. Seems backwards and non-intuitive.
Both ways are logical enough ("get a container/object/variable, then put stuff in it" happens all over the place, in programming), so it just depends on the logic preferences of the app's developers.ZurdoDev wrote: in the restore options they have a section of negative boolean fields
This, on the other hand, is completely unforgivable.
The number of heads I've had to pound "Say what IS, not what is not!" into goes beyond counting.
Misusing negatives happens all over, though. If you use VLC (one of the best apps around), and have the audio or a subtitle running out of sync, there are hotkeys for "delay up" and "delay down", so if it's early, you have to press a key to increase the delay, etc.
Making the delay number bigger moves the audio/subtitle backward, and a negative number moves it forward: -0.4 seconds is 0.4 seconds in advance! It does your bloody head in, when you're trying to read lips and make the voices sync with them!
I'd love to meet the dev who thought that was logical, and introduce him to the logic of cricket-bat diplomacy.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
Mark_Wallace wrote: Making the delay number bigger moves the audio/subtitle backward, and a negative number moves it forward: -0.4 seconds is 0.4 seconds in advance!
Seems perfectly logical to me.
If your train is delayed by four minutes (+4), it turns up four minutes after the scheduled time. Make the number bigger, and the train turns up later. Make it smaller (or negative), and the train turns up earlier.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Back when I was on the clock I'd tell people if I'm say 10 minutes late for work (+10 min) then I made up for it by leaving 10 minutes early (-10 min).
They just didn't get it. Why??? Zero time difference = leveled out fair and square, right or no?
It's really effective when you're say an hour late; I certainly felt much more ...at peace. 
after many otherwise intelligent sounding suggestions that achieved nothing the nice folks at Technet said the only solution was to low level format my hard disk then reinstall my signature. Sadly, this still didn't fix the issue!
|
|
|
|
|
My motto is if you can't be punctual arriving then at least be punctual leaving.
"They have a consciousness, they have a life, they have a soul! Damn you! Let the rabbits wear glasses! Save our brothers! Can I get an amen?"
|
|
|
|
|
Yes, it's perfectly logical that making a delay smaller moves something forward in time.
The problem is in figuring out which key you're supposed to hit when you're twisted awkwardly to look at the image on the wall while you're doing it, and you're trying to align lip movements (which are either early or late) with sounds.
"Pressing this moves the number backward so it moves the sound synchronisation point forward" is really not helpful -- particularly since, if you're into plus seconds, there is no delay to adjust!
Of course, the root cause and underlying problem is that developers think they're logical[^]
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
That's a minor nag compared to other things that are much simpler with PostgreSQL, like the database installation and distributing the database with your application.
I worked for years with SQL Server and never regretted switching to PostgreSQL 
|
|
|
|
|
The biggest advantage of that DB-server is that it is available for free, on a free OS.
Currently reading an article that explain CLR-integration for Sql Server on Linux. Still need a Windows machine for SQLSMS.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
Eddy Vluggen wrote: Still need a Windows machine for SQLSMS.
Have you tried Azure Data Studio[^]? It might do what you need, and it runs on Mac and Linux as well as Windows.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Richard Deeming wrote: Have you tried Azure
No.
I have nothing in the cloud. I'm a developer; I'm not going to outsource data. It is in BCNF (3NF+), protected with one-time-pads (technically guaranteed unbreakable).
Sql Server runs on a Pi, costing you less than 50$, with (scientifically) guaranteed privacy. You can hook up multiple for that money to guarantee uptime.
Then again, Azure is cheaper than I am, and rightfully so 
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
Except he didn't ask if you tried Azure, but Azure Data Studio which is "...a cross-platform database tool for data professionals using the Microsoft family of on-premises and cloud data platforms on Windows, MacOS, and Linux."
Save us your anti-cloud speech, it has nothing to do with the good advice Richard gave you 
|
|
|
|
|
Sander Rossel wrote: Save us your anti-cloud speech, it has nothing to do with
Oooh, no problem.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
What software are you using to do and restore the backup? I've found that DBeaver works well enough for that.
|
|
|
|
|
pgAdmin
Social Media - A platform that makes it easier for the crazies to find each other.
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.
|
|
|
|
|
Is a cow that gives birth decalfinated?
Nobody said a theme has to last all week, did they?
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
You're in a fine mooooood...
/ravi
|
|
|
|
|
I expected you to milk the theme longer than that.
|
|
|
|
|
I don't like to be that predictable, old bean!
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Are you afraid you might brews your reputation?
|
|
|
|
|
well they say it's always better not grind it for too long
after many otherwise intelligent sounding suggestions that achieved nothing the nice folks at Technet said the only solution was to low level format my hard disk then reinstall my signature. Sadly, this still didn't fix the issue!
|
|
|
|
|
How do you come up with these, bovine intervention? You must spend heifer day thinking of these. They are udderly ridiculous.
"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment
"Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
|
|
|
|
|
There's a time and a placenta for those types of comments.
(I'll steer in a new direction: work on something using 'the cow was caffeinated by a bull).
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
You'd better stop being udderly ridiculous about this, or someone's going to have their teats in a wringer about it.
Software Zen: delete this;
|
|
|
|
|
Just about everything about Office 365 sucks, in my opinion. Teams, Outlook, etc. Slack, for example, is so much more intuitive and easy to use. Take the example of adding another person to a chat conversation. You'd think the button would be over on the left side where the list of people are. No. It's on the far right, in the "conversation" section of the window. And it's a tiny and obscure icon. You'd think maybe right-clicking on the current person would bring up a "Would you, dear user who knows better than me, like to add another person to this conversation and can I do that for you as easily and simply as possible?" But noooo. And don't even get me started on the pathetic space utilization of the conversation window itself, where it seems the Microsoft UI designers have a specific psychological disorder to left justification, to maximizing width, well, to about anything that actually is visually usable. It seems like they are still designing for 640x480 EGA on 30lb CRT's.
Or simple things like, ok, I click that icon. Does the cursor position itself on the edit box where I can type in the name of the person I want to add? No. So all that typing I just did went into the lost keystroke bitbucket alongside dirty socks. Click on icon. Click on edit box. Sigh.
But to my point -- I often find an email by some keyword because I don't remember the person's name or email address (infrequent emails spanning several months), so I find the relevant email, hit reply, and edit the subject line.
Except I can't edit the subject line. Outlook doesn't let you change the subject like on a reply. WTF??? In GMail, you just click on the subject like to change it. And googling yields nothing useful. Even if it's me, 365 still sucks. 
Office 365 - 365 days a year of annoyance, frustration, sh*tty user interface, yadayadayada
|
|
|
|
|
Outlook 2016 lets me change the subject line on a reply with no problem.
If you're using OWA, then you need to click the "Expand" button to the right of the sender's name - it looks like a double-ended arrow. You can then edit the subject.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
