Hi,
I am using the Sqlite for my server database application purpose.
I want to make sure that the database does not get corrupted.
If by chance if i corrupts the database by what means can i restore it back?
What are the various possibilities of database corrupting methods in sqlite?
so
Hi,
We are working on different operating system other than unix and windows.
We are using the os_win.c for porting, we have ported the code by making
some changes with respect to the FAT32 file system apis in the code.
We have not tested much, my worry is whether we also need to take care of
Hi,
I am using sqlite for meta data storage of audio files.
I am storing the sqlite database in hard disk.
The sector size of FAT file system is 512 bytes.
Hard disk rpm is 4200
Page size = 1K
cache size = 2k
The processor speed is 600 Mhz.
I am using joins method in sqlite.The records are the
Hi,
I am working in 3.3.6 C code.
I created a database and i started inserting 100 records .
After inserting i checked the database File.Say 98% of the database is
filled and the remaining 2% is left out without use.
Then i inserted next 100 records and i found again 2% is left out.So totally
or its not needed.
Will the performance increase by doing indexing the Artist_Id , Album in
MUSIC table.
Kindly suggests some ways.
Thanks & Regards,
Sreedhar.A
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Hi,
Thankyou very much for the suggestions.
Best Regards,
A.Sreedhar.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 19, 2007 12:41 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite]:Using sqlite3_progress_handler for GUI application
007 9:56 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] sqlite:Deletion in Joins method
Sreedhar.a wrote:
> CREATE TABLE ALBUM (AlbumId INTEGER NOT NULL PRIMARY KEY,Album Text);
> CREATE TABLE ARTIST (ArtistId INTEGER NOT NULL PRIMARY KEY,Artist
> Text); CREATE TABLE BGM (BgmId IN
007 9:56 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] sqlite:Deletion in Joins method
Sreedhar.a wrote:
> CREATE TABLE ALBUM (AlbumId INTEGER NOT NULL PRIMARY KEY,Album Text);
> CREATE TABLE ARTIST (ArtistId INTEGER NOT NULL PRIMARY KEY,Artist
> Text); CREATE TABLE BGM (BgmId IN
Hi,
I am working with the database of 40k records.
My database table contains the metadata information of audio files.
When I searched for the first 50 records, the heap usage is small.
when I searched for the last 50 records, the heap usage is almost equal to
searching the entire database
Thankyou all for the quick replies.
Best Regards,
A.Sreedhar.
-Original Message-
From: Trevor Talbot [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 12, 2007 5:08 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Unicode support for Sqlite?
On 12/12/07, Sreedhar.a <[EM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Unicode support for Sqlite?
On 12/12/07, Sreedhar.a <[EMAIL PROTECTED]> wrote:
> Does Sqlite support unicode?
> I have seen that it supports utf-8 and utf-16.
> I want to know whether it supports unicode character formats.
Unicode
Hi,
Does Sqlite support unicode?
I have seen that it supports utf-8 and utf-16.
I want to know whether it supports unicode character formats.
Thanks and Best Regards,
A.Sreedhar.
Hi Dennis,
I have created 2 tables for PlayList as u suggested as Follows.
"CREATE TABLE MUSIC (MusicId INTEGER PRIMARY KEY NOT NULL,Album_Id
INTEGER,Artist_Id INTEGER,Bgm_Id INTEGER, Track Text);"
MusicId Album_Id Artist_Id Bgm_Id Track
11
rds in one table It has to be changed in all the
others Please help to solve this.
Thanks & Regards,
Sreedhar.A
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 04, 2007 9:56 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] sqlite:Deletion
st_Id)
IS NOT NULL THEN 'DELETE FROM ARTIST WHERE ArtistId=OLD.Artist_Id'
END;
END;"
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: Monday, December 03, 2007 11:53 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] sqlite:Deletion in Joins method
Sreedh
add some more constraints in triggers/sql statemets
Can anyone please help me to solve this .
Do i need to normalize anything in the create statements?
Thanks & Regards,
Sreedhar.A
in Joins method
Sreedhar.a wrote:
> Hi,
>
> I have created database using the joins method.
>
> My database caontains 4 tables with the Artist(1),Album(2),Genre(or)
> BGM(3),Combination of all these and Track names in one table.
>
> I am ha
Hi,
I am trying to compile the latest version of the sqlite 3.5.3 in vc++.
i got the following error.
Can anyone help me, what i am missing to add.
I just downloaded all the source files and created a project and started
compiling.
Compiling...
tclsqlite.c
Hi,
I have created database using the joins method.
My database caontains 4 tables with the Artist(1),Album(2),Genre(or)
BGM(3),Combination of all these and Track names in one table.
I am having 4 tables as follows.
*
"create table ALBUM(AlbumId integer primary key,Album
>so there is really no way that multiple processes can write into the
database?..but multiple processes can read at the >>same time right?..
--Yes
-Sreedhar
Igor Tandetnik wrote:
>
> arbalest06 <[EMAIL PROTECTED]> wrote:
>> q#1: is it possible that multiple users can write into the database
Hi,
I am working with OS which does not has the support of Lockfile and
Unlockfile functions.
How I can I implement the Sqlite using the File I/O method.
Thanks in advance, Your suggestions will help a lot in my project.
Best Regards,
A.Sreedhar.
Jasmin Infotech Pvt. Ltd.
Plot 119,
Hi,
I open the database sqlite3_open, and do the required processing uisng
sqlite3_exec()
and after that i calls sqlite3_close().
In this order:
sqlite3_open
sqlite3_exec()
sqlite3_close()
If i open only once and try to do the searching/inserting of records my
program is crashing.
Is
Seems useful
Best Regards,
A.Sreedhar.
-Original Message-
From: Dennis Povshedny [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 25, 2007 4:40 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] select COUNT (DISTINCT column1, column2) from table?
Hi Phani!
For your sample the
is it possible?
You can read and write to the database concurrently provided that your
program can handle SQLITE_BUSY events.
Sreedhar.a wrote:
> Hi Everyone,
>
> I am implementing server database using sqlite.
>
> I will be having the multiple clients browsing the database.
>
Hi Everyone,
I am implementing server database using sqlite.
I will be having the multiple clients browsing the database.
At the same time the database can also be updated.
I can copy the database into the local memory of my system and can perform
search.
Can i implement inserting the
Hi,
I am working in Sqlite 3.3.6
I want to insert more records[like 20,000.] at a single stretch.
I did the following in shell.c,
Static void process_input (struct callback_data *p)
{
char *zLine;
int nLine;
nLine = 200;
zLine = malloc( nLine );
Strcpy
Hai,
I am having 4 distinct Albums in one table.
To display all the 4 Albums in sorted order.I used the following
statement
"select distinct Albums from TableName order by Albums;"
To display first 50 Albums in sorted order.I used the following statement
"select distinct Albums
Hi,
I am working on a 16 bit processor.
In windows the maximum value of unique id is 2 power 63 -1
I want to restrict the maximum value of the unique id to 2 power 15 -1
Can anyone help me in this?.
Best Regards,
A.Sreedhar.
Jasmin Infotech Pvt. Ltd.
Plot 119, Velachery Tambaram Road,
clients on the same machine, only if
they are on a network.
Sreedhar.a wrote:
>
> Hi,
>
> I am working in sqlite 3.3.6.
> I want 5 clients to browse at the same time with good performance.
> I enabled threadsafe and defined SQLITE_ENABLE_MEMORY_MANAGEMENT .
> I think by us
Phani,
Read the "auto increment" in Sqlite FAQ s it is the first one in the list,
it will solve your problem.
Best Regards,
A.Sreedhar.
-Original Message-
From: B V, Phanisekhar [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 30, 2007 2:11 PM
To: sqlite-users@sqlite.org
Subject:
that I can do the search fast.
Best Regards,
Sreedhar.
-Original Message-
From: Dwight Ingersoll [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 21, 2007 11:43 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Unique ids for each record
On 8/20/07, Sreedhar.a <[EMAIL PROTECTED]>
/Server approach
You do not need a server to manage 5 clients on the same machine, only if
they are on a network.
Sreedhar.a wrote:
>
> Hi,
>
> I am working in sqlite 3.3.6.
> I want 5 clients to browse at the same time with good performance.
> I enabled thre
: Re: [sqlite] Unique ids for each record
refer *In-Memory Database: Delete rows on a Table increases the memory usage
*
More help needed or didn't understand, let me know.
On 8/17/07, Sreedhar.a <[EMAIL PROTECTED]> wrote:
>
> Thanks Marcus
>
>
>
> I am working in
it!
*
- Original Message -
From: "Sreedhar.a" <[EMAIL PROTECTED]>
Date: Saturday, August 18, 2007 10:52 am
Subject: [sqlite] To increase search speed
> Hi
> I am working in 3.3.6.
&g
Hi,
I am working in 3.3.6
Now I am working with inmemory concept.
Actually I am copying all the contents of the database into temporary
table.
Then I am inserting one record in that temporary table.
But I need that record to be returned finally in to the original database
file.
Is there any
Hi
I am working in 3.3.6.
I have created a table with 4 records with 12 fields as follows.
"create table MUSIC (Id integer primary key, AlbumName text not null collate
nocase,Track text not null collate nocase,ArtistName text not null collate
nocase,URL text not null collate nocase , Duration
st 16, 2007 7:39 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Unique ids for each record
I assume you'd rather want three separate tables (artist, album,
track) with an autoincrementing ID field per table. Your approach would not
allow users to own more than 100 albums.
regards,
Markus
Qu
Hi,
One idea,Please check whether each row has 11 elements.
That's could be the reason why u have got 33 times call back.
Best Regards,
A.Sreedhar.
-Original Message-
From: Mina R Waheeb [mailto:[EMAIL PROTECTED]
Sent: Friday, August 17, 2007 12:12 PM
To: sqlite-users@sqlite.org
Hi,
I am working with sqlite 3.3.6 version.
I have defined the macro SQLITE_OMIT_FLOATING_POINT.
1.
this is my test program
"create table Test(id integer primary key,player char);"
"insert into Test(id,player) values(2,'surya');"
"insert into Test(id,player)
39 matches
Mail list logo