Want to read Slashdot from your mobile device? Point it at m.slashdot.org and keep reading!

 



Forgot your password?
typodupeerror
Check out the new SourceForge HTML5 internet speed test! No Flash necessary and runs on all devices. Also, Slashdot's Facebook page has a chat bot now. Message it for stories and more. ×

Comment Re:What about electrical, plumbing etc? (Score 1) 315

Why do you doubt this? Where I live in the US we can do absolutely everything except connect the electric/gas/water lines to the public grid. That connection has to be done by a licensed professional. But once you get past the public interface I can do anything and everything (as long as I have a permit - but those are dead simple to get). If you have any kind of technical aptitude it is dead simple to read and understand the codes and learn how to do all your own plumbing, electrical, etc. work. Have you met the guys who are "professionals"? If those people can learn to do it then so can I.

Comment Re: What about electrical, plumbing etc? (Score 1) 315

Yeah, I don't know. My brother is a union electriction, but prior to that he went to college and worked as an editor for a major newspaper. He decided that he didn't like working in an office and after doing a ton of research decided that becoming an electrician was the best thing for him. He reported that he was shocked at the idiots he trained with and worked with. His advice to me was to read up on it on my own and do my own work instead of assuming any union electrician has an IQ above that of a gnat (himself excepted of course ;-) Now then, if the electrician has an electrical engineering degree, that is another matter.

Comment Re:What about electrical, plumbing etc? (Score 1) 315

Different parts of the US have different laws, but where I live you can do anything you want, except for running natural gas lines, as long as you have the right permits (basically you tell them what you are going to do, pay some money for the permit, and let them inspect it when it is all done).

Comment Re:And the shift to Databases away from Oracle (Score 1) 198

It turns out this is harder than I would have thought it would be. We determined last year that we needed to move off of Oracle to Postgresql (this is just one database for one website that has been hosted on Oracle since 2001). I have been working full-time since last April to make that happen and the project still isn't done. We mainly decided to switch for monetary reasons, but there have been a lot of benefits. Postgres's documentation is head and shoulders above Oracle's. We've found that many things, such as creating a hot-standby replicated database, are far easier in Postgres than Oracle. We've found that our queries are running the same speed or slightly faster. The main thing that has been taking so long is Postgres is so much more strict than Oracle. It's kind of like the difference between strict and dynamic typed languages. I've been rewriting bits and pieces of tens of thousands of SQL statements to get them to work on Postgres. Here is a list of some of the differences between the two:

replace nvl with coalesce

replace rownum = 1 with LIMIT 1

replace listagg with string_agg

replace recursive hierarchy (start with/connect by/prior) with recursive

rewrite the method of doing case/accent insensitive queries.

replace minus with except

replace SYSDATE with CURRENT_TIMESTAMP

replace trunc(sysdate) with CURRENT_DATE

replace artificial date sentinels/fenceposts like to_date(’01 Jan 1900’) with '-infinity'::date

remove dual table references

replace decode with case statements

replace unique with distinct

replace mod with % operator

replace merge into with INSERT ... ON CONFLICT DO UPDATE/NOTHING

change the default of any table using sys_guid() as a default to gen_random_uuid()

oracle pivot and unpivot do not work in postgres - use unnest

ORDER BY NLSSORT(english, 'NLS_SORT=generic_m’) becomes ORDER BY gin(insensitive_query(english) gin_trgm_ops)

replace UNISTR( with U&’

Oracle: uses IS NULL to check for empty string; postgres uses empty string and null are different

PostgreSQL requires a sub-SELECT surrounded by parentheses, and an alias must be provided for it.

any functions in the order by clause must be moved to the select statement (e.g. order by lower(column_name))

Slashdot Top Deals

One man's "magic" is another man's engineering. "Supernatural" is a null word. -- Robert Heinlein

Working...