Database Corrupt cases:
Tested on PC
Steps
1) Inserted table to full disk and Reserved 1M space in disk
2 )Release the reserved space
3) Begin transaction
4) Delete table
5) End transaction
Then database is corrupt.
Can it be fixed?
Thanks
Ryan ZhangCheng
Has anyone compiled sqlite 3.3.8 under OpenWatcom 1.x ? I'm not
able to do it, because of this:
void (*interrupt)(sqlite3*);
in sqlite3ext.h ... seems to be, that interrupt is a reserved word
in OpenWatcom, but this is just a guess ...
Any idea ?
Marten
That doesn´t work.
The result of : (case when f1 then ', ' else '' end)
is allways ''
- Original Message -
From: Igor Tandetnik [EMAIL PROTECTED]
To: SQLite sqlite-users@sqlite.org
Sent: Monday, November 27, 2006 6:00 AM
Subject: [sqlite] Re: Re: combination of fields with || ?
Zhang Cheng-E7104C [EMAIL PROTECTED] wrote:
Database Corrupt cases:
Tested on PC
Steps
1) Inserted table to full disk and Reserved 1M space in disk
2 )Release the reserved space
I do not understand what you mean by the previous two
steps. Can you pleae provide more detail.
3) Begin
Marten Feldtmann [EMAIL PROTECTED] wrote:
Has anyone compiled sqlite 3.3.8 under OpenWatcom 1.x ? I'm not
able to do it, because of this:
void (*interrupt)(sqlite3*);
in sqlite3ext.h ... seems to be, that interrupt is a reserved word
in OpenWatcom, but this is just a guess ...
Any
I'd like to strongly second this. Avoid NULL columns, even at apparent cost.
Having a valid default value is always better. If a design appears to
require NULL values, then the design is likely critically flawed. For
something this simple, a default '' string would be much better.
On 11/26/06,
Alon Keren [EMAIL PROTECTED] wrote:
The cross-compilation I'm currently trying is from x86 architecture to
x86 architecture, as I'm interested just to see that cross-compilation
of sqlite can work.
All of the Win32 binaries on the SQLite download site are
cross-compiled on a Linux host.
-Original Message-
From: Isaac Raway [mailto:[EMAIL PROTECTED]
Sent: Monday, November 27, 2006 7:05 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] SELECT on empty fields ??
I'd like to strongly second this. Avoid NULL columns, even at apparent
cost.
Having a valid default
Daniel Schumann [EMAIL PROTECTED] wrote:
That doesn´t work.
The result of : (case when f1 then ', ' else '' end)
is allways ''
Right, my bad. It tries to convert the string to integer. Make it
(case when length(f1) then ', ' else '' end)
That would separate non-empty strings on one hand from
Nice job decoupling the 8-byte double serialization logic from
relying on 64 bit integers.
Please consider creating an SQLite ticket for you patch so it
might be incorporated into the official source tree.
I must confess that I did not read the original 32-bit port thread
URL in your first
Hi,
Im new to SQLite, After you create your tables how do you save them so they
are permenently there? It might be a dumb question but i cant find the
answer anwhere?!
--
View this message in context:
http://www.nabble.com/Saving-tables-tf2714011.html#a7566646
Sent from the SQLite mailing list
Is it possible to store mp3 files in a SSQLite database? would they be able
to be played from the database? How would you save them?
--
View this message in context:
http://www.nabble.com/Music-Files-tf2714035.html#a7566722
Sent from the SQLite mailing list archive at Nabble.com.
sebcity [EMAIL PROTECTED] wrote:
Im new to SQLite, After you create your tables how do you save them
so they are permenently there? It might be a dumb question but i cant
find the answer anwhere?!
They are permanently there from the very moment you create them. All
changes are written to the
sebcity [EMAIL PROTECTED] wrote:
Is it possible to store mp3 files in a SSQLite database? would they
be able to be played from the database? How would you save them?
SQLite does not know anything nor care about music or MP3. It can store
strings (e.g. file names), BLOBs (binary data, e.g.
sebcity wrote:
Is it possible to store mp3 files in a SSQLite database? would they be able
to be played from the database? How would you save them?
Write them as a BLOB.
-
To unsubscribe, send email to [EMAIL
Regarding:
sebcity [EMAIL PROTECTED] wrote:
... After you create your tables how do you save them so
they are permenently there?
And Igor T's reply:
They are permanently there from the very moment you create them. All
changes are written to the database file when a transaction is
Ok,so just save them as BLOB files?
Igor Tandetnik wrote:
sebcity [EMAIL PROTECTED] wrote:
Is it possible to store mp3 files in a SSQLite database? would they
be able to be played from the database? How would you save them?
SQLite does not know anything nor care about music or MP3. It
I created a table.
I populated the table.
I exited SQLite.
Started SQLIte again.
Typed select * from table name.
ANd it tells me no such table exists??
Igor Tandetnik wrote:
sebcity [EMAIL PROTECTED] wrote:
Im new to SQLite, After you create your tables how do you save them
so they are
Thanks
Griggs, Donald wrote:
Regarding:
sebcity [EMAIL PROTECTED] wrote:
... After you create your tables how do you save them so
they are permenently there?
And Igor T's reply:
They are permanently there from the very moment you create them. All
changes are written to the
Sorry but could you show me the exact code to create a table that will be
permenently there?
Griggs, Donald wrote:
Regarding:
sebcity [EMAIL PROTECTED] wrote:
... After you create your tables how do you save them so
they are permenently there?
And Igor T's reply:
They are
sqlite3 foo.sqlite
SQLite version 3.3.7
Enter .help for instructions
sqlite CREATE TABLE bar (a, b);
sqlite INSERT INTO bar (a, b) VALUES (1, 'my mp3');
sqlite .quit
.. time passes..
sqlite3 foo.sqlite
SQLite version 3.3.7
Enter .help for instructions
sqlite SELECT * FROM bar;
1|my mp3
Did you open the database when you launched SQLite again? Sorry if this is a
stupid question, but I've never used SQLite from a command line or the shell.
--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/
-- Original message
You store them in the DB as a BLOB type, but save the data as a JPEG,
MP3, WAV or whatever it happens to be. The binary data resides as a DB
column and the same row may have other columns which could be text to
describe the item or a number to store the size etc.
sebcity wrote:
Ok,so just
I typed exactly what you typed there and i get
SQL error: no such table: bar
my command window doesnt have : sqlite3 foo.sqlite like yours
P Kishor-2 wrote:
sqlite3 foo.sqlite
SQLite version 3.3.7
Enter .help for instructions
sqlite CREATE TABLE bar (a, b);
sqlite INSERT INTO bar (a,
Nope, how would i do that?
Eric Pankoke wrote:
Did you open the database when you launched SQLite again? Sorry if this
is a stupid question, but I've never used SQLite from a command line or
the shell.
--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
If you are using Sqlite3 to access the DB you would -0
sqlite3 harry.db3 //Creates a database called harry.db3
enter some SQL to create a table and populate it
exit
To retrieve your data
sqlite3 harry.db3//Opens DB harry.db3
enter some SQL e.g.
SELECT * FROM
SQLite is the C library that does all the db magic. You have to
somehow get to that library, which you can do from a program written
in a variety of different languages, even GUI programs, or, from
another confusingly similar named program called sqlite or sqlite
shell. Since the jump from
Can you describe in more detail the process you're trying to use to do this?
--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/
-- Original message --
From: sebcity [EMAIL PROTECTED]
Nope, how would i do that?
Eric
How much work is potentially involved in implementing more complete ALTER
TABLE support? Specifically DROP COLUMN and ALTER COLUMN.
--
Isaac Raway
Entia non sunt multiplicanda praeter necessitatem.
http://blueapples.org - blog
http://stonenotes.com - personal knowledge management
On Mon, Nov 27, 2006 at 02:40:44PM -0600, John Stanton wrote:
You store them in the DB as a BLOB type, but save the data as a JPEG,
MP3, WAV or whatever it happens to be. The binary data resides as a DB
column and the same row may have other columns which could be text to
describe the item
Just to clear up one thing that is not 100% clear to me.
When you are using SQLite on your machine is it true that you don't need to
have anything installed if you are using a VB wrapper dll. This wrapper can
Create, update, select etc. and nil else is needed.
Now, if I am using this wrapper and
If you have BLOBs over 2GB in size you would not be storing them in some
form of library or archive like Sqlite. You would want to use a more
efficient storage mechanism with faster access, such as a directory of
files.
For storing modestly sized images and sound files and accessing them in
On 11/27/06, RB Smissaert [EMAIL PROTECTED] wrote:
Just to clear up one thing that is not 100% clear to me.
When you are using SQLite on your machine is it true that you don't need to
have anything installed if you are using a VB wrapper dll. This wrapper can
Create, update, select etc. and nil
At one point there was a project that did something like this, and it
was called Route66. I think it used mysql, perl and a player called
splay. You might google it.
Alex
sebcity wrote:
Is it possible to store mp3 files in a SSQLite database? would they be able
to be played from the
It depends on how the wrapper was written. If it is a C wrapper with the
SQLite code compiled in (like the SQLite COM control from NewObjects), then you
are correct that all you need is the wrapper. However, if the wrapper makes
calls to the DLL, then you will still need the SQLite dll along
First: Dump VB and use Delphi.
Second (more seriously): try to find an interface that directly exposes
sqlite. Actually, you may be able to get away with this with your current
wrapper: try replacing the sqlite3.dll file with a new one and see what
happens. I use a Delphi unit to interface with
On Mon, 27 Nov 2006 12:43:24 -0800 (PST), you wrote:
I typed exactly what you typed there and i get
SQL error: no such table: bar
my command window doesnt have : sqlite3 foo.sqlite like yours
If you don't include a database name after the sqlite3 command,
sqlite uses the memory database, which
I don't need the SQLite dll, so I take it the wrapper is of the first type.
I am using the wrapper from TerraInformatica. It is called SQLiteDb.dll
All the SQLite .db files I have to deal with are created by my software with
the wrapper from TerraInformatica, so I take it there is no problem
sqlite3 mydatabase.db3
I always use the extension .db
What is the difference between db3 and db or maybe db2 etc.?
RBS
-Original Message-
From: Kees Nuyt [mailto:[EMAIL PROTECTED]
Sent: 27 November 2006 22:49
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Saving tables
On Mon, 27
On 11/27/06, Isaac Raway [EMAIL PROTECTED] wrote:
I'd like to strongly second this. Avoid NULL columns, even at apparent cost.
Having a valid default value is always better. If a design appears to
require NULL values, then the design is likely critically flawed.
Using NULLS is NOT a critical
On 11/24/06, sandhya [EMAIL PROTECTED] wrote:
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
A JAR file is a ZIP archive that usually contains java (and sometime
The extension doesn't actually matter. You could call it .bob for all SQLite
cares. .db and .db3 are just conventions used to differentiate an SQLite 3
database from an older database.
--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/
On 11/24/06, Salvador Ramirez [EMAIL PROTECTED] wrote:
Hello,
I am having a problem with a table on a sqlite3 database
related with a lock that left by a program that died
abnormally in the middle of a select operating initiated
with a call to sqlite3_prepare(). Now I wonder how to take
off
Use anything you like. Version 3 Sqlite is easy to recognize if you use
.db3.
RB Smissaert wrote:
sqlite3 mydatabase.db3
I always use the extension .db
What is the difference between db3 and db or maybe db2 etc.?
RBS
-Original Message-
From: Kees Nuyt [mailto:[EMAIL PROTECTED]
In my experience, NULL has been used by inexperienced developers to great
detriment to the stability of their projects.
Please note my use of the word likely and the definition of the given
word. In a large portion of cases there is no reason that there would be a
missing or unknown value. There
At 5:36 PM -0600 11/27/06, Jay Sprenkle wrote:
On 11/27/06, Isaac Raway [EMAIL PROTECTED] wrote:
I'd like to strongly second this. Avoid NULL columns, even at apparent cost.
Having a valid default value is always better. If a design appears to
require NULL values, then the design is likely
I like using .sqlite as the extension (or .sqlite3). That way no
Windows program will want to mess with it... usually 3 letter
extensions are grist for the mill
On 11/27/06, John Stanton [EMAIL PROTECTED] wrote:
Use anything you like. Version 3 Sqlite is easy to recognize if you use
.db3.
RB
Hi,Richard
The cases happens in PC. The disk remained is not much, sorts of several
hundreds of Mb .
Then the following step is what I do.
1) Create a 1M bytes size file.
2) create a table and begin to insert data in the table until the disk comes
full.
3) Delete the 1M bytes file.
4) Begin
That is why everything in the world is not painted grey.
There are those of us who find null values distinct and meaningful and
those who don't. I personally prefer null (Unknown, etc.) values versus
contrived values which in effect mean I don't like dealing with nulls so
here's a blank string,
Can anybody give a simple example for domestrating ?
I am puzzled by this topic, how does a music file be sotred in DB as BLOB type?
TKS.
- Original Message -
From: Alex Roston [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Sent: Saturday, October 28, 2006 4:35 AM
Subject: Re: [sqlite]
I think, Through the command line mode it is impossible.
For this you have to write a program which open and reads the (binary)
data in file and inserts it to the sqlite database.
Thanks,
Lloyd
On Tue, 2006-11-28 at 13:36 +0800, LuYanJun wrote:
Can anybody give a simple example for
hi
I'm a newbies in sqlite, i'm a vb programmer. I want to develop
database software (Point of Sales) under vb and sqlite.
From the sqlite official website, i fond that sqlite is great
database.
I need your opinion, is it wrong or right using sqlite as database
for my vb application. Can you
Hello John,
Tuesday, November 28, 2006, 4:08:58 AM, you wrote:
sebcity wrote:
Is it possible to store mp3 files in a SSQLite database? would they be able
to be played from the database? How would you save them?
Write them as a BLOB.
Are there Sqlite ODBC that support BLOB, or maybe other
53 matches
Mail list logo