[sqlite] whether Sqlite Db supports jar files
Hi all, I have loaded all my webpages into database and i am unable to open file have .jar extension??? Is it something related Database where i need to look into? please help me Thank u all Regards, Sandhya - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] reg:SqliteDB file
ok..Thank you.Let me try that and let you know. - Original Message - From: "Lloyd" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Friday, October 27, 2006 12:36 PM Subject: Re: [sqlite] reg:SqliteDB file > Whether your question mean to open database file which is in some other > location? > > If yes, > > we will be using the > > > int sqlite3_open(const char *filename,sqlite3 **ppDb); > > > call to open the database. In that we will have to mention the file > name. There instead of using the file name simply, give the full path of > the file. It will work fine. > > Thanks, > Lloyd. > > On Fri, 2006-10-27 at 12:17 +0530, sandhya wrote: > > Hi, > >Is it possible to refer db file from other than the Current project location.If Yes,How can we refer(tell) the location of the DB file to the project.Please help me. > > > > Thank you all, > > - Sandhya > > > __ > Scanned and protected by Email scanner > > -- --- > To unsubscribe, send email to [EMAIL PROTECTED] > -- --- > - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] reg:SqliteDB file
Hi, Is it possible to refer db file from other than the Current project location.If Yes,How can we refer(tell) the location of the DB file to the project.Please help me. Thank you all, - Sandhya
Re: [sqlite] reg:blob data reading
Thank you very much just i need confirmation on this.. If you don't mind could you please tell me if i want to perform that kind of operation Is there any way other than storing in some temp file and reading.using normal fopen() calls. Please do needful Thanks a lot Sandhya R - Original Message - From: <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org>; "Teg" <[EMAIL PROTECTED]> Sent: Monday, September 18, 2006 7:32 PM Subject: Re: [sqlite] reg:blob data reading > SQLite does not (at this time) have the ability to incrementally > read or write BLOBs. You have to read and write the whole blob > all at once. > -- > D. Richard Hipp <[EMAIL PROTECTED]> > > > -- --- > To unsubscribe, send email to [EMAIL PROTECTED] > -- --- > - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] reg:blob data reading
You mean, I have to get the entire BLOB from the DB and has to store it in some temp file and reading it? Is there no way we can read the required no.of bytes of the data from the DB directly and setting the pointer or handle to the current position? Please tell me whether the way i am thinking is wrong? Help me Thank you Sandhya - Original Message - From: "Jay Sprenkle" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Monday, September 18, 2006 6:53 PM Subject: Re: [sqlite] reg:blob data reading > On 9/18/06, sandhya <[EMAIL PROTECTED]> wrote: > > I think too, if they are Big-Blobs, it is better to store only a Reference > > to a File. > > > > May i know litlle more clearly about this?What it mean actually? > > Store the path to the file in the database ( C:\somefile.dat or > /tmp/somefile.dat ). > Then open the file using regular file handing routines ( fopen() etc ). > > -- --- > To unsubscribe, send email to [EMAIL PROTECTED] > -- --- > - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] reg:blob data reading
I think too, if they are Big-Blobs, it is better to store only a Reference to a File. May i know litlle more clearly about this?What it mean actually? Right now what i am doing is, I have a directory in which somany files are there and i have loaded all the files into database and the data(ie content of files as blob). But my application is reading only 512 bytes at a time..If that is the case how can i perform / handle this data . Please suggest me your views. Thanks a lot Sandhya R
Re: [sqlite] sqlite_blob
I think too, if they are Big-Blobs, it is better to store only a Reference to a File. May i know litlle more clearly about this?What it mean actually? Right now what i am doing is, I have a directory in which somany files are there and i have loaded all the files into database and the data(ie content of files as blob). But my application is reading only 512 bytes at a time..If that is the case how can i perform / handle this data . Please suggest me your views. Thanks a lot Sandhya R - Original Message - From: <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Monday, September 18, 2006 12:51 PM Subject: Re: [sqlite] sqlite_blob > Hello > > sandhya wrote: > > Hi, > > Is there any way of reading Blob data for the given no.of bytes? > > I mean is there any lseek kind of function call in sqlite to handle > > reading BLOB data. > > http://www.sqlite.org/capi3ref.html says: > "If the result is a BLOB then the sqlite3_column_bytes() routine returns > the number of bytes in that BLOB." > > If you fetch the Blob into RAM, you can do with it with your given number > of Bytes whatever you want > > I think too, if they are Big-Blobs, it is better to store only a > Reference to a File. > > Best Regards > Thomas > > -- > www.thlu.de > > > -- --- > To unsubscribe, send email to [EMAIL PROTECTED] > -- --- > - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] sqlite_blob
Hi, Is there any way of reading Blob data for the given no.of bytes? I mean is there any lseek kind of function call in sqlite to handle reading BLOB data. Thank you all, Sandhya R - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] sqlite_blob
Hi, Is there any way of reading Blob data for the given no.of bytes? I mean is there any lseek kind of function call here to handle BLOB data. Thank you all, Sandhya R - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] sqlite3_bind_text
Hi, In the following API, sqlite3_bind_text(pStmt, 1, "sample", -1, SQLITE_STATIC); What does the second argument referes to?If the no.of binding arguments are more than one whether we have to mention two. Can you please explain the usage of second argument.I didn't get properly from the documentation. Thank you Regards Sandhya R - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Which API to use to get resultant of query
Thank you,
I solved getting oid from a table
-sandhya
- Original Message -
From: "sandhya" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Sunday, September 17, 2006 1:21 PM
Subject: [sqlite] Which API to use to get resultant of query
>
> Just i modified the query and tested With the steps i used it is
working
> fine.
> Like the otherway round i went,
> select filename from sample where oid = '455';
> Now it is working fine and showing the corresponding file name.
> Where as when i am giving like select oid from sample where filename =
> "sample.txt";(Nothing i am getting)
> Onemorething i want to say here is,
> I have created a table(sample) with only two cloumns...
> filename text,data blob;
>
> But i want to get the oid which is internally there in the
database.Whether
> i can able to get the oid through the same API's or i need to do in some
> other way.
> The following are the API's i used,
> sprintf(szQuery,"select oid from sample where filename = "sample.txt" ");
> sqlite3_prepare(db,szQuery, -1 , , 0);
> errcode = sqlite3_step(pStmt); //As i got error i included this to
> check the error code ie 101(SQLITE_DONE)
> if( errcode==SQLITE_ERROR ){
> errcode = sqlite3_reset(pStmt);
> }
> if( errcode == SQLITE_ROW ){
> oid = (int)sqlite3_column_int(pStmt, 0);
> }
>
> Why it is showing the filename when i gave OID and the same when i am
giving
> filename and asking for OID it is throwing error.
> Is it bcoz it is not present in the table or something else?
> Please tell me how can i do this?
> I need you help very much as i have very short time to complete this..
>
> Thanks a lot
> Sandhya
>
>
>
> - Original Message -
> From: "Igor Tandetnik" <[EMAIL PROTECTED]>
> To: "SQLite" <sqlite-users@sqlite.org>
> Sent: Friday, September 15, 2006 8:56 PM
> Subject: [sqlite] Re: Re: Re: Which API to use to get resultant of query
>
>
> > sandhya <[EMAIL PROTECTED]> wrote:
> > > But where as when i am executing the same from command prompt it is
> > > showing
> > > the OID alone.
> > > Why it is showing DONE when i am doing it through program?Anything
> > > wrong?
> >
> > Check your condition. Make sure it's the same as the one you use in
> > console. Most likely, you've simply misspelled the string in the sprintf
> > call and it cannot be found in the table.
> >
> > As a sanity check, drop the condition and see if you can get anything at
> > all with a simple query like "select oid from tablename;"
> >
> > Igor Tandetnik
> >
> >
>
> --
> ---
> > To unsubscribe, send email to [EMAIL PROTECTED]
>
> --
> ---
> >
>
>
>
> --
---
> To unsubscribe, send email to [EMAIL PROTECTED]
> --
---
>
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
[sqlite] Which API to use to get resultant of query
Just i modified the query and tested With the steps i used it is working
fine.
Like the otherway round i went,
select filename from sample where oid = '455';
Now it is working fine and showing the corresponding file name.
Where as when i am giving like select oid from sample where filename =
"sample.txt";(Nothing i am getting)
Onemorething i want to say here is,
I have created a table(sample) with only two cloumns...
filename text,data blob;
But i want to get the oid which is internally there in the database.Whether
i can able to get the oid through the same API's or i need to do in some
other way.
The following are the API's i used,
sprintf(szQuery,"select oid from sample where filename = "sample.txt" ");
sqlite3_prepare(db,szQuery, -1 , , 0);
errcode = sqlite3_step(pStmt); //As i got error i included this to
check the error code ie 101(SQLITE_DONE)
if( errcode==SQLITE_ERROR ){
errcode = sqlite3_reset(pStmt);
}
if( errcode == SQLITE_ROW ){
oid = (int)sqlite3_column_int(pStmt, 0);
}
Why it is showing the filename when i gave OID and the same when i am giving
filename and asking for OID it is throwing error.
Is it bcoz it is not present in the table or something else?
Please tell me how can i do this?
I need you help very much as i have very short time to complete this..
Thanks a lot
Sandhya
- Original Message -
From: "Igor Tandetnik" <[EMAIL PROTECTED]>
To: "SQLite" <sqlite-users@sqlite.org>
Sent: Friday, September 15, 2006 8:56 PM
Subject: [sqlite] Re: Re: Re: Which API to use to get resultant of query
> sandhya <[EMAIL PROTECTED]> wrote:
> > But where as when i am executing the same from command prompt it is
> > showing
> > the OID alone.
> > Why it is showing DONE when i am doing it through program?Anything
> > wrong?
>
> Check your condition. Make sure it's the same as the one you use in
> console. Most likely, you've simply misspelled the string in the sprintf
> call and it cannot be found in the table.
>
> As a sanity check, drop the condition and see if you can get anything at
> all with a simple query like "select oid from tablename;"
>
> Igor Tandetnik
>
>
> --
---
> To unsubscribe, send email to [EMAIL PROTECTED]
> --
---
>
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Re: [sqlite] Re: Re: Re: Which API to use to get resultant of query
Thank you very much for your suggestion. I found very few samples in the siteBut hardly only one example is there which explains abt handling BLOB data. There is no documentation which explains about these samples .. So for me all your support is very much required.please bear with me Thank you Regards Sandhya - Original Message - From: "Fred Williams" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Friday, September 15, 2006 9:19 PM Subject: RE: [sqlite] Re: Re: Re: Which API to use to get resultant of query > > > > -Original Message- > > From: Igor Tandetnik [mailto:[EMAIL PROTECTED] > > Sent: Friday, September 15, 2006 10:27 AM > > To: SQLite > > Subject: [sqlite] Re: Re: Re: Which API to use to get > > resultant of query > > > > > > sandhya <[EMAIL PROTECTED]> wrote: > > > But where as when i am executing the same from command prompt it is > > > showing > > > the OID alone. > > > Why it is showing DONE when i am doing it through program?Anything > > > wrong? > > > > Check your condition. Make sure it's the same as the one you use in > > console. Most likely, you've simply misspelled the string in > > the sprintf > > call and it cannot be found in the table. > > > > As a sanity check, drop the condition and see if you can get > > anything at > > all with a simple query like "select oid from tablename;" > > > > Igor Tandetnik > > > > Just a suggestion. When I am learning a new language, database, etc. I > sometimes find working with and even stepping through supplied samples > prove to be the quickest way to gain insight into how the new entity > works. Saves both me and a lot of other people a lot of time and > effort. > > Fred > > > -- --- > To unsubscribe, send email to [EMAIL PROTECTED] > -- --- > - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Re: Re: Which API to use to get resultant of query
yaI got now... But where as when i am executing the same from command prompt it is showing the OID alone. Why it is showing DONE when i am doing it through program?Anything wrong? Whether i should do in some other way? please help me -Sandhya - Original Message - From: "Igor Tandetnik" <[EMAIL PROTECTED]> To: "SQLite" <sqlite-users@sqlite.org> Sent: Friday, September 15, 2006 8:27 PM Subject: [sqlite] Re: Re: Which API to use to get resultant of query > sandhya <[EMAIL PROTECTED]> wrote: > > Ya now i am getting error code which says SQLITE_DONE > > It's not an error. It's a success code meaning that you've reached the > end of resultset. If you get that on the very first call to > sqlite3_step, it means your resultset is empty - there are no rows > matching your condition. > > When sqlite3_step successfully retrieves a row from resultset, it > returns SQLITE_ROW. At this point, use sqlite3_column_* calls to > retrieve individual fields from this row. E.g. > > int oid = sqlite3_column_int(pStmt, 0); > > Igor Tandetnik > > > -- --- > To unsubscribe, send email to [EMAIL PROTECTED] > -- --- > - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Which API to use to get resultant of query
I got but the return type of all API's is int..So where the result will get stored and how can i get..Please don't get fed up with the same question again and again i am not getting how to ask this? i used sqlite_exec() i don't know where the result stored and how to get it. I also used the following here also i am getting SQLITE_OK but where the result i am not getting sqlite3_prepare(db,szQuery, -1 , , 0); errcode = sqlite3_step(pStmt); Now where my result will be .Please do needful.I am very thankful to you -Sandhya - Original Message - From: "Jay Sprenkle" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Friday, September 15, 2006 8:10 PM Subject: Re: [sqlite] Which API to use to get resultant of query > On 9/15/06, sandhya <[EMAIL PROTECTED]> wrote: > > Actually my query is returing only one data ie OID of the fileIn this > > case what i can do to get that data.Where it will get stored? > > look at the documentation for sqlite_bind(): > http://sqlite.org/capi3ref.html#sqlite3_bind_text > It explains how to send parameters to a query > > to get the results: > http://sqlite.org/capi3ref.html#sqlite3_column_int > > -- --- > To unsubscribe, send email to [EMAIL PROTECTED] > -- --- > - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Which API to use to get resultant of query
You mean there is no need for me to take care of this function calls ..Its
just enough having definition there.
But by doing that i am not getting any kind of output ie my OID.
- Original Message -
From: "Noel Frankinet" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Friday, September 15, 2006 8:02 PM
Subject: Re: [sqlite] Which API to use to get resultant of query
> sandhya a écrit :
> > Thanks a lot for your response
> > Actually there is one function call in some sample found like,
> >
> > static int callback(void *NotUsed, int argc, char **argv, char
**azColName)
> > {
> > int i;
> > for(i=0; i<argc; i++){
> > printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
> > }
> > printf("\n");
> > return 0;
> > }
> >
>
> you don't call that callback , its called by sqlite...
> In your case argc will be 1, argv[0] will contains the oid and
> azColNames[0] will be "oid"
>
> > I reffered Shell.c also where in they also has the same function,If i am
not
> > passing my arguments through command prompt...
> > What i should pass as 2 and 3 arguments in the above function call ie
argc
> > and argv.Is there any API which directly gives the result.
> > Actually my query is returing only one data ie OID of the fileIn
this
> > case what i can do to get that data.Where it will get stored?
> > Please help me...in doing this
> >
> > Thank you
> > Sandhya
> > - Original Message -----
> > From: "Jay Sprenkle" <[EMAIL PROTECTED]>
> > To: <sqlite-users@sqlite.org>
> > Sent: Friday, September 15, 2006 7:38 PM
> > Subject: Re: [sqlite] Which API to use to get resultant of query
> >
> >
> >
> >> On 9/15/06, sandhya <[EMAIL PROTECTED]> wrote:
> >>
> >>> sprintf(szQuery,"select oid from %s where filename =
> >>>
> > '%s'",sampletbl,test.htm);
> >
> >> there's an example program here:
> >> http://sqlite.org/quickstart.html
> >> and a more involved one here
> >> http://www.reddawn.net/~jsprenkl/Sqlite
> >>
> >> --
> >> --
> >> SqliteImporter and SqliteReplicator: Command line utilities for Sqlite
> >> http://www.reddawn.net/~jsprenkl/Sqlite
> >>
> >> Cthulhu Bucks!
> >> http://www.cthulhubucks.com
> >>
>
>> -
-
> >>
> > ---
> >
> >> To unsubscribe, send email to [EMAIL PROTECTED]
>
>> -
-
> >>
> > ---
> >
> >
> >
> >
>
> --
---
> > To unsubscribe, send email to [EMAIL PROTECTED]
>
> --
---
> >
> >
> >
> >
>
>
> --
> Noël Frankinet
> Gistek Software SA
> http://www.gistek.net
>
>
> --
---
> To unsubscribe, send email to [EMAIL PROTECTED]
> --
---
>
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Re: [sqlite] Re: Which API to use to get resultant of query
Ya now i am getting error code which says SQLITE_DONE...so how can get my resultant now? Which API i should use?Please tell me - Original Message - From: "Igor Tandetnik" <[EMAIL PROTECTED]> To: "SQLite" <sqlite-users@sqlite.org> Sent: Friday, September 15, 2006 7:57 PM Subject: [sqlite] Re: Which API to use to get resultant of query > sandhya <[EMAIL PROTECTED]> wrote: > > sprintf(szQuery,"select oid from %s where filename = > > '%s'",sampletbl,test.htm); > > > > sqlite3_prepare(db,szQuery, 512 , , 0); > > It is unlikely that szQuery string is 512 characters long. So you > instruct SQLite to compile a long string of garbage. sqlite3_prepare > most likely fails (I can't help but note that you don't check error code > here). Just pass -1 as the third parameter. > > > errcode = sqlite3_step(pStmt); > > > > But the error code i am getting is 21 > > This means sqlite3_prepare has failed, pStmt remains uninitialized so > you are passing garbage to sqlite3_step. > > Igor Tandetnik > > > -- --- > To unsubscribe, send email to [EMAIL PROTECTED] > -- --- > - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Which API to use to get resultant of query
Thanks a lot for your response
Actually there is one function call in some sample found like,
static int callback(void *NotUsed, int argc, char **argv, char **azColName)
{
int i;
for(i=0; i<argc; i++){
printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
}
printf("\n");
return 0;
}
I reffered Shell.c also where in they also has the same function,If i am not
passing my arguments through command prompt...
What i should pass as 2 and 3 arguments in the above function call ie argc
and argv.Is there any API which directly gives the result.
Actually my query is returing only one data ie OID of the fileIn this
case what i can do to get that data.Where it will get stored?
Please help me...in doing this
Thank you
Sandhya
- Original Message -
From: "Jay Sprenkle" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Friday, September 15, 2006 7:38 PM
Subject: Re: [sqlite] Which API to use to get resultant of query
> On 9/15/06, sandhya <[EMAIL PROTECTED]> wrote:
> > sprintf(szQuery,"select oid from %s where filename =
'%s'",sampletbl,test.htm);
> >
>
>
> there's an example program here:
> http://sqlite.org/quickstart.html
> and a more involved one here
> http://www.reddawn.net/~jsprenkl/Sqlite
>
> --
> --
> SqliteImporter and SqliteReplicator: Command line utilities for Sqlite
> http://www.reddawn.net/~jsprenkl/Sqlite
>
> Cthulhu Bucks!
> http://www.cthulhubucks.com
>
> --
---
> To unsubscribe, send email to [EMAIL PROTECTED]
> --
---
>
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
[sqlite] Which API to use to get resultant of query
sprintf(szQuery,"select oid from %s where filename = '%s'",sampletbl,test.htm); sqlite3_prepare(db,szQuery, 512 , , 0); errcode = sqlite3_step(pStmt); But the error code i am getting is 21..Somethig when i read in docs it gave misuseCan you please tell me where i did mistake. Is there any documets which shows the usage of these API's please mail me. Please help me where my resultant of the query get stored. I need it badly...Kindly do needful. Thank you, -Sandhya R
Re: [sqlite] reg:Sqlite API's
Thanks a lot for your response
Actually there is one function call in some sample found like,
static int callback(void *NotUsed, int argc, char **argv, char **azColName)
{
int i;
for(i=0; i<argc; i++){
printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
}
printf("\n");
return 0;
}
I reffered Shell.c also where in they also has the same function,If i am not
passing my arguments through command prompt...
What i should pass as 2 and 3 arguments in the above function call ie argc
and argv.Is there any API which directly gives the result.
Actually my query is returing only one data ie OID of the fileIn this
case what i can do to get that data.Where it will get stored?
Please help me...in doing this
Regards
Sandhya
- Original Message -
From: "Gerry Snyder" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Friday, September 15, 2006 6:31 PM
Subject: Re: [sqlite] reg:Sqlite API's
> sandhya wrote:
> > Hi all,
> >Can you please tell me the usage of sqlite_prepare()
/sqlite_exec()
> Have you looked at the SQLite source code? The stand-alone executable
> should be of help. I believe it is shell.c
>
> HTH,
>
> Gerry
>
> --
---
> To unsubscribe, send email to [EMAIL PROTECTED]
> --
---
>
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
[sqlite] reg:Sqlite API's
Hi all, Can you please tell me the usage of sqlite_prepare() /sqlite_exec() inorder to execute a query say for example, I have given a query like , strcpy(szQuery," SELECT OID from table sample where name ="XXX""); I have used sqlite_exec(db,szQuery,0,0,0); Where my resultant data will get stored.Can any one please tell me how to retrieve the result from the above API. I saw in documentation that we can also use sqlite_prepare() is there any difference btn these two.Which i can use? How to get the resultant data from this API? Very new to this so little bit confused with these API's.Is there any document which explains how to work with the sqlite with some samples.Please do mail me the link so i will be very thankful to you.This is very much required for me to complete my task with in short period. Kindly do needful...Looking forward for ur reply Thank you very much Sandhya R
Re: [sqlite] reg:BOLB data
Thank you very much Snyder. - Original Message - From: "Gerry Snyder" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Wednesday, September 13, 2006 6:56 PM Subject: Re: [sqlite] reg:BOLB data > sandhya wrote: > > Hi, > > I created a table with fileds filename and the value of type text and BLOB > > respectively... > > I stored a file and checked whether it is existing or not from command > > prompt with sqlite3 exe..It is displaying but the problem is i can able > > to see the whole content of the file which i stored. > > Where as i thought it will be in form of some OID's.? > > > The OID is there, but is not shown in a query by default. Try something > like: > > select OID,* from tablename; > > > Hope this helps, > > Gerry > > > -- --- > To unsubscribe, send email to [EMAIL PROTECTED] > -- --- > - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] reg:BOLB data
Hi, I created a table with fileds filename and the value of type text and BLOB respectively... I stored a file and checked whether it is existing or not from command prompt with sqlite3 exe..It is displaying but the problem is i can able to see the whole content of the file which i stored. Where as i thought it will be in form of some OID's.? IS there any such format the files will get store in Sqlite DB or this is the only way to store(ie along with content)?Please tell me. Also what will happen in case if have to store huze say 3000 files at a time? Please suggest me if there is any better way of doing it. Thank you Regards Sandhya R - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] reg:blob files
Hi all, I need to load all file like .jpg,.gif,.asp,.txt,.gz etc in to the database.How the structure of my Table should be?What datatype it will be of?( I mean,say in Postgresql it is of type Oid...)Likewise,in Sqlite what datatype it is? Whether it stores as Large Objects or some where i read as Blob will it be of this type?What is BLOB type? What are the API which do this?Can i retrieve the files which i loaded into DB and can store in my local file path? Please guide me /give me some information about these things.It is very much required now. I am very Thankful to you, Regards, Sandhya
[sqlite] Handling files in sqlite db
Hi, Can anybody help me. 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. 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 it get stored in Table? 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
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.
[sqlite] import in sqlite
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
> 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 > >
[sqlite] sqlite
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
Re: [sqlite] reg:sqlite usage
John, If u don't mind can you please explain me is it possible if i load /store any files as Large objects inside DB and open it via a webserver instead of storing it in a local system and opening.In that case what i have to do.Like my DB whether i should place in the Webserver applcaition and access it or how can i do it? - Original Message - From: "John Stanton" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Wednesday, July 19, 2006 6:04 PM Subject: Re: [sqlite] reg:sqlite usage > Sqlite is a wonderful tool. We use it with great success embedded in a > custom application server for web applications, embedded in CGI > processes and in some industrial process control applications. It is > robust and very simple to use, and since it places all tables in one > file, very easy to maintain. > > sandhya wrote: > > ya..Thank you ver much John.Right now i am using Postgresql only.But just i > > want to find out the information abt Sqlite as i heard that it is having > > very small footprint and its good for Embedded systems app. > > Now i got it,Thanks a lot. > > > > -Sandhya > > > > - Original Message - > > From: "John Stanton" <[EMAIL PROTECTED]> > > To: <sqlite-users@sqlite.org> > > Sent: Wednesday, July 19, 2006 5:53 PM > > Subject: Re: [sqlite] reg:sqlite usage > > > > > > > >>Sandhya, > >> > >>You use Sqlite the same way you use a file in your application. You > >>link in the runtime library containing the file handling API when you > >>create your executable. Sqlite gives an embedded application the > >>capability of using SQL for data management. > >> > >>If you are building a client server model you might want to look at > >>using something like PostgreSQL or Mysql which are DBMS servers. There > >>is no Sqlite server. > >> > >>Sqlite is used as an embedded DBMS in programs such as the Firefox > >>browser, LCC IDE and similar. > >> > >>sandhya wrote: > >> > >>>You link Sqlite into your application...May i know what it mean? > >>>Please explain me. > >>>Also you wanna want to say that we shouldn't use this in Client /Server > >>>applications.Like,Connecting to the Sqlite server through the > > > > application > > > >>>and performing all the operations through(application) it and updating > > > > the > > > >>>server. > >>>Really i am totally confused with this...If you don't mind can you > > > > just > > > >>>explain me where we can use this SQLITE.pls > >>> > >>>Thank you, > >>>Sandhya > >>> > >>> > >>> > >>>- Original Message - > >>>From: "John Stanton" <[EMAIL PROTECTED]> > >>>To: <sqlite-users@sqlite.org> > >>>Sent: Wednesday, July 19, 2006 5:10 PM > >>>Subject: Re: [sqlite] reg:sqlite usage > >>> > >>> > >>> > >>> > >>>>Sandhya, > >>>> > >>>>You have not grasped the concept of Sqlite. It is a RDBMS LIBRARY, not > >>>>a server. You link Sqlite into your application. As Dr Hipp points out > >>>>it it an alternative to fopen, not Oracle. > >>>> > >>>>sandhya wrote: > >>>> > >>>> > >>>>>Hi, > >>>>> I am very new to SQLITE.I have downloaded and installed Sqlite 3 in > > > > my > > > >>>>>windows system.I built lib and dll too. > >>>>>I tried the sample given in the documetation.The connection info i have > >>>>>given the DB name, the table name and the query.But the database name > >>> > >>>what > >>> > >>> > >>>>>ever i am giving it is getting stored in my current application.Will it > >>> > >>>be > >>> > >>> > >>>>>like that. > >>>>>Is there any interface to see the tables i have created in using the > >>> > >>>sample > >>> > >>> > >>>>>given there? > >>>>>Where can i manually enter the queries? > >>>>>Can i perform Client-server application kind of a thing. > >>>>>I mean,With the available API , i will be writing the coding and which > >>> > >>>will > >>> > >>> > >>>>>perform all the operations mentined like creating table,DB,inserting > > > > etc > > > >>>>>etc.Which should update in server directly.If i want to do so.Where > >>> > >>>i > >>> > >>> > >>>>>need to mention the IP of my server. > >>>>>Please guide me how to proceed for Client/Server kind of applications. > >>>>> > >>>>>Thank you. > >>>>>Regards > >>>>>Sandhya R > >>>>> > >>>>> > >>>>> > >>>> > >>> > >>> > > > > >
Re: [sqlite] reg:sqlite usage
ya..Thank you ver much John.Right now i am using Postgresql only.But just i want to find out the information abt Sqlite as i heard that it is having very small footprint and its good for Embedded systems app. Now i got it,Thanks a lot. -Sandhya - Original Message - From: "John Stanton" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Wednesday, July 19, 2006 5:53 PM Subject: Re: [sqlite] reg:sqlite usage > Sandhya, > > You use Sqlite the same way you use a file in your application. You > link in the runtime library containing the file handling API when you > create your executable. Sqlite gives an embedded application the > capability of using SQL for data management. > > If you are building a client server model you might want to look at > using something like PostgreSQL or Mysql which are DBMS servers. There > is no Sqlite server. > > Sqlite is used as an embedded DBMS in programs such as the Firefox > browser, LCC IDE and similar. > > sandhya wrote: > > You link Sqlite into your application...May i know what it mean? > > Please explain me. > > Also you wanna want to say that we shouldn't use this in Client /Server > > applications.Like,Connecting to the Sqlite server through the application > > and performing all the operations through(application) it and updating the > > server. > > Really i am totally confused with this...If you don't mind can you just > > explain me where we can use this SQLITE.pls > > > > Thank you, > > Sandhya > > > > > > > > - Original Message - > > From: "John Stanton" <[EMAIL PROTECTED]> > > To: <sqlite-users@sqlite.org> > > Sent: Wednesday, July 19, 2006 5:10 PM > > Subject: Re: [sqlite] reg:sqlite usage > > > > > > > >>Sandhya, > >> > >>You have not grasped the concept of Sqlite. It is a RDBMS LIBRARY, not > >>a server. You link Sqlite into your application. As Dr Hipp points out > >>it it an alternative to fopen, not Oracle. > >> > >>sandhya wrote: > >> > >>>Hi, > >>> I am very new to SQLITE.I have downloaded and installed Sqlite 3 in my > >>>windows system.I built lib and dll too. > >>>I tried the sample given in the documetation.The connection info i have > >>>given the DB name, the table name and the query.But the database name > > > > what > > > >>>ever i am giving it is getting stored in my current application.Will it > > > > be > > > >>>like that. > >>>Is there any interface to see the tables i have created in using the > > > > sample > > > >>>given there? > >>>Where can i manually enter the queries? > >>>Can i perform Client-server application kind of a thing. > >>>I mean,With the available API , i will be writing the coding and which > > > > will > > > >>>perform all the operations mentined like creating table,DB,inserting etc > >>>etc.Which should update in server directly.If i want to do so.Where > > > > i > > > >>>need to mention the IP of my server. > >>>Please guide me how to proceed for Client/Server kind of applications. > >>> > >>>Thank you. > >>>Regards > >>>Sandhya R > >>> > >>> > >>> > >> > > > > > > >
Re: [sqlite] reg:sqlite usage
You link Sqlite into your application...May i know what it mean? Please explain me. Also you wanna want to say that we shouldn't use this in Client /Server applications.Like,Connecting to the Sqlite server through the application and performing all the operations through(application) it and updating the server. Really i am totally confused with this...If you don't mind can you just explain me where we can use this SQLITE.pls Thank you, Sandhya - Original Message - From: "John Stanton" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Wednesday, July 19, 2006 5:10 PM Subject: Re: [sqlite] reg:sqlite usage > Sandhya, > > You have not grasped the concept of Sqlite. It is a RDBMS LIBRARY, not > a server. You link Sqlite into your application. As Dr Hipp points out > it it an alternative to fopen, not Oracle. > > sandhya wrote: > > Hi, > > I am very new to SQLITE.I have downloaded and installed Sqlite 3 in my > > windows system.I built lib and dll too. > > I tried the sample given in the documetation.The connection info i have > > given the DB name, the table name and the query.But the database name what > > ever i am giving it is getting stored in my current application.Will it be > > like that. > > Is there any interface to see the tables i have created in using the sample > > given there? > > Where can i manually enter the queries? > > Can i perform Client-server application kind of a thing. > > I mean,With the available API , i will be writing the coding and which will > > perform all the operations mentined like creating table,DB,inserting etc > > etc.Which should update in server directly.If i want to do so.Where i > > need to mention the IP of my server. > > Please guide me how to proceed for Client/Server kind of applications. > > > > Thank you. > > Regards > > Sandhya R > > > > > > >
[sqlite] reg:sqlite usage
Hi, I am very new to SQLITE.I have downloaded and installed Sqlite 3 in my windows system.I built lib and dll too. I tried the sample given in the documetation.The connection info i have given the DB name, the table name and the query.But the database name what ever i am giving it is getting stored in my current application.Will it be like that. Is there any interface to see the tables i have created in using the sample given there? Where can i manually enter the queries? Can i perform Client-server application kind of a thing. I mean,With the available API , i will be writing the coding and which will perform all the operations mentined like creating table,DB,inserting etc etc.Which should update in server directly.If i want to do so.Where i need to mention the IP of my server. Please guide me how to proceed for Client/Server kind of applications. Thank you. Regards Sandhya R
