linux training in Thailand
| Home | Articles | Download | Free Linux Tips | Resources | Training | Web Link | Linux Training English|
| Courses | Schedule | Price & Promotion | Map | Customer Ref. | Instructors | Certification | FAQ | Registration Form |
ʶҺѹ 駻Դӡҧѹ 27 -31 áҤ 2558 Դӡûѹ 3 ԧҤ 2558
We are on vacations 5 days in July 27-31, 2015 Please contract Line ID : nok_fly or e-mail : info@itdestination.com
ITDestination лԴѺا䫵 ѹ 7 - 9 Զع¹ 2556
Ҩзҹ㹺ԡ Webboard Freetips E-Learning ֧㹤дǡ
ʶҺѹ 駻Դӡѹ 22-28 Ҿѹ 2560 ШԴӡûѹ 1 չҤ 2560
óյԴ觢ͤҷ Facebook: LinuxITDestination e-mail: info@itdestination.com 觨еԴ͡Ѻҳ 17.00 .
ŧ¹ͺöӢͺ online 㹪ǧͺͷǹ ӡѴӹǹ բ·١ͧй
ͺ´ 089 890-5494 >>> ҹ´...

㹡ùչءͧ

ҹ ħѵ

"ҷӤѡѺҹԧ Firebird ҵẺ蹫 ͧѧ稢ͧͧøáԨ Label Industries" ҧ˵ءóͺҷ仴¡¹ŧ ˵ءóʧ㹻ѡ ѹ¨ҡäԴͷҧԹ ҵá÷ԧѧ㹡ûҺԹԴԢԷ㹺ҹ ǹ觼ŵ͡ôԹԵͧҴ¡ѹ駹ҧçҧ Ѻҧҷͧкͷͧö
Ѻ͹仴¤Һ蹷شѧͧҷ˹ѡ駵 ੾ͻѭҵҧ 觼ŵɰԨͧͧ Ϳ蹫ʨ֧պҷ ա˹觤ѧйҧкͷ餧͹䢴ҹŧع
Linux Success Story ѺԺ¡ͧҤ͡ա˹繡óյҧѹ ѷ ǧ͡صˡ ӡѴ 觴ԹáԨҤصˡ
( Label Industries ) ѡɳТͧԨդ繵ͧçѺ͹ͧ¤ͷ· ੾ҧͧͧúѹ֡Ѵ红Ũӹǹҡ㹷ء 鹵͹ͧôԹҹ 件֧ͧ÷¹ͧ͡ôк硷͹ԡ
˹ҷѺԴͺӤѭǡѺԨ·ǢͧѺк СþѲͻप蹢ͧù سҹ ħѵ ѹդҢմ¹ͧǺ͡Ҥ㹡ùչءͧ ੾ͧǡѺкҹŷ蹫 ͧҿѧͧǷʹ㨹ѹѺ

