You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@flex.apache.org by Manik Magar <ma...@gmail.com> on 2012/04/04 04:27:14 UTC

Database support for Adobe AIR

Hi,

Do we have any road map for AIR framework to support databases like MySql,
Oracle etc?

I had made something when i needed this and is at -
http://manikmagar.wordpress.com/2011/01/02/connecting-to-local-database-in-adobe-air/

A small java & socket based tool to talk to external database. As of now it
support DSN connection only but I am working on it to support database
interactions without DSN.

Regards,
Manik

Re: Database support for Adobe AIR

Posted by Maciek Sakrejda <m....@gmail.com>.
On Wed, Apr 11, 2012 at 9:25 AM, Omar Gonzalez
<om...@gmail.com> wrote:
> If I did add something more specific or everyone did want something like
> MongoAS3 to be donated I'd be willing.
>
> -omar

*If* we do anything in this area, I think it makes sense to follow
what Java does with JDBC: the specification and interfaces are part of
core, but the implementations are plugins. Although I'm not sure if it
makes sense to try to shoehorn something NoSQL like Mongo into the
same APIs as a traditional RDBMS...

Re: Database support for Adobe AIR

Posted by Omar Gonzalez <om...@gmail.com>.
A plugins page would be ok I think, Jeff Tapper has that eco page going,
maybe plugins need their own page.

If I did add something more specific or everyone did want something like
MongoAS3 to be donated I'd be willing.

-omar

Re: Database support for Adobe AIR

Posted by João Fernandes <jo...@gmail.com>.
I've proposed in the past that the SDK could be broken into different
blocks like core (the actual SDK) and plugins for those who might need some
additional features.

João Fernandes

On 11 April 2012 16:08, Ariel Jakobovits <ar...@yahoo.com> wrote:

> How about on a plugins page?
>
>
>
> On Apr 11, 2012, at 7:17 AM, Omar Gonzalez <om...@gmail.com>
> wrote:
>
> > I have an AS3 driver for MongoDB called MongoAS3 on GitHub. Also uses
> > Socket to implement mongo wire protocol and BSON. I'm just not sure it
> > belongs in the Flex SDK. Perhaps if I add some class mapping, but even
> then
> > does it really belong in the Flex SDK?
> >
> > -s9tpepper@apache.org
>



-- 

João Fernandes

Re: Database support for Adobe AIR

Posted by Ariel Jakobovits <ar...@yahoo.com>.
How about on a plugins page?



On Apr 11, 2012, at 7:17 AM, Omar Gonzalez <om...@gmail.com> wrote:

> I have an AS3 driver for MongoDB called MongoAS3 on GitHub. Also uses
> Socket to implement mongo wire protocol and BSON. I'm just not sure it
> belongs in the Flex SDK. Perhaps if I add some class mapping, but even then
> does it really belong in the Flex SDK?
> 
> -s9tpepper@apache.org

Re: Database support for Adobe AIR

Posted by Omar Gonzalez <om...@gmail.com>.
I have an AS3 driver for MongoDB called MongoAS3 on GitHub. Also uses
Socket to implement mongo wire protocol and BSON. I'm just not sure it
belongs in the Flex SDK. Perhaps if I add some class mapping, but even then
does it really belong in the Flex SDK?

-s9tpepper@apache.org

Re: Database support for Adobe AIR

Posted by Cosma Colanicchia <co...@gmail.com>.
I also used, for a little project, a pure as3 socket-based MySql
driver from an AIR application, called assql [1]

[1] http://code.google.com/p/assql/


2012/4/11 Maciek Sakrejda <m....@gmail.com>:
>>> Simply put, there is no roadmap in Apache Flex for AIR.  I was part of
>>> an email thread last week about ANEs, and while I am not sure they
>>> belong in the Apache Flex, I do believe that as another email thread
>>> just started about making a website that would potentially attract
>>> folks to this technology, there was a mention of 3rd party
>>> plugins...If we look at http://extensionsforair.com/, that's a great
>>> resource that if we could link to, something like Manik's project
>>> would be a marvelous contribution.
>>>
>>> @Manik - would you potentially be interested in creating this as an
>>> ANE, and contributing it to that?
>
> Note that database access for Flex does not have to be implemented as
> an ANE. I wrote a PostgreSQL driver using the raw Socket APIs in
> Flash: https://github.com/deafbybeheading/pegasus
>
> It's true that this is probably of limited usefulness outside of AIR,
> and so maybe ANEs are a simpler way to achieve generalized database
> access rather than trying to add a database access API to the Flex
> framework (à la JDBC), but I thought I'd throw this out there.

