Two commands.

I was practicing the commands on  SQLite and wondering how to view the tables of my database, I found a way to do it which is (sqlite3 example12.db ".table"). The example12.db is my database and .table is to view the tables in the database.  You will get something similar to this (Actors        ActorsMovies  Cars          cars2   ) depending on what is in your database.

Today also I learn this other command that is  (sqlite3 example12.db "dump"). This command will give you something like this:

CREATE TABLE Actors(AId integer primary key autoincrement, Name text);
INSERT INTO "Actors" VALUES(1,'Philip Seymour Hofman');
INSERT INTO "Actors" VALUES(2,'Kate Shindle');
INSERT INTO "Actors" VALUES(3,'Kelci Stephenson');
INSERT INTO "Actors" VALUES(4,'Al Pacino');
INSERT INTO "Actors" VALUES(5,'Gabrielle Anwar');
INSERT INTO "Actors" VALUES(6,'Patricia Arquette');
INSERT INTO "Actors" VALUES(7,'Gabriel Byrne');
INSERT INTO "Actors" VALUES(8,'Max von Sydow');
INSERT INTO "Actors" VALUES(9,'Ellen Burstyn');
INSERT INTO "Actors" VALUES(10,'Jason Miller');

this will varies depending what is in your database and it could be even longer if you  have more tables in the same database.


I am following this tutorial  and I think that is more useful than this one.

Practicing SQLite

I was practicing SQLite commands from the (.help) this is a command on SQLite that hell you with the commands. Some commands that I practiced are
.schema "table name"(this will told you what the table have in)
Example: schema cars (cars is the  name of my table ).
I get this message CREATE TABLE Cars(Id integer PRIMARY KEY, Name text, Cost integer);
.mode line "then the (select * from  'name of the table')", and you  will get something like this;
Id = 1
 Name = Angela
 Cost = 21

   Id = 2
 Name = Mercedes
 Cost = 57127

   Id = 3
 Name = Skoda
 Cost = 9000

   Id = 4
 Name = Volvo
 Cost = 29000

   Id = 5
 Name = Bentley
 Cost = 350000

   Id = 6
 Name = Citroen
 Cost = 21000

   Id = 7
 Name = Hummer
 Cost = 41400

   Id = 8
 Name = Volkswagen
 Cost = 21600

this will varies depending on what is in your table and what is about it.

I will try to learn more commands this week.

Creat a save a table.

Yesterday I was wondering how to created a table and save it, and today my teacher taught me how to do it. Yesterday I was trying to execute the program (sqlite3) first and then created the table but I didn't know that I new a database file.
The extension of the file you create have to be (.db) which stands for (database).
How you create a database in SQLite?
The way to create it is sqlite3 (name of your file with out parenthesis).db+

SQlite

Practicing the SQLite, i know how to open the table, but I don't know how to open the same table after I close the program and enter again. Tomorrow I will look for a tutorial to see how to do it.
Today I was practicing the command (select * from "name of your table"). This command open what is inside your table named Actors (select * from Actors;) this command will show up names of some actors. But you have to create the table and then execute the command.

SQlite

Yesterday a successful day because I got introduce to this new program SQlite.
I run the program with (sqlite3) just to play around with it and after making some tables about Actors and Movies. After a while wondering how to get out of the program with out closing the terminal,
I try these commands :

exit

.exit;
but this won't work on SQlite. The right commands that will exit the program are (.quit),(.q), and (.exit) . Something new for me was that when you want to execute a command you need a dot at from of the command.

Staring to learn SQLite.

I found a message from my teacher that said something about the SQLite. I don't have an idea what this means or is, but I look on Google.com for tutorial and I found one. This is a tutorial about SQLite, also this other website but I think the first one is better.
I would try to practice, because it looks really interesting. I would try to get some skills on this new topic.

I will ask my teacher for some advice about this.

Reviewing

I was practicing the CSS and HTML codes so I don't forget them but I was looking at the next examples of Linux.I learn how to turn enable the syntax on the terminal.And what is syntax, this is a utility that help you on the terminal by putting the color to the HTML.
How turn on the syntax.
First of all you Type vi vimrc which is going to open a page like this ...

 of course there will not we those letter where is said syntax enable
you have to type the syntax enable, so is on any time you want to view a HTML file in terminal.

New Commands.

Practicing the tutorial I found this two commands, that for me are going to be really useful.
This commands are (mkdir)  and (rmdir). 
Have you ever ask your self what this two commands are. Well the (mkdir) is to created a folder . The (rmdir) is a command that remove a folder of some file. 

(mk-is a abbreviation of make )

(rm- is the abbreviation of remove )

(dir- is a directory which is the same as a Folder)


I will keep learning more about the commands, this is really interesting.


I learn this commands on a video tutorial, that one of my classmates found.
Link: Video

Resize problem and learning Unix commands.

I was trying to fix the error on my application new iRock. There is a issues that when you want to resize the image using the (Ctrl +) the image become smaller and  (Ctrl -) make the image more bigger but I can't fix it. I will look at Google.com to see if I could find a tutorial about how to fix it.
Today I learn some commands which are,
(Ctrl + z) is to get out of a file that u are editing on the terminal and I you want to edit a file  the command is (vim) I was practicing this two commands today. I will practice more commands during this week.

I Finished the application

Today I just could finish the application and not move forward because of the early release.However I make sure that the application was running correctly and not issues.
 The next week I will finish the tutorial about the Linux command that I just star reading like two weeks ago. At the end of that week I hope to be done with that tutorial and here the tutorial I will be Practicing.

iRock.

I am almost done with the new applications of iRock, and I almost finish with the application; however, there is another Function which is (function resizeRock). This is a function that make the rock resize depending on the side of the web browser.

Here is the Line which help you to resize the image of the application.

   function resizeRock(){
    document.getElementById("rockImg").style.height=(document.body.clientHeight - 100) * 0.9;
}


Also remembered to add on this line, the parts that are on red.<body onload="resizeRock(); greetUser();" onresize="resizeRock();">
This commands make the applicationl resize to the side of the browser.
Here is the the link of the new and old applications take a look and when u are on the browser make the browser more smaller and see what happen.
Try to do it in both.

 The new Application with the resize.

This is the regular Application.