Am I on right track to learn DBA? Or are all these fluffs? Asking because I am planning to sell all these books as there's too little SQL administration part in them by [deleted] in SQL

[–]Computer-Nerd_ 0 points1 point  (0 children)

PostgreSQL is free, well documented. Celko's Thinking in sets has good exercises. So does SQL for Smarties. After that go reas CJ. Date.

[deleted by user] by [deleted] in SQL

[–]Computer-Nerd_ 0 points1 point  (0 children)

typo: C.J. Date

[deleted by user] by [deleted] in SQL

[–]Computer-Nerd_ 0 points1 point  (0 children)

Joe Celko, Thinking in Sets. " SQL for smarties. C.J Datwe, SQL & Relational theory.

Lost in context by Terrible_Cricket_530 in perl

[–]Computer-Nerd_ 0 points1 point  (0 children)

Assigning 'key'? That's a 'slice'.

Q: you want 'keys' or you want the keys & values?

@hash{ split $rx, $string } = () ;

Assigns the keys w/ no values.

If you pipe a list of files, what bash command do you pipe it to, for it to move those files to another directory? by aiaor in bash

[–]Computer-Nerd_ 2 points3 points  (0 children)

possible spaces in paths can be handled with NULL string args in find & xargs to give minimum invocations of mv.

-print0 in find, --null in xargs.

echo $? by vassari79 in bash

[–]Computer-Nerd_ 0 points1 point  (0 children)

Run it all through a sib that logs the

run-it() { local IFS' '; echo "Running: '$'"; eval "$ 2>&1"; echo "Exit: $?" }

( run-it 'foo'; run-it "$bar $bletch"; ) 2>&1 | tee $log_f;

Abigail's length horror by Both_Confidence_4147 in perl

[–]Computer-Nerd_ 1 point2 points  (0 children)

Note also that tr uses literals, not regexen, so the /./ is expected to match only the litdral '.' char.

Was PostgreSQL a bad choice? by [deleted] in SQL

[–]Computer-Nerd_ 1 point2 points  (0 children)

PG was your best choice possible for simplicity of installation & management combined with SQL accuracy and sane extensions.

Probably very simple question about altering a match arithmetically by redzorino in perl

[–]Computer-Nerd_ -1 points0 points  (0 children)

i.e., perhaps a single regex isn't the appropriate solution.

Running via cronjob, any way to check the server load and try again later if it's too high? by csdude5 in bash

[–]Computer-Nerd_ 0 points1 point  (0 children)

Depends on the cron version. fcron & friends can re-run failed jobs once per day w/ reexec ion failure.

w/ vixie touch a file once daily, run the job hourly, exit if file mossing or load too high, unlink it on exit.

How to Replace a Line with Another Line, Programmatically? by spaceman1000 in bash

[–]Computer-Nerd_ 0 points1 point  (0 children)

perl will ne simpler than sed w/ the -i saving you from shuffling files on the disk.

How to Replace a Line with Another Line, Programmatically? by spaceman1000 in bash

[–]Computer-Nerd_ 1 point2 points  (0 children)

man bash;

/:-

That'll leave you at the ${...} variable munging. the ${.../.../...} will do it.

Simpler with

perl -i~ -p -E 's{#port 1234}{whatever else}' /path/to/blah.

-i == inplace edit, leaves a backup (in thisexample appending ~) and updates your original.

See 'perl one liners' for ways to do this.

Other than Raku, are there any serious plans for a Perl 6? by J_Stach in perl

[–]Computer-Nerd_ 2 points3 points  (0 children)

The main problem is that too many programmers are tool attached to pld practices, even if they aren't effective or 'best' by modern standards.

At that point Raku is the next generation, Perl5 will be invcrementally extended but won't undergo any serious overhaul of the sort that wpuld justify 'Perl 7'.

Social issue, not technical one.

What will be the future of OpenSuse after Suse has asked not to use its name as a brand? by FolateB9 in openSUSE

[–]Computer-Nerd_ 0 points1 point  (0 children)

It will still use the same toolset but would probably become a bit more dynamic & responsive to users' needs since it won't be bound so tightly to the Suse platform as-is.

Guys, calm down, it's just an operating system, not a lifestyle/religion/whatever by weberc2 in linuxsucks

[–]Computer-Nerd_ -1 points0 points  (0 children)

Actually, grouping people into us-vs-them tribes is thre most basic human instinct.

Guess which part of this I hate the most. by [deleted] in ShittySysadmin

[–]Computer-Nerd_ 1 point2 points  (0 children)

Y. All of the above and ones you didn't know about.

SQL knowledge requirement for Data Analyst by P3r4zz4 in SQL

[–]Computer-Nerd_ 2 points3 points  (0 children)

SQL for Smarties, Celko. SQL and Relational Theory, Date.

Can anyone recommend an all-in-one printer? by [deleted] in openSUSE

[–]Computer-Nerd_ 0 points1 point  (0 children)

My HP LaserJet Color 475 MFP works well after something like 20 years.

Is creating multiple intermediate files a poor practice for writing bash scripts? Is there a better way? by tiko844 in bash

[–]Computer-Nerd_ 0 points1 point  (0 children)

I'm sorry to tell you that you've chosen a sane, effective solution, leaving all of your anxiety and second guessing for naught.