Re: Database support for Adobe AIR

Posted by Maciek Sakrejda <m....@gmail.com>.
>> Simply put, there is no roadmap in Apache Flex for AIR.  I was part of
>> an email thread last week about ANEs, and while I am not sure they
>> belong in the Apache Flex, I do believe that as another email thread
>> just started about making a website that would potentially attract
>> folks to this technology, there was a mention of 3rd party
>> plugins...If we look at http://extensionsforair.com/, that's a great
>> resource that if we could link to, something like Manik's project
>> would be a marvelous contribution.
>>
>> @Manik - would you potentially be interested in creating this as an
>> ANE, and contributing it to that?

Note that database access for Flex does not have to be implemented as
an ANE. I wrote a PostgreSQL driver using the raw Socket APIs in
Flash: https://github.com/deafbybeheading/pegasus

It's true that this is probably of limited usefulness outside of AIR,
and so maybe ANEs are a simpler way to achieve generalized database
access rather than trying to add a database access API to the Flex
framework (à la JDBC), but I thought I'd throw this out there.

Re: Database support for Adobe AIR

Posted by Manik Magar <ma...@gmail.com>.
Hi ...

Agree to JP, was little busy with other items so was away. Omar's point was clear to me that we may have air roadmap in future but for now it's not there. Apologies if I missed anything.

JP, surely I will be happy to contribute. Let me know about ANE please.

-- MM


Sent from my iPhone

On Apr 4, 2012, at 9:37 AM, JP Bader <jp...@zavteq.com> wrote:

> @Omar - I agree that that is all you said and I do not wish to put
> words into anyone else's mouth.  However the implication of your
> message (short, sweet, and to the point) apparently was (or could have
> been) misconstrued, and potentially interpreted incorrectly.
> 
> @Ariel - Manik's response doesn't mean he up and left, just that Omar
> answered his question.
> 
> Simply put, there is no roadmap in Apache Flex for AIR.  I was part of
> an email thread last week about ANEs, and while I am not sure they
> belong in the Apache Flex, I do believe that as another email thread
> just started about making a website that would potentially attract
> folks to this technology, there was a mention of 3rd party
> plugins...If we look at http://extensionsforair.com/, that's a great
> resource that if we could link to, something like Manik's project
> would be a marvelous contribution.
> 
> @Manik - would you potentially be interested in creating this as an
> ANE, and contributing it to that?
> 
> The discussions are all valid, but without facial features and vocal
> inflections, sometimes the way we is not be the way others read (cc
> @Oleg) :)
> 

> Cheers,
> 
> JP
> 
> On Wed, Apr 4, 2012 at 2:37 AM, Omar Gonzalez <om...@gmail.com> wrote:
>> On Wed, Apr 4, 2012 at 12:25 AM, Ariel Jakobovits <ar...@yahoo.com>wrote:
>> 
>>> But that's ALL you said, and his response was:
>>> 
>>> "Oh ok .. Thanks."
>>> 
>>> And the conversation was over, and he seemingly left. Is that the way we
>>> want to treat people coming to hang out and chat about Flex?
>> 
>> 
>> That's all I said because that's all I had to add to that topic. You then
>> came in and started suggesting I was defining the scope of Flex and telling
>> Manik his comment didn't belong here, both of which I did not say. Its like
>> you're putting words into my mouth that I did not type. Anyone else is free
>> to add to the topic so I don't see how the "conversation was over". Perhaps
>> you're reading far too much into my response, I'm not sure how as it was
>> not very long or ambiguous. AIR is an SDK that we do not have control over,
>> that was the end of my comment.
>> 
>> -omar
> 
> 
> 
> -- 
> JP Bader
> Principal
> Zavteq, Inc.
> @lordB8r | jp@zavteq.com
> 608.692.2468

