15 messages in com.googlegroups.google-gearsRe: [google-gears] Re: I need create ...
FromSent OnAttachments
Arcey18 Mar 2008 01:10 
Jeremy Moskovich18 Mar 2008 01:25 
Arcey18 Mar 2008 01:34 
Jeremy Moskovich18 Mar 2008 01:42 
Arcey25 Mar 2008 13:43 
Ben Lisbakken25 Mar 2008 23:24 
Arcey26 Mar 2008 02:20 
Ben Lisbakken26 Mar 2008 09:36 
Arcey26 Mar 2008 16:42 
Ben Lisbakken26 Mar 2008 16:44 
Arcey28 Mar 2008 07:46 
Ben Lisbakken28 Mar 2008 11:52 
Arcey28 Mar 2008 14:10 
Ben Lisbakken31 Mar 2008 08:15 
Arcey02 Apr 2008 02:55 
Subject:Re: [google-gears] Re: I need create Google Gears database
From:Ben Lisbakken (lisb@google.com)
Date:03/25/2008 11:24:24 PM
List:com.googlegroups.google-gears

Hey Arcey --

Are you familiar with databases? You should checkout some tutorials on MySQL/SQLite.

To have more fields, here is what you would need to change --

This line: db.execute('create table if not exists Demo' + ' (Phrase varchar(255), Timestamp int)');

creates the table in the database. If you wanted name, date, warehouse, count fields in the table, you might change this line to: db.execute('create table if not exists Demo' + ' (name varchar(255), date varchar(10), warehouse int, count int');

Then, if you wanted to insert insert an entry you could do: db.execute('insert into Demo values (?, ?, ?, ?)', ['Martin', '25.3.2008', 3002, 300]);

-Ben

On Tue, Mar 25, 2008 at 1:43 PM, Arcey <mart@gmail.com> wrote:

Hi Jeremy

ok i studied sample database demo... i have question... can i put more phrases to database at once?

look at example pls:

name: Martin date: 25.3.2008 warehouse: 3002 count: 300

?

in this demo i can store only phrase

can you help me?

On 18. Mar., 09:42 h., "Jeremy Moskovich" <play@google.com> wrote:

Hi Arcey,

I'm glad you found the tutorial already.

For a discussion of different approaches to syncing data, look here ( http://code.google.com/apis/gears/architecture.html).

You may want to look at the GearPad Sample ( http://code.google.com/apis/gears/GoogleGears_SamplesAndTools.zip) which does syncing.

Another option would be to use Gears via Dojo offline ( http://dojotoolkit.org/offline) which has a sync component.

Best regards, Jeremy

On Tue, Mar 18, 2008 at 10:35 AM, Arcey <mart@gmail.com> wrote:

Hi Jeremy

I`m working with this sample but i dont understand how can copy informations which i write when i`m offline to main DB when i`m online...

Jeremy Moskovich napísal(a):

Hi Arcy,

You might want to start out with the "Simple Database Demo"

application

here

(http://code.google.com/apis/gears/samples/hello_world_database.html

).

While you play around with the demo, you can refer back to the api documentation ( http://code.google.com/apis/gears/upcoming/api_database.html ).

-- Jeremy

On Tue, Mar 18, 2008 at 10:10 AM, Arcey <mart@gmail.com>

wrote:

Hi everyone

I need create a Google Gears Database but i dont understand how. I need DB for my project. I have data from external warehouses, but i dont have internet connection when i`m calculating how goods go away every day to the main warehouse. Today I must everything write on the paper and when i`m in the main warehouse I must copy everything to main DB... I`m looking for solution with Google Gears.

Can anybody help me?

Pls,I have big problem with understanding Google Gears DB