You are viewing a plain text version of this content. The canonical link for it is here.
Posted to photark-dev@incubator.apache.org by Prabhath Suminda <pa...@gmail.com> on 2012/05/06 13:34:12 UTC
[GSoC] Storing metadata of photoes
Hi,
In my project I need to implement a mechanism to store metadata of
the photos. I have considered several options like a database, separate
files for each photos (e.g XML file). So can you give suggestions on what
is the best way. I think a database would be better because then we can
create complex queries. If we are going to use a database what will be the
best option (MySQL, SQLite, etc.)
Regards,
Prabhath
Re: [GSoC] Storing metadata of photoes
Posted by Suhothayan Sriskandarajah <su...@gmail.com>.
On 7 May 2012 22:24, Luciano Resende <lu...@gmail.com> wrote:
> On Mon, May 7, 2012 at 9:06 AM, Suhothayan Sriskandarajah
> <su...@gmail.com> wrote:
> > On 7 May 2012 18:56, Prabhath Suminda <pa...@gmail.com> wrote:
> >
> >> But according to my understanding we have to implement metadata storage
> in
> >> the server side first. Isn't that correct? Then we can implement the
> client
> >> side (i.e phonegap application) and syncing process.
> >>
> >
> > Here we are concentrating only on android client and not the server.
> > Further we are going to make this application to work out of the box and
> > currently we are not going to support this app from a backend server.
> >
>
> s/android client/phone device/
>
> +1
> > According to my understanding these are the mile stones.
> > Please add if I have missed any.
> >
> > 1. Build a phonegap application that can be used to view the images that
> > are in the phone.
> > 2. Define the generic metadata model
>
> What do you have in mind for the metadata model ? One way is to
> actually store subscriptions and read photo streams from 3rd party
> hosts, another way is to actually store all the metadata on the phone,
> which we have to define what type of metadata is required as the phone
> device might have space constrains.
>
> True, for now I think its easy if you use the phone itself, by this we can
reduce external constrains and
can worry about sorting metadata on line in future releases.
Further since we are using HTML5 and JS we can easily make our metadata
using JSON and store then in the file system or
in some other content repository.
> 3. Implement the metadata model & enable the user to add the data
> > 4. Enable tagging
> > 5. Build a search on this metadata model
> > 6. Automate the collection process of meta information
> > 7. Integrate the metadata for the Online Albums (After Bhargav
> Integrating
> > online albums )
> >
>
> I think concrete examples for these items might help us reach
> (including the students) to be on the same page regarding design
> directions.
>
+1
I'm trying to build some idea here. All are welcomed to direct this and
make
it to be a better solution
Regards
Suho
>
> > Suho
> >
> >>
> >> On Mon, May 7, 2012 at 12:43 AM, Suhothayan Sriskandarajah <
> >> suhothayan@gmail.com> wrote:
> >>
> >> > On 7 May 2012 00:14, Luciano Resende <lu...@gmail.com> wrote:
> >> >
> >> > > On Sun, May 6, 2012 at 6:34 AM, Prabhath Suminda
> >> > > <pa...@gmail.com> wrote:
> >> > > > Hi,
> >> > > > In my project I need to implement a mechanism to store metadata of
> >> > > > the photos. I have considered several options like a database,
> >> separate
> >> > > > files for each photos (e.g XML file). So can you give suggestions
> on
> >> > what
> >> > > > is the best way. I think a database would be better because then
> we
> >> can
> >> > > > create complex queries. If we are going to use a database what
> will
> >> be
> >> > > the
> >> > > > best option (MySQL, SQLite, etc.)
> >> > > >
> >> > > > Regards,
> >> > > > Prabhath
> >> > >
> >> > >
> >> > > We should start designing the storage solution on the mailing list,
> >> > > AFAIK the solution is going to be running on the mobile device,
> which
> >> > > probably already have some type of storage available for
> applications
> >> > > (e.g. see HTML5 storage APIs article [1]). Also, if this is going to
> >> > > be part of the phonegap client, we need to see how this would work
> >> > > together with metadata from remote albums and it need to be in sync
> >> > > with the remote information when new albums get added or existing
> one
> >> > > gets modified.
> >> > >
> >> > > [1]
> http://www.adobe.com/devnet/html5/articles/html5-storage-apis.html
> >> > >
> >> > >
> >> > +1
> >> > yes please provide an update ASAP
> >> >
> >> > Regards,
> >> > Suho
> >> >
> >> >
> >> > > --
> >> > > Luciano Resende
> >> > > http://people.apache.org/~lresende
> >> > > http://twitter.com/lresende1975
> >> > > http://lresende.blogspot.com/
> >> > >
> >> >
> >>
>
>
>
> --
> Luciano Resende
> http://people.apache.org/~lresende
> http://twitter.com/lresende1975
> http://lresende.blogspot.com/
>
Re: [GSoC] Storing metadata of photoes
Posted by Luciano Resende <lu...@gmail.com>.
On Mon, May 7, 2012 at 9:06 AM, Suhothayan Sriskandarajah
<su...@gmail.com> wrote:
> On 7 May 2012 18:56, Prabhath Suminda <pa...@gmail.com> wrote:
>
>> But according to my understanding we have to implement metadata storage in
>> the server side first. Isn't that correct? Then we can implement the client
>> side (i.e phonegap application) and syncing process.
>>
>
> Here we are concentrating only on android client and not the server.
> Further we are going to make this application to work out of the box and
> currently we are not going to support this app from a backend server.
>
s/android client/phone device/
> According to my understanding these are the mile stones.
> Please add if I have missed any.
>
> 1. Build a phonegap application that can be used to view the images that
> are in the phone.
> 2. Define the generic metadata model
What do you have in mind for the metadata model ? One way is to
actually store subscriptions and read photo streams from 3rd party
hosts, another way is to actually store all the metadata on the phone,
which we have to define what type of metadata is required as the phone
device might have space constrains.
> 3. Implement the metadata model & enable the user to add the data
> 4. Enable tagging
> 5. Build a search on this metadata model
> 6. Automate the collection process of meta information
> 7. Integrate the metadata for the Online Albums (After Bhargav Integrating
> online albums )
>
I think concrete examples for these items might help us reach
(including the students) to be on the same page regarding design
directions.
> Suho
>
>>
>> On Mon, May 7, 2012 at 12:43 AM, Suhothayan Sriskandarajah <
>> suhothayan@gmail.com> wrote:
>>
>> > On 7 May 2012 00:14, Luciano Resende <lu...@gmail.com> wrote:
>> >
>> > > On Sun, May 6, 2012 at 6:34 AM, Prabhath Suminda
>> > > <pa...@gmail.com> wrote:
>> > > > Hi,
>> > > > In my project I need to implement a mechanism to store metadata of
>> > > > the photos. I have considered several options like a database,
>> separate
>> > > > files for each photos (e.g XML file). So can you give suggestions on
>> > what
>> > > > is the best way. I think a database would be better because then we
>> can
>> > > > create complex queries. If we are going to use a database what will
>> be
>> > > the
>> > > > best option (MySQL, SQLite, etc.)
>> > > >
>> > > > Regards,
>> > > > Prabhath
>> > >
>> > >
>> > > We should start designing the storage solution on the mailing list,
>> > > AFAIK the solution is going to be running on the mobile device, which
>> > > probably already have some type of storage available for applications
>> > > (e.g. see HTML5 storage APIs article [1]). Also, if this is going to
>> > > be part of the phonegap client, we need to see how this would work
>> > > together with metadata from remote albums and it need to be in sync
>> > > with the remote information when new albums get added or existing one
>> > > gets modified.
>> > >
>> > > [1] http://www.adobe.com/devnet/html5/articles/html5-storage-apis.html
>> > >
>> > >
>> > +1
>> > yes please provide an update ASAP
>> >
>> > Regards,
>> > Suho
>> >
>> >
>> > > --
>> > > Luciano Resende
>> > > http://people.apache.org/~lresende
>> > > http://twitter.com/lresende1975
>> > > http://lresende.blogspot.com/
>> > >
>> >
>>
--
Luciano Resende
http://people.apache.org/~lresende
http://twitter.com/lresende1975
http://lresende.blogspot.com/
Re: [GSoC] Storing metadata of photoes
Posted by Suhothayan Sriskandarajah <su...@gmail.com>.
On 7 May 2012 18:56, Prabhath Suminda <pa...@gmail.com> wrote:
> But according to my understanding we have to implement metadata storage in
> the server side first. Isn't that correct? Then we can implement the client
> side (i.e phonegap application) and syncing process.
>
Here we are concentrating only on android client and not the server.
Further we are going to make this application to work out of the box and
currently we are not going to support this app from a backend server.
According to my understanding these are the mile stones.
Please add if I have missed any.
1. Build a phonegap application that can be used to view the images that
are in the phone.
2. Define the generic metadata model
3. Implement the metadata model & enable the user to add the data
4. Enable tagging
5. Build a search on this metadata model
6. Automate the collection process of meta information
7. Integrate the metadata for the Online Albums (After Bhargav Integrating
online albums )
Suho
>
> On Mon, May 7, 2012 at 12:43 AM, Suhothayan Sriskandarajah <
> suhothayan@gmail.com> wrote:
>
> > On 7 May 2012 00:14, Luciano Resende <lu...@gmail.com> wrote:
> >
> > > On Sun, May 6, 2012 at 6:34 AM, Prabhath Suminda
> > > <pa...@gmail.com> wrote:
> > > > Hi,
> > > > In my project I need to implement a mechanism to store metadata of
> > > > the photos. I have considered several options like a database,
> separate
> > > > files for each photos (e.g XML file). So can you give suggestions on
> > what
> > > > is the best way. I think a database would be better because then we
> can
> > > > create complex queries. If we are going to use a database what will
> be
> > > the
> > > > best option (MySQL, SQLite, etc.)
> > > >
> > > > Regards,
> > > > Prabhath
> > >
> > >
> > > We should start designing the storage solution on the mailing list,
> > > AFAIK the solution is going to be running on the mobile device, which
> > > probably already have some type of storage available for applications
> > > (e.g. see HTML5 storage APIs article [1]). Also, if this is going to
> > > be part of the phonegap client, we need to see how this would work
> > > together with metadata from remote albums and it need to be in sync
> > > with the remote information when new albums get added or existing one
> > > gets modified.
> > >
> > > [1] http://www.adobe.com/devnet/html5/articles/html5-storage-apis.html
> > >
> > >
> > +1
> > yes please provide an update ASAP
> >
> > Regards,
> > Suho
> >
> >
> > > --
> > > Luciano Resende
> > > http://people.apache.org/~lresende
> > > http://twitter.com/lresende1975
> > > http://lresende.blogspot.com/
> > >
> >
>
Re: [GSoC] Storing metadata of photoes
Posted by Prabhath Suminda <pa...@gmail.com>.
But according to my understanding we have to implement metadata storage in
the server side first. Isn't that correct? Then we can implement the client
side (i.e phonegap application) and syncing process.
On Mon, May 7, 2012 at 12:43 AM, Suhothayan Sriskandarajah <
suhothayan@gmail.com> wrote:
> On 7 May 2012 00:14, Luciano Resende <lu...@gmail.com> wrote:
>
> > On Sun, May 6, 2012 at 6:34 AM, Prabhath Suminda
> > <pa...@gmail.com> wrote:
> > > Hi,
> > > In my project I need to implement a mechanism to store metadata of
> > > the photos. I have considered several options like a database, separate
> > > files for each photos (e.g XML file). So can you give suggestions on
> what
> > > is the best way. I think a database would be better because then we can
> > > create complex queries. If we are going to use a database what will be
> > the
> > > best option (MySQL, SQLite, etc.)
> > >
> > > Regards,
> > > Prabhath
> >
> >
> > We should start designing the storage solution on the mailing list,
> > AFAIK the solution is going to be running on the mobile device, which
> > probably already have some type of storage available for applications
> > (e.g. see HTML5 storage APIs article [1]). Also, if this is going to
> > be part of the phonegap client, we need to see how this would work
> > together with metadata from remote albums and it need to be in sync
> > with the remote information when new albums get added or existing one
> > gets modified.
> >
> > [1] http://www.adobe.com/devnet/html5/articles/html5-storage-apis.html
> >
> >
> +1
> yes please provide an update ASAP
>
> Regards,
> Suho
>
>
> > --
> > Luciano Resende
> > http://people.apache.org/~lresende
> > http://twitter.com/lresende1975
> > http://lresende.blogspot.com/
> >
>
Re: [GSoC] Storing metadata of photoes
Posted by Suhothayan Sriskandarajah <su...@gmail.com>.
On 7 May 2012 00:14, Luciano Resende <lu...@gmail.com> wrote:
> On Sun, May 6, 2012 at 6:34 AM, Prabhath Suminda
> <pa...@gmail.com> wrote:
> > Hi,
> > In my project I need to implement a mechanism to store metadata of
> > the photos. I have considered several options like a database, separate
> > files for each photos (e.g XML file). So can you give suggestions on what
> > is the best way. I think a database would be better because then we can
> > create complex queries. If we are going to use a database what will be
> the
> > best option (MySQL, SQLite, etc.)
> >
> > Regards,
> > Prabhath
>
>
> We should start designing the storage solution on the mailing list,
> AFAIK the solution is going to be running on the mobile device, which
> probably already have some type of storage available for applications
> (e.g. see HTML5 storage APIs article [1]). Also, if this is going to
> be part of the phonegap client, we need to see how this would work
> together with metadata from remote albums and it need to be in sync
> with the remote information when new albums get added or existing one
> gets modified.
>
> [1] http://www.adobe.com/devnet/html5/articles/html5-storage-apis.html
>
>
+1
yes please provide an update ASAP
Regards,
Suho
> --
> Luciano Resende
> http://people.apache.org/~lresende
> http://twitter.com/lresende1975
> http://lresende.blogspot.com/
>
Re: [GSoC] Storing metadata of photoes
Posted by Luciano Resende <lu...@gmail.com>.
On Sun, May 6, 2012 at 6:34 AM, Prabhath Suminda
<pa...@gmail.com> wrote:
> Hi,
> In my project I need to implement a mechanism to store metadata of
> the photos. I have considered several options like a database, separate
> files for each photos (e.g XML file). So can you give suggestions on what
> is the best way. I think a database would be better because then we can
> create complex queries. If we are going to use a database what will be the
> best option (MySQL, SQLite, etc.)
>
> Regards,
> Prabhath
We should start designing the storage solution on the mailing list,
AFAIK the solution is going to be running on the mobile device, which
probably already have some type of storage available for applications
(e.g. see HTML5 storage APIs article [1]). Also, if this is going to
be part of the phonegap client, we need to see how this would work
together with metadata from remote albums and it need to be in sync
with the remote information when new albums get added or existing one
gets modified.
[1] http://www.adobe.com/devnet/html5/articles/html5-storage-apis.html
--
Luciano Resende
http://people.apache.org/~lresende
http://twitter.com/lresende1975
http://lresende.blogspot.com/
Re: [GSoC] Storing metadata of photoes
Posted by Suhothayan Sriskandarajah <su...@gmail.com>.
On 1 June 2012 06:46, Luciano Resende <lu...@gmail.com> wrote:
> On Thu, May 31, 2012 at 9:37 AM, Prabhath Suminda
> <pa...@gmail.com> wrote:
> > Yes I agree with Avdhesh. I later found Phonegap api supports SQLite
> > databases. Since this app is built on phonegap we have to use a SQLite
> > database.
> >
>
> +1 on using some index based storage, instead of some kind of
> filesystem approach. We should also investigate what is the device
> independent approach supported by Phonegap, which might indeed be the
> SQLite.
>
+1
Regards,
Suho
>
> --
> Luciano Resende
> http://people.apache.org/~lresende
> http://twitter.com/lresende1975
> http://lresende.blogspot.com/
>
Re: [GSoC] Storing metadata of photoes
Posted by Luciano Resende <lu...@gmail.com>.
On Thu, May 31, 2012 at 9:37 AM, Prabhath Suminda
<pa...@gmail.com> wrote:
> Yes I agree with Avdhesh. I later found Phonegap api supports SQLite
> databases. Since this app is built on phonegap we have to use a SQLite
> database.
>
+1 on using some index based storage, instead of some kind of
filesystem approach. We should also investigate what is the device
independent approach supported by Phonegap, which might indeed be the
SQLite.
--
Luciano Resende
http://people.apache.org/~lresende
http://twitter.com/lresende1975
http://lresende.blogspot.com/
Re: [GSoC] Storing metadata of photoes
Posted by Prabhath Suminda <pa...@gmail.com>.
Yes I agree with Avdhesh. I later found Phonegap api supports SQLite
databases. Since this app is built on phonegap we have to use a SQLite
database.
On Thu, May 31, 2012 at 7:59 PM, Avdhesh Yadav <av...@avdheshyadav.com> wrote:
> On Sun, May 6, 2012 at 7:04 PM, Prabhath Suminda <pathiranappps@gmail.com
> >wrote:
>
> > Hi,
> > In my project I need to implement a mechanism to store metadata of
> > the photos. I have considered several options like a database, separate
> > files for each photos (e.g XML file). So can you give suggestions on what
> > is the best way. I think a database would be better because then we can
> > create complex queries. If we are going to use a database what will be
> the
> > best option (MySQL, SQLite, etc.)
> >
>
> Android Supports SQLite but it does not supports JDBC.Android has its own
> API for Accessing SQL Lite Data
>
>
> >
> > Regards,
> > Prabhath
> >
>
>
>
> --
> Avdhesh Yadav
> http://www.avdheshyadav.com
> http://twitter.com/yadavavdhesh
>
Re: [GSoC] Storing metadata of photoes
Posted by Avdhesh Yadav <av...@avdheshyadav.com>.
On Sun, May 6, 2012 at 7:04 PM, Prabhath Suminda <pa...@gmail.com>wrote:
> Hi,
> In my project I need to implement a mechanism to store metadata of
> the photos. I have considered several options like a database, separate
> files for each photos (e.g XML file). So can you give suggestions on what
> is the best way. I think a database would be better because then we can
> create complex queries. If we are going to use a database what will be the
> best option (MySQL, SQLite, etc.)
>
Android Supports SQLite but it does not supports JDBC.Android has its own
API for Accessing SQL Lite Data
>
> Regards,
> Prabhath
>
--
Avdhesh Yadav
http://www.avdheshyadav.com
http://twitter.com/yadavavdhesh