2010/11/25

Database Basic - C.R.U.D.


Salam Anak IT readers~ Yes... You...
A lot of people (more than one a.k.a two) were asking me what are required actions to be taken by the database when we develop a system and I was like "apakan?..." hahaha but now I understand apa maksud bisdia ane... So here is my BRIEF explaination...
It actually depends on what kind of system are you developing... Does it require any data? If yes, do you need to record the data? Will the data be used in the future? If yes then of course we need to store the data in a place called "database" and the overall system is called "Information System" since we deal with information... Clear? Blur? Samar-samar? We move on...
Maksudnya atue, there are certain system yang memerlukan informasi and ada yang inda memerlukan langsung for example this "My Personal Alarm Clock" program. Click on it if you asked "apakan tue?" =) Banyak lagi sebenarnya system yang inda memerlukan "stored information" and the best example will be hmmm.... Game Solitaire? Calculator? etc. but mostly games yang canggih-canggih masa ane require database to save the user's information (like name, nickname) as well as their latest achievement/level or even weapon used in the game...
So what are the examples of system that requires information? Have you heard about "Student Information System" where it stores students' information? Book Keeping System? Document Management System? Library System? Store Keeping System? Dan yang sewaktu dengannya as long as it deals with data...


Back to their question, there are many actions we could apply when we deal with data. The most basic and crucial actions are CRUD:
  1. Create - you create and store a data into database
  2. Read - then, you read the stored data by retrieving it from the database
  3. Update - if you think you need to change some data, you may update the data stored in the database
  4. Delete - last but not least, mun rasanya inda lagi beguna, you may delete the data by removing it from the database
In order to manipulate the data, you must have at least basic skill on SQL (Structured Query Language). It is a syntax that is required in order to establish a communication between Front End application/software/program/system and the database. If you think you already know how to use SQL, click here to read Khadijah's post on SQL Zoo or else, hmmm click here kalie bisai...
Here are examples of the CRUD's SQL syntaxes:
  • Create - INSERT INTO table_user (name) VALUES ('zul')
  • Read - SELECT * FROM table_user
  • Update - UPDATE table_user SET name='fadly' WHERE name='zul'
  • Delete - DELETE FROM table_user WHERE name='fadly'
There you go... Even though it is not in detail but hopefully tane sama-sama mendapat ilmu yang bermanfaat serba sedikit...
Sekian, wassalam...

P/S: I you feel like ada kan ditambah, give your comments! =)

2010/11/19

Notion Ink's The Adam Release


Salam Anak IT.
Based on my previous article on "The Adam - Android Pad", I mentioned that it might be released on November *liat calendar* yes November but I think it will not come out to market any time soon. The following phrase is taken from Notion Ink's blog:
"We are on time for this and you could hold devices in your hands on or before Christmas (and as hinted earlier, if we miss Christmas, then CES or New Year). Pre-booking will start in early December (if the case id prior). Already received FCC for the chargers!"
Based on their statement, The Adam will surely be released on December next month. You may visit their blog by clicking here or anywhere here. Bwuahuwhuahuwa =) Anyway here are some of the screenshots of The Adam:



What I only know is that we can pre-book The Adam early December and some sources stated that the price will be less than USD500 (around BND700?...). For those yang ketinggalan atue you may read my previous post regarding this little guy by clicking here, but not here.
Sekian, saja mengupdate about this long waited Android Tablet =) wassalam...

2010/11/13

FOSS - K-Lite Codec


Assalam,
It's been a while since I posted on anak.it. So today I'm going to introduce you K-Lite Codec. Ok.. gerenti ramai orang confuse sikit apa guna nya if kana install kan ke dalam laptop or desktop. Well K-lite Codec ani is basically a collection of audio and video components for Windows [1]. Still confuse? Andang nya tuu.. Aku pun awal-awal confuse.. First time aku membali laptop, kana install kan k-lite codec ani.. tapi inda ku tau apa guna nya.. then aku format laptop ku.. then baru ku realise ada guna nya...
So.. Let me explain.. Pernah kah biskita kn membuka video dlm format 3GP? RMVB? MKV? OGG? FLV? well.. K-Lite codec will help you to open the file and be able to view it. Its basically upgrade biskita punya video codec supaya dapat buka video dalam format tersebut di atas tadi.
If biskita masih confuse? Mari aku bercerita sedikit pasal ani.. Selalu nya... if computer baru habis format, biskita dapat buka video file under AVI, MPG, MP4 ganya.. so if baik nasib, dapat nampak gambar nya.. tpi if inda baik nasib.. inda ber-gambar langsung.. *Iatah membari garam hati oleh nya tuu..*
To solve this problem, biskita install K-Lite Codec. That way, you can view semua video format and its free!!
If biskita mau download.. click here.
Basically, K-Lite codec ani ada 4 jenis. Which are Basic, Standard, Full and Mega. Aku recommend Mega pulang.. K-Lite Mega Codec ani is the complete package of video format yang dapat di lihat lah... Even aku menggunakan K-Lite Mega Codec.
And for those yang ada udah dalam computer nya, kalau boleh constantly update lah K-Lite Codec biskita. Most of the update ani mengusai loophole aka Errors of K-Lite Codec yang version lama. Biskita inda pulang sadar ada error atau inda tu tapi ada banar nya...
K-Lite Codec ani saja bukan untuk video, tapi ia boleh digunakan untuk mendangar lagu jua..
If you dont feel like using K-Lite Codec, dont worry. There's another software for updating your video and audio codec as well. To be precise, there are tons of software that update your video and audio, but the most common that I see is "VLC Media Player".
If mau mendownload VLC... click here.
I think that is all for now. I hope this article gave you an extra knowledge on K-Lite Codec and what it does. If you have any question regarding this article, please do not hesitate to click "Miana Kan Tue?" at the top of this page. We will try our best to reply your question(s).
Thank you!
Sekian,
Wassalam..