Thanks for the heads-up, Jean-Denis. I was going to try to deploy the almost-finished Flex/AIR app on my wife's Mac notebook this weekend to see how it goes. That it works quickly under Windows XP is all I know at this point. I am very concerned about query performance and app responsiveness, but much less concerned about native look-and-feel. I've done what I could to keep the app responsive by using asynchronous data connections.
I didn't mention that I must operate under certain licensing constraints. The universities who own the rights to this data (and other similar sets of data) forbid third-parties to put the data on their own web-servers for any use beyond personal; so my app must use a local copy of the data that the end-users have licensed for their own personal use. The question about the flip function() -- it is not that I am unable to do it on the front-end. But if the Unicode string, possibly containing decomposed characters, is flipped on the front-end and sent back to the database for insertion into a row, I will have no control over how the wrapper/provider/middleware interprets the string of codepoints in "raw" (read "possibly malformed") representation for insertion into a Text field. I want to sidestep that issue by having the flip() done by the database. Regards Tim Romano Jean-Denis Muys wrote: > On 11/19/09 14:55 , "Tim Romano" <tim.rom...@yahoo.com> wrote: > > > >> The app was written in .NET against MS-Access; my Macintosh colleagues >> couldn't use it. They outnumbered the Windows users. But I didn't own a >> Mac and had never programmed on a Mac. But now Adobe Flex/AIR with >> SQLite is available, and it offers cross-platform deployment. So I've >> rewritten the app in Flex ActionScript using SQLite as the back-end. >> >> > > Tim, > > I have absolutely no opinion on flip(), neither for nor against. However, I > do have an opinion on using Adobe Flex or Microsoft Silverlight as > "cross-platform" tools to bring software to the Mac. > > In one word: bad. > > These tools will not let you easily write an app that feels native on the > Mac. Your colleagues might use it if forced to, exactly as they could use > your previous .net app using a virtual machine, but they are likely to drag > their feet. > > Additionally, there are very serious efficiency/resource consumption issues > with the Mac version of Flash/Air on the Mac. > > I don't think there is a satisfactory answer to cross platform development > of native GUI apps. The best you can do is possibly a web app. With such > tools as client-side databases, HTML 5 and Capuccino, you might end-up not > too far from a native look and feel. > > Also modern Javascript JIT compilers will let your write your own fast > flip() function. > > All this IMHO of course. > > Jean-Denis > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ------------------------------------------------------------------------ > > > No virus found in this incoming message. > Checked by AVG - www.avg.com > Version: 8.5.425 / Virus Database: 270.14.73/2512 - Release Date: 11/18/09 > 19:41:00 > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
