lordemtech
Size AAA Battery
Pogi/Ganda Points: 16
 Offline
Posts: 74
"Life is how you make it"
|
 |
« on: July 16, 2010, 11:57:02 AM » |
|
Sino po ang may alam sa SQL server? Ano po to? at paano ito gumagana... meron kasi ang compuetr ko nito pero d ko alam kung para saan ito... tnx po..!  |
|
|
|
|
Logged
|
"I am a slow walker, but i never walk back"
|
|
|
|
The Philippine Electronics and Technology Forum
|
|
« on: July 16, 2010, 11:57:02 AM » |
|
|
|
|
|
|
Logged
|
|
|
|
Macgyver
Diesel Generator
Pogi/Ganda Points: 66
Offline
Posts: 1372
|
|
« Reply #1 on: July 16, 2010, 12:26:24 PM » |
|
Its a database management software.
It isolates the management of data para separate yung flow ng logic ng software mo and anything related to data like add a record, delete record, search record eh will be taken cared of by the database server.
The communication between your software/program and the database server is SQL (Structured Query Language).
May iba ibang gumagawa ng SQL or database server.
Isa na dyan yung Microsoft SQL. Meron dun mySQL server which is an open source database management software. Ok yung mySQL kasi pwede ka magkaroon ng sarili mong SQL server without buying those expensive proprierty DB servers.
Incidentally, yung mySQL server eh binili na ng Oracle, pero libre pa din sya gamitin.
|
|
|
|
|
Logged
|
|
|
|
lordemtech
Size AAA Battery
Pogi/Ganda Points: 16
Offline
Posts: 74
"Life is how you make it"
|
|
« Reply #2 on: July 16, 2010, 12:51:28 PM » |
|
Its a database management software.
It isolates the management of data para separate yung flow ng logic ng software mo and anything related to data like add a record, delete record, search record eh will be taken cared of by the database server.
The communication between your software/program and the database server is SQL (Structured Query Language).
May iba ibang gumagawa ng SQL or database server.
Isa na dyan yung Microsoft SQL. Meron dun mySQL server which is an open source database management software. Ok yung mySQL kasi pwede ka magkaroon ng sarili mong SQL server without buying those expensive proprierty DB servers.
Incidentally, yung mySQL server eh binili na ng Oracle, pero libre pa din sya gamitin.
ganun pala yun... eh paano ako gumawa ng database like records or sort of... may software pa po ba na gagamintin? |
|
|
|
|
Logged
|
"I am a slow walker, but i never walk back"
|
|
|
Macgyver
Diesel Generator
Pogi/Ganda Points: 66
Offline
Posts: 1372
|
|
« Reply #3 on: July 16, 2010, 12:58:45 PM » |
|
ganun pala yun...
eh paano ako gumawa ng database like records or sort of...
may software pa po ba na gagamintin?
Kailangan mo muna magsetup ng mysql server syempre. Kung gusto mo magexperiment mag download ka ng WAMP sa http://www.wampserver.com/en/ May webserver na yan, may mysql server na, and php. Hanap ka na lang ng tutorial sa youtube kung paano iinstall and mga sample php scripts on how to connect to mysql. ( http://www.php-mysql-tutorial.com/wikis/mysql-tutorials/connect-to-mysql-database.aspx) |
|
|
|
|
Logged
|
|
|
|
lordemtech
Size AAA Battery
Pogi/Ganda Points: 16
Offline
Posts: 74
"Life is how you make it"
|
|
« Reply #4 on: July 16, 2010, 01:07:38 PM » |
|
cge susubukan ko, heheh tnx!
|
|
|
|
|
Logged
|
"I am a slow walker, but i never walk back"
|
|
|
lordemtech
Size AAA Battery
Pogi/Ganda Points: 16
Offline
Posts: 74
"Life is how you make it"
|
|
« Reply #5 on: July 16, 2010, 01:15:23 PM » |
|
pero may mga security treats din ba ito since database ito?
|
|
|
|
|
Logged
|
"I am a slow walker, but i never walk back"
|
|
|
Macgyver
Diesel Generator
Pogi/Ganda Points: 66
Offline
Posts: 1372
|
|
« Reply #6 on: July 16, 2010, 01:28:58 PM » |
|
^oo lalo na kung weak yung password mo. some weakneses is outside of mysql. nasa software/program that uses the database. pero robust ang mysql. karamihan ng mga blogs/forums sa internet, puro mysql gamit usually. pati outside the internet like mga big companies, gumagamit ng mysql.
|
|
|
|
|
Logged
|
|
|
|
zer0w1ng
Technical People
Gas Turbine
Pogi/Ganda Points: 295
Offline
Gender: 
Posts: 2151
Enter any 11-digit prime number to continue...
|
|
« Reply #7 on: July 16, 2010, 02:01:06 PM » |
|
Lahat ng software may security weakness even the high priced one.
Mostly ang weakest link sa security are the users.
Like default passwords, no password users, readable config files or misconfiguration.
And any system, kung may physical access sa hardware ay vulnerable.
|
|
|
|
|
Logged
|
|
|
|
lordemtech
Size AAA Battery
Pogi/Ganda Points: 16
Offline
Posts: 74
"Life is how you make it"
|
|
« Reply #8 on: July 16, 2010, 02:17:36 PM » |
|
medyo malabo pa rin... pero na gets ko na ang function nya. and malabo lng paano sya gumana. Yung pag.gawa ng data base, ang pg retrive nito... ang pag view... etc... kasi parang script type cya diba? Di katulad ng offices sofware na makikita agad...
anyway, tnx at may natutunan pa rin ako...
update ako uli...
|
|
|
|
|
Logged
|
"I am a slow walker, but i never walk back"
|
|
|
Macgyver
Diesel Generator
Pogi/Ganda Points: 66
Offline
Posts: 1372
|
|
« Reply #9 on: July 16, 2010, 02:21:10 PM » |
|
medyo malabo pa rin... pero na gets ko na ang function nya. and malabo lng paano sya gumana. Yung pag.gawa ng data base, ang pg retrive nito... ang pag view... etc... kasi parang script type cya diba? Di katulad ng offices sofware na makikita agad...
anyway, tnx at may natutunan pa rin ako...
update ako uli...
oo. kung gusto mo ng may GUI frontend ka na point and click eh makakagawa ka ng database, tables, fields..etc. kailangan mo maginstall ng phpmyadmin. Eto pa mga ibang pwede mong gamitin ( http://www.databasejournal.com/features/mysql/article.php/3880961/Top-10-MySQL-GUI-Tools.htm) |
|
|
|
|
Logged
|
|
|
|
lordemtech
Size AAA Battery
Pogi/Ganda Points: 16
Offline
Posts: 74
"Life is how you make it"
|
|
« Reply #10 on: July 16, 2010, 02:29:38 PM » |
|
Yun tnx... hirap pala gamitin nito... pero interisado pa rin akong matutunan ito...
|
|
|
|
|
Logged
|
"I am a slow walker, but i never walk back"
|
|
|
lordemtech
Size AAA Battery
Pogi/Ganda Points: 16
Offline
Posts: 74
"Life is how you make it"
|
|
« Reply #11 on: July 16, 2010, 02:51:53 PM » |
|
http://yfrog.com/bflordemtech10pano po sunod dito? paano ako makakagawa ng data or set-up ng database...?
|
|
|
|
|
Logged
|
"I am a slow walker, but i never walk back"
|
|
|
lordemtech
Size AAA Battery
Pogi/Ganda Points: 16
Offline
Posts: 74
"Life is how you make it"
|
|
« Reply #12 on: July 16, 2010, 02:53:26 PM » |
|
 By lordemtech at 2010-07-15 |
|
|
|
|
Logged
|
"I am a slow walker, but i never walk back"
|
|
|
Macgyver
Diesel Generator
Pogi/Ganda Points: 66
Offline
Posts: 1372
|
|
« Reply #13 on: July 16, 2010, 03:46:01 PM » |
|
Google ka ng mga tutorial. Meron nyan malamang sa youtube..etc. Mas matututo ka sa mga video tutorial. Eto may mga printscreen - http://www.configure-all.com/phpmyadmin.php |
|
|
|
|
Logged
|
|
|
|
|
The Philippine Electronics and Technology Forum
|
|
|
|
|
|
Logged
|
|
|
|
|
October 07, 2008, 06:14:36 PM