Linux Ѻ Interbase ǹŧ ǤԴ¹ͧҡ֡ҡк͡ǡѺ
չءͧ 繤稷ѧ㹻Ѩغѹ ´ ¤¹(ͧҡѨغѹ˹ѧ Linux ͡ҡ· ) ¤ͧâͧ 4 ѹ͹˹ѧͷ¹Թ С÷ͧþѲͻप蹢ͧ Clipper 10 ա͹ հҹ DBF ͧ Client 25 Run Netware 3.12 觼¡ͧ繷شȵ 㹤Դͧ Windows NT/2000 File Server ѧ Netware ѹҡûʺóԧ ǺѨغѹӹǹͧ Client 100 ҵ Linux Server ա 6 Database Server 1,File Server for Mcintosh 2,Mail Server 1,SMB Server 1 Backup Server 1
Ѻҡѹ Netware Clipper ͧҡ ͧҡҾѧ㹻ѨغѹҾҹͧѺͼ˭ Windows ͹ҡ 㹰ҹмѲ Application ҾǴẺ DOS ١պ¨ҡ Clipper Windows 鷴ͧ Developer µ· ִѡҵͧӤҡ Clipper ҾѲҵ ͷ Port ¹ѹк Windows ش¤ѹ Ҽѧִѡù Application Developer ѡǤҡ ѧִԴѺ Clipper ҡ͡˵ؼ ͧǡѹҡ ѹҼҨŧ Delphi Borland ǹջѭ颺Դѹͧҡҵͧ͡ Delphi Ѻ¹ Ӷ "ä Database 红" 觵͹͡ Interbase ͧâͧԹԢԷ Interbase ͡蹷͹ФѺ (͹ѧѡ MySQL ,PostgreSQL ) ѧͧԵͧҧ Interbase Ѻ MS SQL Server Դ Borland Ѳ Delphi+Interbase Ҩ觷ҡѹ Interbase ҧ Borland 繼Ե СͺѺ֡ҤسѵԢͧ Interbase ( 㹵͹ѧ ) ԴҹҨ繷ҧ͡շش͹ Сѧ͡չء ͧҡ͹繻 .1999 ѧԴ͡ Windows NT Server Interbase ŨҡͺǪҭҧҹ Database Server ·ҹӵͺ͹ѹѧ ͡ Windows NT ѹ MS SQL Server 鹨еͧ¹ٻẺ Application Server(Multi-tiers) ҹ鹶֧ run ж¹Ẻ two-tiers Windows NT Ѻҹ ҡõ͹֡繡ѧҡͧҡ¹ǡäԴҡ DOS Environment Windows Environment ᷺Сѡʹ ѧͧ¹ѹ Advance ա շҧ͡աҧ ҵͧ ѹẺͧ еͧԴ Database Linux 觹蹨֧繷Ңͧͧ Interbase Linuxͧ DžٴҹǡѺ Open Source/Free Software ç˹ ͹ѹ м͹ Database Դâ Borland Сᨡ Interbase 㹻 .. 2000 ͧ֡Դҡٺͧҡҳ ( ҷ ) ҿ͹ ҧ Borland Version ˹ 㹢зҧ蹷蹫ʨдԹ¡ Firebird 觷 Interbase 㹻Ѩغѹ ١Ѳ 2 Ƿҧ Borland Interbase աҧ Firebird Interbase ѧ觷оٴѧҡ÷Ѵ仼¶֧ Firebird Interbase ҹ

سѵԢͧ Firebird سѵԷǶ֧Ҩçѡ ͧҡ繤سѵԺҧǹͺ ҵͧҢ价 http://www.ibphoenix.com
  1. ҧռ㹵͹ ѹöѹ Platform ҹҹҧ¡ 1999 Ѻʷѹ linux ,windows ,netware ,solaris ,freebsd ,HP-UX ,AIX ,Win CE شµ Mac OS ش¹ѹشʹ Platform ԧ
  2. ҹѺͧҵðҹ SQL-Standard ANSI-92
  3. Trigger Store Procedure 繡Ŵ Programming ҡ зӧҹǴҡ
  4. ͧ Database Ẻ ¶֧ ҧ Database test Ҩ test.gdb ˹觵 㹨лСͺ仴 Table Ҩ Move ˹֧ŧ
  5. ö Split File ҹբҴ˭Թ 2 GB Linux ö handle Թ 2 GB ( Linux ˹ ) ö¡͡ ص test.gdb Ҵ 5 GB öᵡ͡ test.gdb Ҵ 2 GB, test.gd0 Ҵ 2 GB test.gd1 Ҵ 1 GB Run ͧҹ test.gdb § Ͷ֧ŷͧͧӴѺѴѹзӧҹͧ
  6. к Backup Online ö Backup 㹢зѧҹ ѹͺѹա DOS ҡ
  7. Linux ö Run Ẻ Classic Super Server ҡ Windows з੾Ẻ Super Server ҹ 觡 Run Ẻ Classic ¶֧ user connect gdb ҨйѺ 1 process ǹẺ Super Server ѹ§ᵡ thread ա ҡʺó Linux ѹẺ Classic зӧҹǴǡ Super Server ҡ еͧͧ˹¤ҡ蹡ѹ
  8. ͹ҧ Windows Ѻ Linux дǡ 㹡óշա͡ʢŢͧ Interbase ͧ Windows ҡй觺 Linux ҷӵٵ ͧ Backup Windows ͹ ǵͧ Restore Linux ҡ÷ͺ Copy Linux öӧҹ蹡ѹ
  9. ͧ͵ҧ 㹡ҧ Firebird Database ҡ 駿 ҡѹ䫵ѧǢҧ ͨо觷 SQL Command µç
