DaTaBaSe pRoGraMmiNg

[HiPPiEcHiC]

Hi! Anyone here who's into database programming (SQL, Visual FoxPro, or Access)?!?! Need Your Help!!

[loc0]

I've played around a bit with MySQL, by no means am I an expert. Hoping to learn more from other people myself :)

..loc0(site (http://insectivore.org)/email (god@insectivore.org));

[HiPPiEcHiC]

Ano ba sa 3 and madali?!... I need to incorporate it to visual c++ kasi eh... suggestions?!...

[Kikkomann]

Pinakamadali? I believe it's MS Access. But if you want stability and ease of use next to MS Access, it's got to be Foxpro.

[fatkee]

Tama si Kikkoman. Access nga ang pinakamadali kasi may mga wizards. Teka, para saan ba iyang program mo? Pang project lang ba iyan o seryosong programming?

[Witty]

pinaka madali..syempre access... vc++ 6 at access... both from microsoft... so defintely may mga tools na yan para ma-access ng VC ang access file.... pero ACCESS is a desktop database.... i prefer RDBMS.... try SQL Server.... I've used MySQL with VC++ but you have to download 3rd party libraries to able to connect VC with MySQL

[HiPPiEcHiC]

Originally posted by fatkee
Teka, para saan ba iyang program mo? Pang project lang ba iyan o seryosong programming?





It's for my thesis kasi eh... i need to put database talaga!....

[CodeBoy]

Originally posted by HiPPiEcHiC
Hi! Anyone here who's into database programming (SQL, Visual FoxPro, or Access)?!?! Need Your Help!!

Visual Foxpro: very very steep learning curve but is powerful.

Access: very easy to learn and very friendly but is considered a 'toy' database because it starts choking on medium sized databases (a hundred thousand records+ maybe).

SQL Server: is an enterprise level database that has loads of high end features but I've heard about ppl having stability problems with it. Very expensive to deploy (but still a lot cheaper than Oracle)

MySQL: very easy to learn too (but not in the graphical way that Access is) and fast and powerful in its own right. Its SQL dialect lacks subqueries though as well as stored procedures and referential integrity (features which are promised in 4.1) Small footprint and FREE to deploy. Very suitable as a web database.

Interbase/Firebird: even smaller footprint than MySQL-Max, and has full SQL features (those that MySQL doesn't have). Just a teeny bit more complex to learn owing to its being more full featured. Its one main con is lack of mindshare. Firebird, the open source fork, is even more FREE than MySQL, you can embed it in your own program without needing to GPL it.

I'm currently using MySQL with Delphi in order to learn Delphi db programming but am planning to go Interbase as soon as I am comfortable with the Delphi DB-related components.

In a commercial environment, I can understand the appeal of a db like SQL Server or Oracle (or VFP or Access) because they offer the chance to blame or count on someone else (tech support) if something goes wrong. It's scary to advocate an open-source database and then end up with egg on your face if something goes wrong or when you are counting on the open source community to come up with missing connectivity features without a strict timetable (not that these problems are necessarily absent from commercial offerings). However in these times of economic crunch, bosses worth their salt will definitely appreciate your being able to save your company a tremendous amount of money if you can effectively deploy an inexpensive open source based solution.

[the_BuGs]

Adaptive Server Enterprise ok yan......


Oracle
SQL Server
Kung cheap shot database lang yung nde pang malakihan.... pwede na ang Access at ang VFP

[HiPPiEcHiC]

Hmmm... I gez, I'll use ACCESS instead... By the way, how do i link Access to VISUAL C++?! Anyone?!....

[urnstoff]

hi.

For your thesis, MS Access is the right choice. I just warn you though that Access does not offer the flexibility to suit today's business logic. If your choice of frontend language is VC++, then you have to learn ADO (ActiveX Data Object). VC++ once used ODBC but it has a very steep learning curve.

ADO is used to connect to ACCESS. There are lots and lots of turorial about ADO in the net.

[HiPPiEcHiC]

Okiesh! Thanks a bunchy, guys!!! :)

[CodeBoy]

Why on earth would anyone want to use VC++ to create a database frontend? Unlike the case with Visual Foxpro and VB, the only thing Visual in VC++ is in the name - it's not a RAD tool in the least. No visual components, no drop-in data aware controls. Using VC++ for creating db frontends is for those with masochistic tendencies. It's tantamount to going back to the dark ages.

If you find VB too limiting and you move up (or down) to Visual C++, you'll find that you completely lose the ease of programming that the VB language and the VB visual RAD environment offers. If you insist on using an MS solution, Visual Foxpro (steep learning curve but still has a visual RAD environment and very powerful accdg to a friend who uses it) would be the better choice for databasing. For me, Borland's offerings (Kylix/Delphi) lets me have my RAD cake and eat it the way I like it too (low-level control - Delphi 6 supports ADO, ODBC, BDE, dbExpress, etc...). Delphi 6 even comes with its own newly introduced XML-based desktop database called MyBase in addition to the old BDE-based standbys dBase and Paradox tables. On the other hand, I have not heard very flattering reports regarding BDE. Embrace Delphi but eschew BDE was such a widespread piece of advice that I just followed it without even bothering to verify if it was true. I have yet to regret that decision.

The real secret to effectively utilising Delphi/Kylix is in knowing the right third party components to use - there are so many excellent choices.

[Ichitaka_Seto]

basta ko Oracle!!!!!!!!!!!!! (yun pa lang alam ko eh[~1 month], hehe...)

[ravaged_ph]

i agree with codeboy.
and those anyone still use foxpro???
go for vb, or better yet go for vb.net

[HiPPiEcHiC]

OMG!!! I have no choice but to use VISUAL C++ as my front end... That's the language i proposed on my thesis!!! Accckkk!!!!!! :depressed2: :hopeless:

[CodeBoy]

www.sapdb.org

Wonder how this compares to Interbase and Oracle... SAPdb looks nearly as mean as Oracle.

Suffice to say that today's database developer is super-spoiled for choices. Even FULL versions of Oracle 8 and 9i are freely downloadable if you've got the patience and bandwidth... (deploying it will still send you to the poorhouse though).

[redbull]

siguro if it wer me...i wud use odbc to connect vc++ w/ any database. so if u have any problem with ms access, all u need is to change ur odbc driver to sql server 7.0 or to any other database supported by odbc. btw, i used vc++ and access 97 in my thesis also. but if ur gonna use the latest database i suggest u update the service pack of vc++.