Re: Database support for Adobe AIR

Posted by JP Bader <jp...@zavteq.com>.
@Omar - I agree that that is all you said and I do not wish to put
words into anyone else's mouth.  However the implication of your
message (short, sweet, and to the point) apparently was (or could have
been) misconstrued, and potentially interpreted incorrectly.

@Ariel - Manik's response doesn't mean he up and left, just that Omar
answered his question.

Simply put, there is no roadmap in Apache Flex for AIR.  I was part of
an email thread last week about ANEs, and while I am not sure they
belong in the Apache Flex, I do believe that as another email thread
just started about making a website that would potentially attract
folks to this technology, there was a mention of 3rd party
plugins...If we look at http://extensionsforair.com/, that's a great
resource that if we could link to, something like Manik's project
would be a marvelous contribution.

@Manik - would you potentially be interested in creating this as an
ANE, and contributing it to that?

The discussions are all valid, but without facial features and vocal
inflections, sometimes the way we is not be the way others read (cc
@Oleg) :)

Cheers,

JP

On Wed, Apr 4, 2012 at 2:37 AM, Omar Gonzalez <om...@gmail.com> wrote:
> On Wed, Apr 4, 2012 at 12:25 AM, Ariel Jakobovits <ar...@yahoo.com>wrote:
>
>> But that's ALL you said, and his response was:
>>
>> "Oh ok .. Thanks."
>>
>> And the conversation was over, and he seemingly left. Is that the way we
>> want to treat people coming to hang out and chat about Flex?
>
>
> That's all I said because that's all I had to add to that topic. You then
> came in and started suggesting I was defining the scope of Flex and telling
> Manik his comment didn't belong here, both of which I did not say. Its like
> you're putting words into my mouth that I did not type. Anyone else is free
> to add to the topic so I don't see how the "conversation was over". Perhaps
> you're reading far too much into my response, I'm not sure how as it was
> not very long or ambiguous. AIR is an SDK that we do not have control over,
> that was the end of my comment.
>
> -omar



-- 
JP Bader
Principal
Zavteq, Inc.
@lordB8r | jp@zavteq.com
608.692.2468

Re: Database support for Adobe AIR

Posted by Omar Gonzalez <om...@gmail.com>.
On Wed, Apr 4, 2012 at 12:25 AM, Ariel Jakobovits <ar...@yahoo.com>wrote:

> But that's ALL you said, and his response was:
>
> "Oh ok .. Thanks."
>
> And the conversation was over, and he seemingly left. Is that the way we
> want to treat people coming to hang out and chat about Flex?


That's all I said because that's all I had to add to that topic. You then
came in and started suggesting I was defining the scope of Flex and telling
Manik his comment didn't belong here, both of which I did not say. Its like
you're putting words into my mouth that I did not type. Anyone else is free
to add to the topic so I don't see how the "conversation was over". Perhaps
you're reading far too much into my response, I'm not sure how as it was
not very long or ambiguous. AIR is an SDK that we do not have control over,
that was the end of my comment.

-omar

Re: Database support for Adobe AIR

Posted by Ariel Jakobovits <ar...@yahoo.com>.
But that's ALL you said, and his response was:

"Oh ok .. Thanks."

And the conversation was over, and he seemingly left. Is that the way we want to treat people coming to hang out and chat about Flex?


On Apr 4, 2012, at 12:19 AM, Omar Gonzalez <om...@gmail.com> wrote:

> On Wednesday, April 4, 2012, Ariel Jakobovits wrote:
> 
>> Well, then can we agree that your initial response to the poster that his
>> comment did not belong on this list because we are not developing AIR was
>> not a appropriate response?
> 
> 
> No because I did not say such a thing. All I said was that AIR was not
> under Apache Flex.
> 
> -omar

Re: Database support for Adobe AIR

Posted by Omar Gonzalez <om...@gmail.com>.
On Wednesday, April 4, 2012, Ariel Jakobovits wrote:

> Well, then can we agree that your initial response to the poster that his
> comment did not belong on this list because we are not developing AIR was
> not a appropriate response?


No because I did not say such a thing. All I said was that AIR was not
under Apache Flex.

