Apollo Beta will include SQLite Embedded Database
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).
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 edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
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 edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
[...] Lets the people who know more talk about this. This doesnt need any comment. [...]
Here it is - sqlite in Apollo ! at mooska
31 May 07 at 1:44 am edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
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 edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
[...] (5/31): Mike Chambers spills that beans that Apollo will support SQLite as well! Share and Enjoy: These icons link to social bookmarking [...]
Who's Offline? Google Gears...
31 May 07 at 4:08 am edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
[...] 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. [...]
B L O G N A | all things web |
31 May 07 at 5:19 am edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
[...] Mike Chambers anunció en su blog que la versión beta de Apollo tendrÃa soporte nativo para manejar bases de datos embebidas SQLite. [...]
Eric Kersten Weblog » Blog Archive » La beta de Apollo incluirÃa soporte para SQLite
31 May 07 at 5:48 am edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
[...] Apollo Beta will include SQLite Embedded Database and Google Gears Mike Chambers » Blog Archive » Apollo Beta will include SQLite Embedded Database: [...]
Apollo Beta will include SQLite Embedded Database and Google Gears « Brainstorming Tech
31 May 07 at 8:12 am edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
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 edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
[...] Mike Chambers has clarified this in regard to Apollo: we are working on aligning the Apollo DB and Gears DB apis, with the goal [...]
JosephLabrecque.com » Archive » Google Gears and Apollo... and Tubes?
31 May 07 at 9:47 am edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
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 edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
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 edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
–
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 edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
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 edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
[...] 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 [...]
The mainstream API of the future | Leancode
31 May 07 at 11:54 am edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
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 edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
[...] 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 [...]
Coding with Scott » Google Gears For All! (A Flash-Gears Bridge)
31 May 07 at 4:10 pm edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
[...] Mike Chambers writes that Adobe’s Apollo platform will include the SQLite embedded database. Google Gears also uses SQLite. This is sweet. [...]
Cloudy Thinking » Blog Archive » Mike Chambers: Apollo to Incorporate SQLite Database
31 May 07 at 5:05 pm edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
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 edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
[...] Ryan Stewart Mike Chambers (announcing SQLite in Apollo) [...]
Google Gears and Adobe Apollo on SQLite at Flex Daddy
31 May 07 at 11:39 pm edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
[...] 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 ] [...]
Joan | Garnet Flex:Flash:PHP:MySQL:JS » Apollo incluirá SQLite
1 Jun 07 at 12:09 am edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
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 edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
[...] y por supuesto, Google Gears. Ahora el arquitecto de Adobe Apollo, Mike Chambers,y en su blog anuncia que Apollo Beta incluirá apoyo a [...]
SQL-Lite: El secreto de las aplicaciones web fuera de lÃnea :
1 Jun 07 at 3:28 am edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
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 edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
[...] más info: Mike Chambers [...]
blog.2grafic.com » Blog Archive » Apollo con SQLite
1 Jun 07 at 7:56 am edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
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 edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
[...] 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 [...]
Sans Browser » Blog Archive » Mozilla and Adobe Gears Reponses
2 Jun 07 at 3:24 am edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
[...] Apollo Beta will include SQLite Embedded Database [...]
Apollo to ship with SQLite! « Flex Fanatic
6 Jun 07 at 7:58 am edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
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 edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
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 edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
[...] 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. [...]
Google se lance des les applications en ligne déconnectées by e5k
7 Jun 07 at 8:24 am edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
[...] it’s finally been announced. Apollo will come with sqlite support, now all we need is ActiveRecord for [...]
Eribium » Blog Archive » Apollo & Sqlite
11 Jun 07 at 1:36 am edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
[...] 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 [...]
Oliver Storm » Blog Archive » Adobe AIR was gibts neues!?
18 Jun 07 at 11:01 pm edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
[...] 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 [...]
Intel® Software Network Blogs » Blog Archive » Connectivity is only part of the user experience
23 Jul 07 at 5:14 pm edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
Hey All ! ! !
Successful people say “Time is money”,
go Clock ,
and make sure that …
Shahsem
20 Aug 07 at 9:11 pm edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
Hello, very nice site, keep up good job!
Admin good, very good.
Stasigrii
4 Nov 07 at 8:18 am edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
[...] 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 [...]
Leonardo França » Apollo Beta com SQLite como banco de dados
3 Feb 08 at 4:49 am edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
[...] Database module (uses SQLite) stores the updates and provides the information needed. (news) [...]
Adobe AIR vs Google Gear | Solution Hacker
16 Apr 08 at 10:24 am edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
[...] Mike Chambers » Blog Archive » Apollo Beta will include SQLite Embedded Database [...]
???WordPress.com???“Gears”????Google Gears???? — hibilog 2008
3 Jul 08 at 12:34 am edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>
[...] mundo para el desarrollo de aplicaciones de escritorio con Apollo. Sin duda una gran decisión. [ fuente ] June 1, 2007 | Filed Under [...]
Apollo incluirá SQLite : Joan Garnet :: Arquitectura y desarrollo RIA
1 Jan 10 at 11:39 am edit_comment_link(__('Edit', 'sandbox'), ' ', ''); ?>