Re: [Flashcoders] Couple questions re Zinc and Access
We've written an application using MSAccess DB. It was slow. Took longer than it would using a webservice. What's worse is Zinc runs those commands synchronous. Freezes the app for several seconds - until the command is complete. There is a toggle to use the API asynchronous, but this does not work. I did a side by side test with SQLite, and though it responds a couple hundred milliseconds quicker, it's still pretty slow... I mean, a couple hundred milliseconds is a long time in and of itself when you're speaking desktop level responsibility. This was about a year ago, so things may have changed... Just a friendly heads up. On 7/29/07, Troy Rollins [EMAIL PROTECTED] wrote: On Jul 29, 2007, at 2:37 PM, John Hattan wrote: FWIW, here's the page for my SQLite glue-DLL for Zinc. The Mac version works with mProjector, which is what I'm using for the Mac games (Zinc for Mac doesn't do universal binaries). Oh cool, I lost touch with mProjector... I hadn't realized they had gotten UB completed, and I see they even have a beta in place for AS3 and FlexBuilder compatibility. Sweet, gotta check that out. -- Troy RPSystems, Ltd. http://www.rpsystems.net ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com
Re: [Flashcoders] Couple questions re Zinc and Access
Dave, Try the flat file DB called SQLite. There is an open source dll (mac version also) which connects Zinc to SQLIte DB. This is very simple and you dont need to worry about ODBC and stuffs... The SQLite is capable of handling almost all the SQL queries also. -Vipin On 7/26/07, Dave Burnett [EMAIL PROTECTED] wrote: Hi all; I'm looking to connect a projector to an Access db, both on CD. Looks like Zinc will do this, but I'm curious if any folks with experience in the area could enlighten me: 1. Are there any client requirements? MDAC version? Do I have to make an ODBC connection? 2. What does Zinc mean when they say the recordset can be dumped in a simple XML format? e.g. is there any control over the XML structure, or is it WYSIWYG? Thanks. Dave _ http://imagine-windowslive.com/hotmail/?locale=en-usocid=TXT_TAGHM_migration_HM_mini_pcmag_0507 ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com
Re: [Flashcoders] Couple questions re Zinc and Access
Thanks Vipin, I'll check that out. So I take it using Access with Zinc will have client requirements, MDAC etc? Dave From: vipin chandran [EMAIL PROTECTED] Reply-To: flashcoders@chattyfig.figleaf.com To: flashcoders@chattyfig.figleaf.com Subject: Re: [Flashcoders] Couple questions re Zinc and Access Date: Sun, 29 Jul 2007 11:29:19 +0530 Dave, Try the flat file DB called SQLite. There is an open source dll (mac version also) which connects Zinc to SQLIte DB. This is very simple and you dont need to worry about ODBC and stuffs... The SQLite is capable of handling almost all the SQL queries also. -Vipin On 7/26/07, Dave Burnett [EMAIL PROTECTED] wrote: Hi all; I'm looking to connect a projector to an Access db, both on CD. Looks like Zinc will do this, but I'm curious if any folks with experience in the area could enlighten me: 1. Are there any client requirements? MDAC version? Do I have to make an ODBC connection? 2. What does Zinc mean when they say the recordset can be dumped in a simple XML format? e.g. is there any control over the XML structure, or is it WYSIWYG? Thanks. Dave _ http://imagine-windowslive.com/hotmail/?locale=en-usocid=TXT_TAGHM_migration_HM_mini_pcmag_0507 ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com _ http://newlivehotmail.com ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com
Re: [Flashcoders] Couple questions re Zinc and Access
Nope, if your requirements hangs around a PC then, access can be used easily. But if you are looking for a hybrid (PC and Mac) then go with SQLite and this library. -Vipin On 7/29/07, Dave Burnett [EMAIL PROTECTED] wrote: Thanks Vipin, I'll check that out. So I take it using Access with Zinc will have client requirements, MDAC etc? Dave From: vipin chandran [EMAIL PROTECTED] Reply-To: flashcoders@chattyfig.figleaf.com To: flashcoders@chattyfig.figleaf.com Subject: Re: [Flashcoders] Couple questions re Zinc and Access Date: Sun, 29 Jul 2007 11:29:19 +0530 Dave, Try the flat file DB called SQLite. There is an open source dll (mac version also) which connects Zinc to SQLIte DB. This is very simple and you dont need to worry about ODBC and stuffs... The SQLite is capable of handling almost all the SQL queries also. -Vipin On 7/26/07, Dave Burnett [EMAIL PROTECTED] wrote: Hi all; I'm looking to connect a projector to an Access db, both on CD. Looks like Zinc will do this, but I'm curious if any folks with experience in the area could enlighten me: 1. Are there any client requirements? MDAC version? Do I have to make an ODBC connection? 2. What does Zinc mean when they say the recordset can be dumped in a simple XML format? e.g. is there any control over the XML structure, or is it WYSIWYG? Thanks. Dave _ http://imagine-windowslive.com/hotmail/?locale=en-usocid=TXT_TAGHM_migration_HM_mini_pcmag_0507 ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com _ http://newlivehotmail.com ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com
Re: [Flashcoders] Couple questions re Zinc and Access
Glad you like it :) FWIW, here's the page for my SQLite glue-DLL for Zinc. The Mac version works with mProjector, which is what I'm using for the Mac games (Zinc for Mac doesn't do universal binaries). http://www.thecodezone.com/downloads/sqlite.html - Original Message From: vipin chandran [EMAIL PROTECTED] To: flashcoders@chattyfig.figleaf.com Sent: Sunday, July 29, 2007 12:59:19 AM Subject: Re: [Flashcoders] Couple questions re Zinc and Access Dave, Try the flat file DB called SQLite. There is an open source dll (mac version also) which connects Zinc to SQLIte DB. This is very simple and you dont need to worry about ODBC and stuffs... The SQLite is capable of handling almost all the SQL queries also. -Vipin On 7/26/07, Dave Burnett [EMAIL PROTECTED] wrote: Hi all; I'm looking to connect a projector to an Access db, both on CD. Looks like Zinc will do this, but I'm curious if any folks with experience in the area could enlighten me: 1. Are there any client requirements? MDAC version? Do I have to make an ODBC connection? 2. What does Zinc mean when they say the recordset can be dumped in a simple XML format? e.g. is there any control over the XML structure, or is it WYSIWYG? Thanks. Dave _ http://imagine-windowslive.com/hotmail/?locale=en-usocid=TXT_TAGHM_migration_HM_mini_pcmag_0507 ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com
Re: [Flashcoders] Couple questions re Zinc and Access
On Jul 29, 2007, at 2:37 PM, John Hattan wrote: FWIW, here's the page for my SQLite glue-DLL for Zinc. The Mac version works with mProjector, which is what I'm using for the Mac games (Zinc for Mac doesn't do universal binaries). Oh cool, I lost touch with mProjector... I hadn't realized they had gotten UB completed, and I see they even have a beta in place for AS3 and FlexBuilder compatibility. Sweet, gotta check that out. -- Troy RPSystems, Ltd. http://www.rpsystems.net ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com
[Flashcoders] Couple questions re Zinc and Access
Hi all; I'm looking to connect a projector to an Access db, both on CD. Looks like Zinc will do this, but I'm curious if any folks with experience in the area could enlighten me: 1. Are there any client requirements? MDAC version? Do I have to make an ODBC connection? 2. What does Zinc mean when they say the recordset can be dumped in a simple XML format? e.g. is there any control over the XML structure, or is it WYSIWYG? Thanks. Dave _ http://imagine-windowslive.com/hotmail/?locale=en-usocid=TXT_TAGHM_migration_HM_mini_pcmag_0507 ___ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com