Re: [sqlite] import in sqlite

[sandhya]

Hi,
Can you please explain me..How it is Possible?
Like Is there any API which accepts a file name given and load into DB or we
have to do it i mean getting the length of the file to load into DB and
at the DB side how we should do this.
How it will store in DB?Any ObjID it will give or how?
Any one pls help me.Handling files like .jpg,.gif,.txt,.asp,.gz what
ever may be the file i have to load it into my DB and can able to access it
through a program?
How Sqlite handlings storing files in database.Please...I am very new to
this DB.Please help me in giving some information about this.
I am in very need of this.

Thank you for all,

-Sandhya

- Original Message - 
From: "Tom Njagi" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Saturday, July 22, 2006 7:20 PM
Subject: Re: [sqlite] import in sqlite


> sandhya wrote:
> >  Hi,
> >
> >  Is there any possibility to import files from the local file system and
> > storing in
> >  sqlite DB.And Is there any export option just to check whether
> >  the loaded file into a table consists of same data as the original file
or
> > not.
> >  Is it possible in sqlite?
> >  If possible,How it will stores files in tables?In which format?
> >  Please explain me how can i do it.
> >
> >  Thank you
> >  Sandhya
> >
> >
> >
> >
> >
> >
> >
> >
> Yes there is.
>
> I used Sqlite database browser to import from local file system. The
> files I imported were of csv kind.

Re: [sqlite] import in sqlite

[Tom Njagi]

Tom Njagi wrote:

sandhya wrote:

 Hi,

 Is there any possibility to import files from the local file system and
storing in
 sqlite DB.And Is there any export option just to check whether
 the loaded file into a table consists of same data as the original 
file or

not.
 Is it possible in sqlite?
 If possible,How it will stores files in tables?In which format?
 Please explain me how can i do it.

 Thank you
 Sandhya







  

Yes there is.

I used Sqlite database browser to import from local file system. The 
files I imported were of csv kind.


Go to http://sqlitebrowser.sourceforge.net

Re: [sqlite] import in sqlite

[Tom Njagi]

sandhya wrote:

 Hi,

 Is there any possibility to import files from the local file system and
storing in
 sqlite DB.And Is there any export option just to check whether
 the loaded file into a table consists of same data as the original file or
not.
 Is it possible in sqlite?
 If possible,How it will stores files in tables?In which format?
 Please explain me how can i do it.

 Thank you
 Sandhya







  

Yes there is.

I used Sqlite database browser to import from local file system. The 
files I imported were of csv kind.

[sqlite] import in sqlite

[sandhya]

 Hi,

 Is there any possibility to import files from the local file system and
storing in
 sqlite DB.And Is there any export option just to check whether
 the loaded file into a table consists of same data as the original file or
not.
 Is it possible in sqlite?
 If possible,How it will stores files in tables?In which format?
 Please explain me how can i do it.

 Thank you
 Sandhya

[sqlite] import in sqlite

[sandhya]

> Hi,
>
> Is there any possibility to import files from the local file system to the
> sqlite DB.And Is there any export option is there just to check whether
the
> loaded file and exported file consists of same data or not.
> Is it possible in sqlite?
> If possible,How it will stores files in tables?In which format?
> Please explain me how can i do it.
>
> Thank you
> Sandhya
>
>