- editor vs ide
- multiple files
- shell commands
- file searching
- random vim tips
- learning & tutorials
- wrap up
Read: vim »
atom is a "hackable text editor for the 21st century" created by the team at github. it's designed to be customizable, but also usable without needing to edit a config file.
this quote really sums it up perfectly:
Read: atom editor linux install »
cron jobs are automated scripts that run at a specified date/time, or on a specified interval.
anything that can be executed in the terminal on the server can be run as a cron job (this includes commands, applications, scripts, etc).
crontab is the command used to create/view/modify/remove cron jobs.
- crontab -l lists all scheduled jobs
- crontab -e allows you to edit jobs
- crontab -r will delete *all* your active jobs!
once the crontab file has been edited the cron daemon will automatically read it and update it's job que to match the file. you should see the message:
crontab: installing new crontab
Read: cron jobs »
git is a distributed revision control and source code management (SCM) system with an emphasis on speed. git was designed by linus torvalds, of linux fame, for managing the development of the kernel. every git working directory is a fully fledged repository, complete with revision tracking abilities independent of a network or centralized server. git is 100% open-source, freeware, and distributed under the GNU general public license v2.
Read: git with the program »
sometimes you find the need to do mass string replacements in your mysql/maria databases. here's how i do it:
SET your_field = REPLACE(your_field, 'old_value', 'new_value')
WHERE your_field LIKE '%old_value%'
the Bioregenerative Life Support System Simulator, BLiSS Sim, is an ipad app, built with titanium studio, based on investigations conducted by NASA scientists and engineers to explore how plants can be grown to provide air, water, and food for astronauts at a lunar base.
BLiSS uses a game format to engage youth and adults in the challenges of supporting humans in space or extreme environments on earth.
The app is free and available for download from the iTunes Store.
Visit the promotional website at: http://bliss-sim.cet.edu/
have you ever had a database table that you needed to clone? you can use any number of convoluted methods such as: manually coping and pasting rows in the database manager, running lots of queries/stored procedures, or writing a script to cycle though each row copying data from one table to the next. all of these methods are inferior and far more complex then the method i'm going to show you.
introducing the select into query...
this method should be used if the table you want to clone exists, but the new table douse not. the select into query will create the new table for you, copying all the column names, properties, and data. if you want to make an exact clone of the table you can select * into the new table. but if you only want a few specific columns, you can declare only the ones you want. the syntax is elegantly simple...
SELECT * INTO [new-table] FROM [old-table]