PostgreSql woes
-
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
-
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!
-
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. :mad: 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.
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 :suss: 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.
-
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 :suss: 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
-
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 :thumbsup:
Bastard Programmer from Hell :suss: 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.
-
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 :thumbsup:
Bastard Programmer from Hell :suss: 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 ;)
Best, Sander sanderrossel.com Migrating Applications to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly
-
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!
-
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 ;)
Best, Sander sanderrossel.com Migrating Applications to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly
Sander Rossel wrote:
Save us your anti-cloud speech, it has nothing to do with
Oooh, no problem.
Bastard Programmer from Hell :suss: 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.
-
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. :mad: 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.
-
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
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!
-
What software are you using to do and restore the backup? I've found that DBeaver works well enough for that.
