Suggestions for IDE as well as db language

[Prime_Coder]

Hello all TDF members,

I wanted to know what difference will it make by using NetBeans or Eclipse while developing a desktop application. I want to use open source product, so I thought to ask you this question, since both are open source.

Also, I want to know which database language will be really helpful and easy to use in the application development. Whether I should use SQLite or should I use MySQL?

 

[vickybat]

I will suggest netbeans and mysql.

Have a look at this. A quick google gave me this.

 

[Prime_Coder]

I am also thinking of the same alternatives, but i thought to have an insight from experienced programmers from TDF.

 

[vickybat]

^^ I'm sure about the db cause mysql is really light and easy. I have used both oracle and mysql and have hands-on experience on them. Having worked on siebel, the db we used was oracle and both were proprietary products of oracle (siebel being a crm tool with oracle db as a database).

But not sure about the IDE. You should choose considering your requirements and i guess for your requirement you could pick any. Still then, wait for some experienced programmer to comment on this.

 

[Liverpool_fan]

SQL Lite and MySQL. Both serve different targets IMO.

 

[skeletor]

SQL Lite and MySQL. Both serve different targets IMO.

yup.

For a standalone desktop app, go with SQLite. I mean, why you'd want a heavy daemon running in the background for a desktop app? (referring to mysqld)

MySQL if you were coding a website or a large scale project.

 

[Prime_Coder]

Yeah. I know SQLite and MySQL serve different purposes.

Before posting the question, i had read the information on websites.

But I wanted to know which will be better if used in an application which is web enabled desktop application. And what is chosen by other programmers, if they also encounter such situations.

 

[skeletor]

For local application data storage, I'd prefer SQLite. Even Firefox uses it.

It is this simple to implement SQLite in your C/C++ program - SQLite In 5 Minutes Or Less

Just an example, now if your desktop app is connecting to a server over the Internet to fetch details or anything, in that case you would prefer running MySQL on the server. SQLite for local storage for the app.

 

[vickybat]

Mysql can also be used locally and i don't think it would be a resource hog. I haven't used SQLite so can't comment. After seeing ico's post, i think its a good option as well.

 

[Liverpool_fan]

Vicky, will you be pleased if a desktop application asks to you install entire MySQL server? MySQL is an *overkill* there.

 

[vickybat]

^^Yup i got what you're trying to say mate but i always compare mysql with oracle and the former is far less resource hog.

Haven't used SQLite so yes as you guys are saying its best for local builds, then it should be good for op here.

 

[skeletor]

lol, I run MySQL on my machine as a "local build"...but that's not the point.

The point is, for a desktop application, why'd one want MySQL as a 20 Megabyte dependency? When it is not needed at all? MySQL's "client-server" model is also unneeded for a desktop application as far as "local storage" is concerned.

Used Firefox? It stores Bookmarks in SQLite.

Another way to look at SQLite is this: SQLite is not designed to replace Oracle (and MySQL). It is designed to replace fopen().

Appropriate Uses For SQLite

SQLite is made "embedded" use in desktop/mobile applications.