I think constants are evil (just joking but….I will explain why). I am tired of seeing a lot of Java classes filled with the same constants repeated over and over again, instead of collecting them in a common file, which in C Language was called include files (ooooah!). Sometimes it is impossible to understand if …
In the 1980 comments were used to reduce the “gap” between unstructured code and “rationale” behind the code. C/64 Peek and poke where oscure. Gosub on function pointed by numbers was bad 8-bit systems was tight on command names and so on (think to write a python interpreter in Arduino/bbc:Micro, or look at the memory …
Sometimes you need to remove nasty duplicate on a table, based on a subset of the column. On every big database there is something called “rowid” which can be used to indentify a column in a unique way. On PostgreSQL is called ctid, as we shall see: Oracle way:
|
1 2 3 4 5 |
DELETE FROM your_table WHERE rowid not in (SELECT MIN(rowid) FROM your_table GROUP BY column1, column2, column3); |
Postgresql equivalent is ctid, so …
Removing duplicate rows in PostgreSQL, Oracle and SQLite Read More »
I have used Google in the past 8 years (I know, I am a bit old). Then I was annoyed because of a bad behavior of Google with my AdSense account (shutdown without being able to talk back to someone for explanation). In the last month I tried Bing and I was happy with it. …
Steve is not a normal solution provider.
Steve is the final destination for Project Management troubles.
Let’s see how Steve can solve problems
