Labs/Joey: Difference between revisions

From MozillaWiki
Jump to navigation Jump to search
Line 26: Line 26:
* Scheme: [http://svn.mozilla.org/labs/joey/trunk/servers/db/tables.sql]
* Scheme: [http://svn.mozilla.org/labs/joey/trunk/servers/db/tables.sql]


What the tables look like:
for all media there is associated meta data, right.. url it is from, date.size, ect.


<pre>
for some media we use the "content" field to store the data.


mysql> show tables;
for other media we use the file system to store the data.
+-------------------+
| Tables_in_joey_db |
+-------------------+
| upload            |
| user              |
+-------------------+


mysql> select * from user where id=1;
the filename can be null for a number of reasons:
+----+-------+------------------------------------------+----------------+---------------------+--------------+--------+----------+
 
| id | uname | pw                                      | email          | date_joined        | ip          | level | isbanned |
the first reason is that it could just be plain text -- which we store in the content field.
+----+-------+------------------------------------------+----------------+---------------------+--------------+--------+----------+
 
|  1 | dougt | xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx      | dougt@meer.net | 2007-01-29 11:28:42 | 00.00.00.00 | Normal | no      |
another reasons the file name could be null is that it might be a rss source url.  in this case, the content field holds the URL to the RSS feed.
+----+-------+------------------------------------------+----------------+---------------------+--------------+--------+----------+
 
when our cron job runs over the table looking for this content type, we download/parse the rss and creates (if required) the filename.


mysql> select * from upload where owner=1;
+------+-------+----------+------------+----------------------------------------------+------+----------------------------------+------+----------+-----------+---------------------+--------+
| id  | owner | name    | type      | uri                                          | uuid | title                            | size | content  | thumbnail | date_created        | shared |
+------+-------+----------+------------+----------------------------------------------+------+----------------------------------+------+----------+-----------+---------------------+--------+
| 7466 |    1 | Untitled | text/plain | aHR0cDovL3dpa2kubW96aWxsYS5vcmcvTWFpbl9QYWdl |      | TWFpbiBQYWdlIC0gTW96aWxsYVdpa2k= |    4 | TWFpbg== |          | 2007-01-31 14:45:14 | yes    |
+------+-------+----------+------------+----------------------------------------------+------+----------------------------------+------+----------+-----------+---------------------+--------+
</pre>




Revision as of 21:30, 13 March 2007

Joey!

What is Joey

Joey is a server, Firefox add-on, and java midlet that allow you to pass data from your Firefox browser to cell phone.

The objective of this effort is to provide a virtual cloud allowing Mozilla users to upload content from the browser to a server and finally be able to access the the content from a phone or other mobile device. The server may do fetching, processing, transcoding, etc of content to ensure that it is in the right format for the mobile client.

Examples of this would:

Provide useful meta data (e.g. text clippings, saved photos, some subset of microsummaries) to a Firefox user via their mobile phone

Allow users to examine and manage this meta data from within Firefox

Allow third party developers to build addons taking advantage of this system.


Developer Info

Wanna help out? Great! You can start by checking out the code and and look over our todo list [1].


Joey Pieces

Joey DB:

for all media there is associated meta data, right.. url it is from, date.size, ect.

for some media we use the "content" field to store the data.

for other media we use the file system to store the data.

the filename can be null for a number of reasons:

the first reason is that it could just be plain text -- which we store in the content field.

another reasons the file name could be null is that it might be a rss source url. in this case, the content field holds the URL to the RSS feed.

when our cron job runs over the table looking for this content type, we download/parse the rss and creates (if required) the filename.


Firefox Addon

  • Source: [3]
  • Short write-up of what it does [4]

Mozilla Server

  • Short write-up of what this does

[5]

Mobile Clients

  • Short write-up of what this should do. [7]
  • Not released just yet as we are working out the licensing terms. stay tuned.

You can view all source code online here [8]


Or check it out here with this command:

svn co http://svn.mozilla.org/labs/joey/trunk

Retrieved from "https://wiki.allizom.org/index.php?title=Labs/Joey&oldid=51756"