-omar

Re: Database support for Adobe AIR

Posted by Ariel Jakobovits <ar...@yahoo.com>.
Well, then can we agree that your initial response to the poster that his comment did not belong on this list because we are not developing AIR was not a appropriate response?

I'm not arguing for the sake of arguing. I'm making sure we don't send people packing because we don't understand their initial post, and don't turn away ideas that might be an important part of the still uncertain future of flex.



On Apr 3, 2012, at 10:56 PM, Omar Gonzalez <om...@gmail.com> wrote:

> On Tuesday, April 3, 2012, Martin Heidegger wrote:
> 
>> On 04/04/2012 14:21, Omar Gonzalez wrote:
>> 
>>> ... whether we should be developing ANEs for the Flex framework, etc.
>>> 
>> 
>> I think that topic can be handled like any other topic: If someone is
>> interested working on it: Let them. I do not see a reason to veto on it.
>> There are already air specific classes in the sdk.
>> 
>> yours
>> Martin.
>> 
> 
> I wasn't vetoing or suggesting that ANEs be vetoed. I was saying we haven't
> reached a consensus about including ANEs in Apache Flex and nobody has
> contributed one for us to vote on or veto.
> 
> -omar

Re: Database support for Adobe AIR

Posted by Omar Gonzalez <om...@gmail.com>.
On Tuesday, April 3, 2012, Martin Heidegger wrote:

> On 04/04/2012 14:21, Omar Gonzalez wrote:
>
>> ... whether we should be developing ANEs for the Flex framework, etc.
>>
>
> I think that topic can be handled like any other topic: If someone is
> interested working on it: Let them. I do not see a reason to veto on it.
> There are already air specific classes in the sdk.
>
> yours
> Martin.
>

I wasn't vetoing or suggesting that ANEs be vetoed. I was saying we haven't
reached a consensus about including ANEs in Apache Flex and nobody has
contributed one for us to vote on or veto.

-omar

Re: Database support for Adobe AIR

Posted by Martin Heidegger <mh...@leichtgewicht.at>.
On 04/04/2012 14:21, Omar Gonzalez wrote:
> ... whether we should be developing ANEs for the Flex framework, etc. 

I think that topic can be handled like any other topic: If someone is 
interested working on it: Let them. I do not see a reason to veto on it.
There are already air specific classes in the sdk.

yours
Martin.

Re: Database support for Adobe AIR

Posted by Omar Gonzalez <s9...@apache.org>.
On Tue, Apr 3, 2012 at 10:04 PM, Ariel Jakobovits <ar...@yahoo.com>wrote:

> > AIR is not part of the Apache Flex project
>
> I don't understand this response. Omar, perhaps you can define for me what
> is in scope for Flex and what isn't. From Adobe's flex homepage:
>
> "Flex is a powerful, open source application framework that allows you to
> easily build mobile applications for iOS, Android™, and BlackBerry® Tablet
> OS devices, as well as traditional applications for browser and desktop
> using the same programming model, tool, and codebase.
>
> Server integration
> Integrate with all major back ends including Java™, Spring, Hibernate,
> PHP, Ruby, .NET, Adobe ColdFusion®, and SAP using industry standards such
> as REST, SOAP, JSON, JMS, and AMF."
>
> Why would a set of components, visual or not, that allow one to connect to
> a database natively not be complementary to an open source application
> framework that allows you to easily build applications?
>
>
>
> Ariel Jakobovits
> Email: arieljake@yahoo.com
> Phone: 650-690-2213
> Fax: 650-641-0031
> Cell: 650-823-8699


This was written at a time when the distinction between Flex and AIR was
not as important to Adobe because they were actively developing both
platforms. However, AIR was not donated to Apache and the original question
by Manik was about the AIR Roadmap. Since AIR has not been donated we do
not have an AIR roadmap, nor can we add functionality directly to AIR
because it is not under our control.

To be honest it doesn't really matter to me what Adobe has on their
homepages about Adobe Flex at this point because it is now Apache Flex and
it is up to us to determine what we will and will not include in the
framework. I was just making it clear that we do not have the ability to
add to AIR directly.