ԸաõԴ شʹ¤Ѻ rpm -Uvh FirebirdCS-1.0.0-nnn.i386.rpm ҳԹ 1 ҷ º öҹ §Ҩеͧա䢤͹ԡԴ˹ Ѻóշ Client ӹǹҡ 价 /opt/interbase/isc4_config Ѻ Parameter ͧ Client ҡѡͧ öҹ ¡ setup set service firebird ӧҹء駷Դͧҹ稺 Ըա Interbase ҧҡѺ ӵ͡Ẻ PDF Ҥջѭ ¡͹еԴҡҹ¾ ͡º ˵ѹ Commercial version ҡ͹֧͡ءҧ㹹 觷ѧҡõԴ
Start/Stop Service Start > /opt/interbase/bin/ibmgr -start -user -passwd
Stop > /opt/interbase/bin/ibmgr -stop -user -passwd
Backup & Restore Backup> /opt/interbase/bin/gbak -b -g -v <source dir> <target dir>
Restore> /opt/interbase/bin/gbak -r -v <source dir> <target dir>
Config ͧ V4_LOCK_MEM_SIZE = XXX ҡó Client ӹǹҡ ANY_LOCK_MEM_SIZE = XXX ҡó Client ӹǹҡ ٴ֧ҧ ͧ Database Server ( Firebird ) 촴ʡ좹ҡ 36 GB ӹǹ 3 ·Ѵ͡÷ẺҹԵ繡ҿԡբҴ˭ ( ҹ newsgroup ҧդ Ҵͧ Database ֧ 200 GB ) Pentium ˹¤ RAM 3 GB ШѴ Swap Partition 6 GB 觢й Swap ҾŴ٧شҳ 2 GB з״仺ҧ ѧѺ ˹¤ RAM ǡ֧ᵡҧѹҡ ( ͧԺͧ ) 觵໤еͧҡҴس RAM 512 MB §͵͡õͺʹͧ ͹鹼 512 MB ҹ 觢й鹨ӹǹ Client ջҳ 50 Ѩغѹա 100 ֧繵ͧѺاѹҧ ʶҹСóѨغѹ Ѩغѹ Firebird Ѳҷ Version 1.02 Release December 18,2002 յ Beta 1.5 鷴ͧ ( Test Released ) ǹ .NET ͧ蹴ٹФѺ 4 Ƿӧҹ ʶ з client ҡ 100 еԴ Connection ѧ Database Server ҳ 3 Connection Connection ͺ 500 connection Ѻ Connection ҡ ͹ѧ Application Developer ԢԷ ҹҡǾѲͻप蹷 Open source PHP ѹǹ Client § Web Browser ҹ鹡öлѴͧҡ PHP տѧ蹷ʹѺʹع¡ Interbase µç繵ͧ ODBC ֧ҹ᷺к͡ҡù Linux Interbase Firebird ҹö»Ѵͧҡ ԧ֧ͧâͧաѧ Ф "١ " ʹͧ Firebird ͧӹdzٹФѺ Database ԢԷ 100 Clients Ť Database License Ẻ١ҳ 5000 ҷ client Linux աҹҹԹŧعѺ Software ¡ҹҡ ͷҹҹ騺 Firebird 繷ҧ͡աҧѺ ء Platform Ƕ֧ ( MySQL պ windows) ͡觷зش.. ѧú͡һʺóǡѺùչءҾѲкҹͧâͧسҹ ԴҤҹҹҾûءչءЫͿ蹫Ѵਹ觢鹹ФѺ ੾ͧͧҵ§ MS Access ,MS SQL ,MySQL PostgreSQL ҹա ҧáҵ˹Ѻͧâͧس سҹ鹷еͧҤӵͺ ǤسҺҺҧҤҨͧѴԹسҢͧء
觢ҧԧ
www.ibphoenix.com

䫵ҧ繷ҧâͧ IBPhoenix Firebird
http://firebird.sourceforge.net

Ţͧ Firebird 㹰ҹ Open Source Software
news.atkin.com http://www.cvalde.com/misc/interbaseNewsgroups.htm

Newsgroup ͧ Interbase
http://www.mysql.com/information/features.html
ͧººسѵԴҹҧ ͧҵ䫵