On Wed, Jul 22, 2009 at 12:12 PM, scabral<scabr...@lifespan.org> wrote: > > Do you know of any third party applications that i could use to build the > front end? This will need to run on local machines, not on servers. So, > some sort of desktop application i would imagine....
Applications that build applications? I am sure there must be, but as you keep on abstracting, you lose control and things get messier. Forget about local machines and servers. First, poke around sqlite.org for about 45 mins and you will have many, many of your questions answered and would have acquired a ton of background knowledge. Second, determine what programming language you know best. No matter what anyone says about Perl being the best language, the most powerful language is the one you know now. Third, find out if that language supports working with a database. That will help you determine whether you want to create a desktop application or a web-based application, which, by the way, can also run as a desktop application, that is, on a local machine. Have fun, come back, ask more questions. > > thanks > Scott > > P Kishor-3 wrote: >> >> On Wed, Jul 22, 2009 at 11:34 AM, scabral<scabr...@lifespan.org> wrote: >>> >>> HI, >>> >>> i am new to SQLite and i currently have an access database that i would >>> like >>> to convert over to a SQLite database. >>> >>> there are a couple of processes that would need to take place in order >>> for >>> this to work and i'm not sure if SQLite has these capabilities: >>> >>> 1. Need to automatically import text file into SQLite database on local >>> machine (machine always on). I was thinking of using scheduled task to >>> run >>> a script to do this, but not sure if that is possible. >> >> Sure it is possible. You will have to choose your favorite programming >> language, write a program to locate and import the local text file, >> and set up a scheduler to do so periodically. >> >>> 2. Neet to somehow create a front-end to query data from SQLite database >>> (not sure if SQLite has front end application). >> >> Lots of third-party applications. You might end up writing your own to >> suit your own requirements. >> >> >>> >>> Basically, i want to get rid of the Access database because the user's >>> have >>> to manually update the tables everyday from the text files that get ftp'd >>> over. I was trying to figure out a solution that would automatically >>> load >>> the text files withouth any human intervention and then give the user's >>> the >>> ability to view the data through some sort of front-end (similar to >>> Access >>> form). >>> >>> Thanks >>> scott >> >> -- >> Puneet Kishor http://www.punkish.org >> Carbon Model http://carbonmodel.org >> Charter Member, Open Source Geospatial Foundation http://www.osgeo.org >> Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor >> Nelson Institute, UW-Madison http://www.nelson.wisc.edu >> ----------------------------------------------------------------------- >> Assertions are politics; backing up assertions with evidence is science >> ======================================================================= >> Sent from Madison, WI, United States >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> > > -- > View this message in context: > http://www.nabble.com/Ability-to-convert-Access-to-SQLite-tp24609886p24610625.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://www.punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source Geospatial Foundation http://www.osgeo.org Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor Nelson Institute, UW-Madison http://www.nelson.wisc.edu ----------------------------------------------------------------------- Assertions are politics; backing up assertions with evidence is science ======================================================================= Sent from Madison, WI, United States _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