It has been brought up a couple of times whether we should, or should not,
add ANEs to the project for use in Flex applications deployed on the AIR
runtime. I don't think there was a consensus reached either way. Manik
mentioned his solution involved Java and a socket, which leads me to
believe his solution would require an ANE. So this leads back to the
discussion on whether we should be developing ANEs for the Flex framework,
etc.


-- 
Omar Gonzalez
s9tpepper@apache.org

Re: Database support for Adobe AIR

Posted by Ariel Jakobovits <ar...@yahoo.com>.
> AIR is not part of the Apache Flex project

I don't understand this response. Omar, perhaps you can define for me what is in scope for Flex and what isn't. From Adobe's flex homepage:

"Flex is a powerful, open source application framework that allows you to easily build mobile applications for iOS, Android™, and BlackBerry® Tablet OS devices, as well as traditional applications for browser and desktop using the same programming model, tool, and codebase.

Server integration
Integrate with all major back ends including Java™, Spring, Hibernate, PHP, Ruby, .NET, Adobe ColdFusion®, and SAP using industry standards such as REST, SOAP, JSON, JMS, and AMF."

Why would a set of components, visual or not, that allow one to connect to a database natively not be complementary to an open source application framework that allows you to easily build applications?



Ariel Jakobovits
Email: arieljake@yahoo.com
Phone: 650-690-2213
Fax: 650-641-0031
Cell: 650-823-8699


________________________________
From: Omar Gonzalez <s9...@apache.org>
To: flex-dev@incubator.apache.org 
Sent: Tuesday, April 3, 2012 8:02 PM
Subject: Re: Database support for Adobe AIR

On Tue, Apr 3, 2012 at 7:27 PM, Manik Magar <ma...@gmail.com> wrote:

> Hi,
>
> Do we have any road map for AIR framework to support databases like MySql,
> Oracle etc?
>
> I had made something when i needed this and is at -
>
> http://manikmagar.wordpress.com/2011/01/02/connecting-to-local-database-in-adobe-air/
>
> A small java & socket based tool to talk to external database. As of now it
> support DSN connection only but I am working on it to support database
> interactions without DSN.
>
> Regards,
> Manik
>

Hi Manik,

AIR is not part of the Apache Flex project, it is still owned and being
developed by Adobe.


-- 
Omar Gonzalez
s9tpepper@apache.org 

Re: Database support for Adobe AIR

Posted by Manik Magar <ma...@gmail.com>.
Oh ok .. Thanks.

On Tue, Apr 3, 2012 at 11:02 PM, Omar Gonzalez <s9...@apache.org> wrote:

> On Tue, Apr 3, 2012 at 7:27 PM, Manik Magar <ma...@gmail.com> wrote:
>
> > Hi,
> >
> > Do we have any road map for AIR framework to support databases like
> MySql,
> > Oracle etc?
> >
> > I had made something when i needed this and is at -
> >
> >
> http://manikmagar.wordpress.com/2011/01/02/connecting-to-local-database-in-adobe-air/
> >
> > A small java & socket based tool to talk to external database. As of now
> it
> > support DSN connection only but I am working on it to support database
> > interactions without DSN.
> >
> > Regards,
> > Manik
> >
>
> Hi Manik,
>
> AIR is not part of the Apache Flex project, it is still owned and being
> developed by Adobe.
>
>
> --
> Omar Gonzalez
> s9tpepper@apache.org
>

Re: Database support for Adobe AIR

Posted by Omar Gonzalez <s9...@apache.org>.
On Tue, Apr 3, 2012 at 7:27 PM, Manik Magar <ma...@gmail.com> wrote:

> Hi,
>
> Do we have any road map for AIR framework to support databases like MySql,
> Oracle etc?
>
> I had made something when i needed this and is at -
>
> http://manikmagar.wordpress.com/2011/01/02/connecting-to-local-database-in-adobe-air/
>
> A small java & socket based tool to talk to external database. As of now it
> support DSN connection only but I am working on it to support database
> interactions without DSN.
>
> Regards,
> Manik
>

Hi Manik,

AIR is not part of the Apache Flex project, it is still owned and being
developed by Adobe.


-- 
Omar Gonzalez
s9tpepper@apache.org