Which language for a quick GUI app + sqlite database CRUD (2-4 tables)

Question

Which language for quick GUI app + sqlite database CRUD (2-4 tables). Java, Python? (Please no jokes like VBasic), some reference, source code to look on?

added:

First idea: 1 database SQLite (Win) + client GUI app (Win) clients table + orders table + others import, export database add, del, edit, etc. entries

Second idea: 1 hosted database (PostgreSQL ,MySQL) + web app client clients table + orders table + others import, export database add, del, edit, etc. entries

Thinking about Django, RoR or local Java(Netbeans), Python(wxPython+ORM).

???

Answer 1

Whatever you are most familiar with.

Or whatever have better set of ready to go components, so either Java (Netbeans/Matise + wizards) or something else.

Answer 2

Try python with wxPython for UI programming. I suggest, that you look for an ORM mapper like SQLachemy.

Somebody suggested dabo which is made especially for your purpose, but I have no experience with it (yet). It works with wxPython and databases like SQLite.

Answer 3

Need more info. For in house or will you distribute? Desktop or web-based? If web-based, do you host it or will you have it hosted?

Then there's your personal goals. Really, really do it quick, or let it be an opportunity to learn a language/technology you are curious about, like Ruby on Rails? Linq?

Answer 4

GUI development isn't much easier than with Tcl/tk. Also, Tcl has arguably the best interface to sqlite. If deployment is an issue there's definitely no language that can compete with tcl's tclkit/starkit/starpack packaging mechanism.

Answer 5

Write a XulRunner app; this can run with Firefox 3.0.

http://developer.mozilla.org

Answer 6

Delphi. It's an ideal fit for this kind of desktop application, and there's a SQLite wrapper available.

Answer 7

Ruby on Rails will do simple CRUD operations very easily - although doing more than that can be a little more complex (would require some reading about RoR's way of doing things). The latest version of Rails automatically uses sqlite databases, and in fact the whole database, and CRUD GUI code can be created with one command (scaffold).

If this is to be deployed then that can be a bit more difficult (although I hear that Capistrano is good) - but for local or intranet use then that's what I'd do.

Answer 8

C# and WPF, it;s preatty easy and good to know (I've been playing with it for 1 week and fully wrote a twitter client in a few hours.

now Cocoa, and the interface Builder, that is a cool approach even for a simple app.

Answer 9

REALbasic, if you want to do a desktop app. The Personal edition comes with SQLite built in and is free on Linux, cheap on other platforms. It's a very clean OO language and reasonable IDE, about as productive as VB6 to work in but much cleaner.

I've been doing cross-platform development for about 15 years and REALbasic is now my tool of choice for straightforward database form apps, including an enterprise accounting system I'm currently working on.

I also am working in WPF/C#, C++ and Cocoa/Objective-C so I'm not just a "Basic-weanie" :-)

Answer 10

If you were developing a web app I would suggest a scaffold-enabled site like rails, django or ASP.NET MVC (dynamic data). If its a windows app, nothing beats the productivity and features of WPF/Silverlight, if so consider using OrmLite, a POCO-driven lightweight ORM providing a set of useful extension methods around the common ADO.NET IDbConnection and IDbCommand interfaces. Using only convention and DataAnnotation attributes for configuration, it's effortlessly able to persist models with deep complex object graphs.

A live working example using Sqlite (with full source code) is available here: http://www.servicestack.net/ServiceStack.Examples.Clients/Default.htm

There is also a complete end-to-end example (i.e. stand-alone, no other config required) on stackoverflow: http://stackoverflow.com/questions/2106710/xml-to-sql-using-linq-and-c/2137249#2137249