Mike Chambers

code = joy

Apollo Beta will include SQLite Embedded Database

with 40 comments

Google announced their Google Gears project today which uses SQLite to allow browser based applications to work off-line. (Ryan and JD have more info on that). Part of the announcement was that the upcoming beta of Apollo will also include SQLite to allow developers access to an embedded database for their applications.

This has probably been the #1 request we have heard from developers since we release the alpha, and with a tons of help from the Flex team, we were able to add it.

We will be releasing more information once the Apollo beta is public on labs (sooner rather than later).

Update: I meant to add that we are working on aligning the Apollo DB and Gears DB apis, with the goal of making it easier to build applications and code that can leverage both API implementations (on the desktop and in the browser).

Written by mikechambers

May 30th, 2007 at 8:10 pm

Posted in air

40 Responses to 'Apollo Beta will include SQLite Embedded Database'

Subscribe to comments with RSS or TrackBack to 'Apollo Beta will include SQLite Embedded Database'.

  1. Thats just great news Mike. Very cool to hear this. That really make me want to change the way I build apps. I am thinking now that I would build all my apps powered from the DB with another module communicating with the webserver to find updates.

    This is even more fascinating, I could even mirror across the wire my server database to SqlLite, then my Apollo app could pull out any data it wants without having to build all this complicated asynchronous XML/AMF/Remoting on the client and server. Wow this is really really cool. Great work.

    John Ballinger

    30 May 07 at 8:31 pm

  2. Hi,
    Would I be able to design and build an Apollo Application that runs off a CD ROM so that clients can use it like the Flash projector (no installer)? If so, would this database option permit me to write and save to the user’s drive so that data would be available to then when re-inserting the CD? Just wondering… maybe that’s never been what Apollo was supposed to be about.

    Chris Clark

    31 May 07 at 12:00 am

  3. [...] Lets the people who know more talk about this. This doesnt need any comment. [...]

  4. excellent news.

    I’m looking at pulling just enough data across the wire and store locally to then run OLAP and other complex queries and views for further manipulation

    Mike, this why some of the proposed advanced datagrids and charting for the flex3 SDK will be so important.

    thanks to the team for getting this going.

    barry.b

    31 May 07 at 2:03 am

  5. [...] (5/31): Mike Chambers spills that beans that Apollo will support SQLite as well! Share and Enjoy: These icons link to social bookmarking [...]

  6. [...] Mike Chambers posted some awesome news today. This is a big step for Apollo and a much needed feature. The Apollo Beta (to be released “sooner rather than later”) will include an embedded SQLite database to aid in the creation of occasionally connected Apollo applications. [...]

  7. [...] Mike Chambers anunció en su blog que la versión beta de Apollo tendría soporte nativo para manejar bases de datos embebidas SQLite. [...]

  8. [...] Apollo Beta will include SQLite Embedded Database and Google Gears Mike Chambers » Blog Archive » Apollo Beta will include SQLite Embedded Database: [...]

  9. Yes.

    Yes, yes, yes.

    I started using SQLite in my Python work a few years ago, and it totally changed the way I write code. Being able to instantiate cheap, transient databases in RAM means not needing to build unwieldy tangles of arrays and hashes just to emulate SQL-like semantics. Since then I’ve been wishing for this feature in everything else I do, esp. Javascript and Actionscript.

    Michal Migurski

    31 May 07 at 8:20 am

  10. [...] Mike Chambers has clarified this in regard to Apollo: we are working on aligning the Apollo DB and Gears DB apis, with the goal [...]

  11. Crazy great news! Can’t wait to learn more and put together an API.
    Already designing one!

    david

    31 May 07 at 9:48 am

  12. I think this is a great thing, the potential for Apollo has grown immensely with the addition of Google Gears and SQLite.

    Question:
    Will the SQLite db be available from Apollo via an AS class or will it be available through the Google Gears API? I guess what I am asking is if I want to integrate the SQLite db with an Apollo application will I need to go through the Google Gears API?

    Thanks.

    Lar

    31 May 07 at 10:24 am


  13. Will the SQLite db be available from Apollo via an AS class or will it be available through the Google Gears API?

    It will be available via both JavaScript and ActionScript.

    mike chambers

    mesh@adobe.com

    mikechambers

    31 May 07 at 11:07 am

  14. This is REALLY great news. I was hoping for something like this is the Beta version!! Great job guys!

    Mike Huntington

    31 May 07 at 11:42 am

  15. [...] application platforms, which have their roots in the web: Adobe Apollo, Google Gears (with some collaboration with Adobe), and potentially tools similar to Joyent Slingshot or LINA or just straight apps-on-VMs. And [...]

  16. That’s something we’ve been waiting From Flash Plattform a lot of years ago. It’s a great new.

    Jorge Díaz Gutiérrez

    31 May 07 at 1:35 pm

  17. [...] Just thought I’d mention that Mike Chambers mentions on his blog that Apollo will include a SQLite database for similar functionality as what I have written, and Christophe Coenraets has code for Google [...]

  18. [...] Mike Chambers writes that Adobe’s Apollo platform will include the SQLite embedded database. Google Gears also uses SQLite. This is sweet. [...]

  19. I don’t usually leave “me too” comments, but this is such great news! Thank you!!! (I was hoping this was going to be announced at the RailsConf Apollo sessions, but I’m not complaining :)

    Peter Armstrong

    31 May 07 at 5:10 pm

  20. [...] Ryan Stewart Mike Chambers (announcing SQLite in Apollo) [...]

  21. [...] Se ha escuchado a los desarrolladores y la próxima beta de Apollo incluirá un motor RDBMS embedido, concretamente SQLite, lo cual es una gran noticia. Con esta nueva característica se abre un nuevo mundo para el desarrollo de aplicaciones de escritorio con Apollo. Sin duda una gran decisión. [ fuente ] [...]

  22. Great to see this being implemented as I remember alot of people asking for this on FlexCoders (including me, who suggested SQLite).

    Way to go..

    Muzak

    1 Jun 07 at 1:57 am

  23. [...] y por supuesto, Google Gears. Ahora el arquitecto de Adobe Apollo, Mike Chambers,y en su blog anuncia que Apollo Beta incluirá apoyo a [...]

  24. WOW!!!!!!! This great news. I’ve been wondering if that would make it into the Apollo product line. But this is huge. This means that developers could build API’s similar to that of Apple’s CoreData.

    Cheers guys and thanks for all of the hard work!!

    -Sam

    Samuel Agesilas

    1 Jun 07 at 7:12 am

  25. [...] más info: Mike Chambers [...]

  26. that’s wonderful, i really appreciate it will be an open and well-known database system, keep on going …

    cinzia

    1 Jun 07 at 9:21 am

  27. [...] that has been working on similar functionality, Adobe has welcomed it with open arms by announcing work to align APIs, while Mozilla is keeping it at arms [...]

  28. [...] Apollo Beta will include SQLite Embedded Database [...]

  29. Mike, will apollo be able to save the db file out to an external location and load it back in? For example i’m working on an authering app so i’d like to save the db, xml, assets out to a project folder so the user can have many projects from the apollo app and just open the project when they want to edit. Or will it be one DB for each apollo app instance?

    ethan estes

    7 Jun 07 at 8:17 am

  30. You can save it wherever you want. Heck, you could save it on a web server if you wanted to.

    mike chambers

    mesh@adobe.com

    mike chambers

    7 Jun 07 at 8:20 am

  31. [...] Apollo Beta will include SQLite Embedded Database, où l’on apprend qu’Adobe conserve tout de même une longueur d’avance sur la prochaine version d’Apollo qui intègrera une mini-base de données. [...]

  32. [...] it’s finally been announced. Apollo will come with sqlite support, now all we need is ActiveRecord for [...]

  33. [...] hören wir z.B. von Mike Chambers das die AIR Beta eine eingebettete SQLite Datenbank mit an Bord haben wird. Kevin Hoyt zeigt uns wie wir auf File Icons zugreifen können. In seinem [...]

  34. [...] rightly so. Other frameworks are jumping on the bandwagon too. Dojo can now utilize Gears, Adobe’s ApolloAIR, and from Scoble’s blog, a host of others will soon be supported too.The motivating factor behind [...]

  35. Hey All ! ! !
    Successful people say “Time is money”,
    go Clock ,
    and make sure that …

    Shahsem

    20 Aug 07 at 9:11 pm

  36. Hello, very nice site, keep up good job!
    Admin good, very good.

    Stasigrii

    4 Nov 07 at 8:18 am

  37. [...] Mike Chambers noticiou que o Apollo terá o SQLite imbutido como banco de dados para que os desenvolvedores possam incluir um banco de dados em seus aplicativos, quem já trabalha com PHP-GTK e PHP 5 conhece esse recurso. O Google anunciou também um pacote de desenvolvimento que também tem o SQLite incluido, o GoogleGears. del.icio.us | digg! | furl | reddit | rojo | yahoo! | rec6 | dzone | Bloglines | Eu Curti [...]

  38. [...] Database module (uses SQLite) stores the updates and provides the information needed. (news) [...]

  39. [...] Mike Chambers » Blog Archive » Apollo Beta will include SQLite Embedded Database [...]

  40. [...] mundo para el desarrollo de aplicaciones de escritorio con Apollo. Sin duda una gran decisión. [ fuente ] June 1, 2007 | Filed Under [...]

Leave a Reply

Follow

Get every new post on this blog delivered to your Inbox.

Join other followers: