Hi, I have been using SQLite without any programming language so far. I maintain the data in SQLite and use SqliteStudio (www.sqlitestudio.pl) for inputting data into it and running queries to look at outputs. However SqliteStudio does not have a programmable back-end that allows me to take the outputs of a query and do things with it (such as calculating running sums and averages, for instance). So, if things become too expensive for standard SQL, I just do without.
In the past, I have maintained my data in an Access database and developed a pretty extensive set of forms and reports to input and extract data. I moved to SQLite because I wanted to move off a proprietary platform onto a free one. And SQLite is faster and includes more SQL functionality like CTE's also. But I miss the nice front-end with forms to take inputs (especially parent and child forms to input data related to foreign keys) and the reports to format my outputs the way I wanted them. I could also do running sums and averages, percentile scores and other things that require looking at a data dump of an entire columns of contents to do efficiently. I am familiar with programming in C and Java, but none of my programming has been for the windows platform (except for the programming inside MS Access, which was done in VBA). I have never developed GUI front ends with forms, buttons, etc. Is there a third party free tool like MS Access that would allow me to connect to a SQLite db in the back-end and enable me to create a custom front-end to it with forms and reports? All my searches for this kind of tool only lead me to tools like SqliteStudio, which is a GUI front end for SQLite, but not a programmable one like I want. If anyone can point me towards a programmable GUI front-end development tool (preferrably open-source, but just free and well-maintained is sufficient), I would appreciate it greatly. Thank you very much. Balaji Ramanathan _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users