Re[2]: [sqlite] Music Files

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

[sqlite] vb sqlite

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

Re: [sqlite] Music Files

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

Re: [sqlite] Music Files

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: Sent: Saturday, October 28, 2006 4:35 AM Subject: Re:

RE: [sqlite] SELECT on empty fields ??

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,

RE: [sqlite] A database corrupting case to report

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

Re: [sqlite] Saving tables

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.

Re: [sqlite] SELECT on empty fields ??

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

Re: [sqlite] SELECT on empty fields ??

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.

Re: [sqlite] Saving tables

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]

Re: [sqlite] How to take off a lock on a table

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

RE: [sqlite] Saving tables

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/

Re: [sqlite] whether Sqlite Db supports jar files

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

Re: [sqlite] SELECT on empty fields ??

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

RE: [sqlite] Saving tables

> 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,

RE: [sqlite] Saving tables

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

Re: [sqlite] Saving tables

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"

Re: [sqlite] Saving tables

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

RE: [sqlite] Saving tables

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

Re: [sqlite] Music Files

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

Re: [sqlite] Saving tables

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

Re: [sqlite] Music Files

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

RE: [sqlite] Saving tables

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

Re: [sqlite] Music Files

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

[sqlite] drop/alter column

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

Re: [sqlite] Saving tables

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? >

Re: [sqlite] Saving tables

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

Re: [sqlite] Saving tables

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

Re: [sqlite] Saving tables

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 >

Re: [sqlite] Saving tables

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

Re: [sqlite] Music Files

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

Re: [sqlite] Saving tables

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

Re: [sqlite] Saving tables

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

[sqlite] RE: Re: Saving tables

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

[sqlite] RE: Re: Saving tables

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

Re: [sqlite] Saving tables

I created a table. I populated the table. I exited SQLite. Started SQLIte again. Typed "select * from ". 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

Re: [sqlite] Music Files

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

RE: [sqlite] Re: Saving tables

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

Re: [sqlite] Music Files

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

[sqlite] Re: Music Files

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.

[sqlite] Re: Saving tables

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

[sqlite] Music Files

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.

[sqlite] Saving tables

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

Re: [sqlite] Re: make test fails for 32bit integers (-DSQLITE_INT64_TYPE=int -DSQLITE_32BIT_ROWID=1)

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

[sqlite] Re: Re: Re: combination of fields with || ?

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

RE: [sqlite] SELECT on empty fields ??

> -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

Re: [sqlite] Cross-compiling sqlite fails

"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

Re: [sqlite] SELECT on empty fields ??

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,

Re: [sqlite] sqlite 3.3.8 and OpenWatcom ?

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 ...

Re: [sqlite] A database corrupting case to report

"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. >

Re: [sqlite] Re: Re: combination of fields with || ?

That doesn´t work. The result of : (case when f1 then ', ' else '' end) is allways '' - Original Message - From: "Igor Tandetnik" <[EMAIL PROTECTED]> To: "SQLite" Sent: Monday, November 27, 2006 6:00 AM Subject: [sqlite] Re: Re: combination of fields with || ?

[sqlite] sqlite 3.3.8 and OpenWatcom ?

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

[sqlite] A database corrupting case to report

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