[SuSE Linux] Database programing tools
Any one have some sugestions on basic datbase building tools that can hanle basec data enty forms and parent child data entry forms . Preferably something that can handle picl list and lookups . Ect... Any comments on msql , is it just a back end sql server , or does it have gui / data form tools ectt.. Any other sql data base tools that are east to use , and allow you to program base dat base apps ?? Thanks Samy - To get out of this list, please send email to majordomo@suse.com with this text in its body: unsubscribe suse-linux-e Check out the SuSE-FAQ at <A HREF="http://www.suse.com/Support/Doku/FAQ/"><A HREF="http://www.suse.com/Support/Doku/FAQ/</A">http://www.suse.com/Support/Doku/FAQ/</A</A>> and the archiv at <A HREF="http://www.suse.com/Mailinglists/suse-linux-e/index.html"><A HREF="http://www.suse.com/Mailinglists/suse-linux-e/index.html</A">http://www.suse.com/Mailinglists/suse-linux-e/index.html</A</A>>
Hi Samy, my english is not very good so it's a bit hard for me to draw out the correct word from your mail. There are a lot of DBMS or RDBMS available on the net. First you have to focus on the dataset you have to deal to, then you can chose the database management system that fits your needs. Mini SQL is a light weight relational database management system. It has been designed to provide rapid access to data sets with as little system overhead as possible. The system itself is comprised of a database server and various tools that allow a user or a client application to communicate with the server. There is a front end (called msql) to interact with the DBMS and some tools to administrate the system. There is, also, a set of API which allows any C program to communicate with the database engine. On the msql web site there is a section on which you can find several useful tools. mSQL can manage only a subset of the SQL language. I used mSQL for my web site togheter with PHP, while for stand alone task I used the tclmsql module to build some gui. Actually, msqltcl which works with tcl/tk <= 7.6/4.2; has a very nice gui called mmon (msql monitor) which you can easily use even if you don't know any tcl at all. If you need a powerful RDBMS, then use MySQL. It' s a bit more hard to setup but is really powerful and fast. I am currently using MySQL instead of mSQL. Hope this helps, and please try to read twice your mail before posting it because for non english mother-tongue is really difficult to understand what you write. Maurizio On Mon, 28 Dec 1998, you wrote:
Any one have some sugestions on basic datbase building tools that can hanle basec data enty forms and parent child data entry forms . Preferably something that can handle picl list and lookups . Ect...
Any comments on msql , is it just a back end sql server , or does it have gui / data form tools ectt..
Any other sql data base tools that are east to use , and allow you to program base dat base apps ??
Thanks
Samy
--------------------------------------- Associazione Culturale Passepartout Piazza G. Matteotti, 17 01017 Tuscania (vt) Italia fax: +39 0761 444044 tel: +39 0761 444261 e-mail: paspartu@uni.net e-mail: passepartout@newmail.net -------------------------------------- - To get out of this list, please send email to majordomo@suse.com with this text in its body: unsubscribe suse-linux-e Check out the SuSE-FAQ at <A HREF="http://www.suse.com/Support/Doku/FAQ/"><A HREF="http://www.suse.com/Support/Doku/FAQ/</A">http://www.suse.com/Support/Doku/FAQ/</A</A>> and the archiv at <A HREF="http://www.suse.com/Mailinglists/suse-linux-e/index.html"><A HREF="http://www.suse.com/Mailinglists/suse-linux-e/index.html</A">http://www.suse.com/Mailinglists/suse-linux-e/index.html</A</A>>
There are a lot of DBMS or RDBMS available on the net. First you have to focus on the dataset you have to deal to, then you can chose the database management system that fits your needs.
Currently I am using paradox files and using Borlands delphi to program in. Most of the applications consists of data entry using basic forms , some with parent child relationships , where when you move the parent record , the scroll list of child records changes as well. The data entry forms consist of edit field , pick lists , lookup field . Some of the lookup fields do a lookup on one value and when selected enter another value from the same row into the field. Ie lookup a part name , and when selected put in the part number. Reporting consists of booth columnar reports and tabulated free form type reports. My programing level is some where between novice and intermediate. Delphi makes use of a lot of components , and you can do a lot by just changing properties and editing event handlers. Most of your coding consists of entering bits of code to tie components together or to do a specific action. Delphi uses a super set of PASCAL called object PASCAL. Its a strongly typed and high level language. I have been avioding c , as it seems to be very low level and requires a lot of coding just to get simple things done. I have am currently looking into Java , and it seems to be higher than c but still lower level than Delphi Pascal. I have fount that there is a serious lack of third party components , and most of those available are really high end enterprize beans with high price tags. This really is a major problem. Its still rather immature and not really up to its momentum up to speed. What keeps turning my attention back to Java is the cross platform and being able to use the apps on win9x and linux. I like the idea of moving slowly to linux. Less rebooting and less reinstalls. A move to some sort of sql data base is doable , espeacly if it makes life easier. I rely dont need an industrial strenth sql databse . I will have two to three users awith a likely max of 5/6 users. Not a load to be considered about. That why I have been using paradox So far.
Mini SQL is a light weight relational database management system. It has been designed to provide rapid access to data sets with as little system overhead as possible. The system itself is comprised of a database server and various tools that allow a user or a client application to communicate with the server. There is a front end (called msql) to interact with the DBMS and some tools to administrate the system. There is, also, a set of API which allows any C program to communicate with the database engine. On the msql web site there is a section on which you can find several useful tools. mSQL can manage only a subset of the SQL language. I used mSQL for my web site togheter with PHP, while for stand alone task I used the tclmsql module to build some gui. Actually, msqltcl which works with tcl/tk <= 7.6/4.2; has a very nice gui called mmon (msql monitor) which you can easily use even if you don't know any tcl at all.
If you need a powerful RDBMS, then use MySQL. It' s a bit more hard to setup but is really powerful and fast. I am currently using MySQL instead of mSQL.
Hope this helps, and please try to read twice your mail before posting it because for non english mother-tongue is really difficult to understand what you write.
Maurizio
On Mon, 28 Dec 1998, you wrote:
Any one have some sugestions on basic datbase building tools that can hanle basec data enty forms and parent child data entry forms . Preferably something that can handle picl list and lookups . Ect...
Any comments on msql , is it just a back end sql server , or does it have gui / data form tools ectt..
Any other sql data base tools that are east to use , and allow you to program base dat base apps ??
Thanks
Samy
--------------------------------------- Associazione Culturale Passepartout Piazza G. Matteotti, 17 01017 Tuscania (vt) Italia fax: +39 0761 444044 tel: +39 0761 444261 e-mail: paspartu@uni.net e-mail: passepartout@newmail.net -------------------------------------- - To get out of this list, please send email to majordomo@suse.com with this text in its body: unsubscribe suse-linux-e Check out the SuSE-FAQ at <A HREF="http://www.suse.com/Support/Doku/FAQ/"><A HREF="http://www.suse.com/Support/Doku/FAQ/</A">http://www.suse.com/Support/Doku/FAQ/</A</A>> and the archiv at <A HREF="http://www.suse.com/Mailinglists/suse-linux-e/index.html"><A HREF="http://www.suse.com/Mailinglists/suse-linux-e/index.html</A">http://www.suse.com/Mailinglists/suse-linux-e/index.html</A</A>>
- To get out of this list, please send email to majordomo@suse.com with this text in its body: unsubscribe suse-linux-e Check out the SuSE-FAQ at <A HREF="http://www.suse.com/Support/Doku/FAQ/"><A HREF="http://www.suse.com/Support/Doku/FAQ/</A">http://www.suse.com/Support/Doku/FAQ/</A</A>> and the archiv at <A HREF="http://www.suse.com/Mailinglists/suse-linux-e/index.html"><A HREF="http://www.suse.com/Mailinglists/suse-linux-e/index.html</A">http://www.suse.com/Mailinglists/suse-linux-e/index.html</A</A>>
participants (2)
-
paspartu@uni.net
-
samelash@ix.netcom.com