Re: [sqlite] .import difficulty
try .import "test.txt" b ; On 6/2/06, cstrader232 <[EMAIL PROTECTED]> wrote: I'm having trouble importing. I'm using sqlite3 from dos. sqlite3 test.db; create table b (a, b, c); .import "test.txt" b; returns "no such table b" tia -- With Best Regards, Vishal Kashyap. http://www.vishal.net.in
[sqlite] Mozilla and SQLlite
Hi , How to write applications with mozilla rendering forms and SQLlite as database as a stand alone application. -- With Best Regards, Vishal Kashyap. http://www.vishal.net.in
[sqlite] How to Upgrade
Dear All , I was wondering to upgrade from one SQLite version to other (refering 3.x). Should I just replace the old sqlite3.exe file with the new one and use the database as it is. The database I have created dabase in 3.2.7 and want to move to 3.3.4. How to go about it. -- With Best Regards, Vishal Kashyap. http://www.vishal.net.in
Re: [sqlite] Using SQLite on networked drive
Deepak , I simply got it done by maping the shared folder to a drive letter and made the connection persistant. Moreover changed all the inherent script was also changed in php cli program and every this is rocking Best Regards, Vishal Kashyap. http://vishal.net.in On 3/3/06, Deepak Kaul <[EMAIL PROTECTED]> wrote: > I was tasked to use sqlite on a NFS mount on MacOSX 10.4. I had > numerous problems with it because MacOSX does not implement locks > properly. It would run for about 15 minutes or so and then I would > start receiving Database Malformed errors. I had to come up with a > different solution. > > I came up with a scheme where only one process would handle updating the > database directly. All other processes locally or remotely would update > the database through a file hand shaking protocol. > > Here is an example > Database Updater Process (Server) > Database Client Process (Client) > > Server defines two directories (queries and responses). > > Client wants to insert, update or delete data from a database. > 1. client creates a file with the necessary information > 2. client moves file into queries directory > 3. server sees new file in queries directory > 4. server parses file > 5. server inserts, updates or deletes data from database. > > Client wants to select data from a database. > 1. client creates a file with the appropriate sql statement > 2. client moves file into queries directory > 3. server sees new file in queries directory > 4. server parses file > 5. server preforms select statement > 6. server creates response file > 7. server moves response file into response directory > 8. client sees new response file in response directory > 9. client parses file > 10. client obtains data > > This scheme is preferred over sockets because if the database updater > process dies you won't lose information. All inserts, updates and > deletes will be sitting in the queries directory waiting for the > database updater process to start again. > > This is just one solution to work around the NFS problem I was having. > If you find NFS does not work for you I would try either some sort of > sockets implementation or some sort of file hand shaking protocol. > > Vishal Kashyap wrote: > > >Dear Ray , > > > > > > > >>I would be interested in knowing how you handle simulatneous inserts and/or > >>updates... > >> > >> > > > >Their is a possibility of simultaneous selects thats all. Moreover the > >shared drive would be mapped > > > > > >-- > >With Best Regards, > >Vishal Kashyap. > >http://www.vishal.net.in > > > > > > > > > > -- > Software Engineer > [EMAIL PROTECTED] > 301.286.7951 > -- With Best Regards, Vishal Kashyap. http://www.vishal.net.in
[sqlite] Using SQLite on networked drive
Dear All , Wanted to know if we can use sqlite database from network drives ? -- With Best Regards, Vishal Kashyap. http://www.vishal.net.in
Re: [sqlite] [kde-announce] Kexi 1.0 beta 1 released
g/> and KOffice <http://www.koffice.org/> projects, it > integrates fluently into both on Linux/Unix. It is designed to be fully > usable also without running KDE Desktop on Linux/Unix, MS Windows and > Mac OS X platforms. > > Kexi is considered as a long awaited Open Source competitor for MS > Access, Filemaker and Oracle Forms. Its development is motivated by the > lack of Rapid Application Development (RAD) tools for database systems > that are sufficiently powerful, inexpensive, open standards driven and > portable across many OSes and hardware platforms. > > > -- > regards / pozdrawiam, > Jaroslaw Staniek / OpenOffice Polska > > Kexi Developer: http://www.kexi-project.org | http://koffice.org/kexi > Kexi Support:http://www.kexi-project.org/support.html > Kexi For MS Windows: http://kexi.pl/wiki/index.php/Kexi_for_MS_Windows > KDE3, KDE4 Libraries For Developing MS Windows Applications: >http://www.kdelibs.com/wiki > ___ > kde-announce mailing list > [EMAIL PROTECTED] > https://mail.kde.org/mailman/listinfo/kde-announce > > > > -- With Best Regards, Vishal Kashyap. http://www.vishal.net.in
Re: [sqlite] ANN: SQLiteSpy 1.5.1 released
Hi , Can I download SQLiteSpy some other link. It seems my ISP has some issues connecting to the site. Much better if someone can e-mail me SQLiteSpy straight away. Thanks in advance. Regards, Vishal Kashyap http://vishal.net.in On 2/2/06, Ralf Junker <[EMAIL PROTECTED]> wrote: > Hello, > > the new SQLiteSpy 1.5.1 has just been released. SQLiteSpy is a single-exe > database manager for SQLite with the complete SQLite library already build > in. SQLiteSpy is the ideal tool for developers as well as customers who want > to explore the insides of their SQLite databases. > > SQLiteSpy is Freeware. You can download it from > > http://www.yunqa.de/delphi/sqlitespy/ > > The new version updates the internal database engine to SQLite 3.3.3 and > includes the following improvements: > > * Attached databases now show up in the schema tree view, including all their > tables, indexes, views and triggers. > > * New File -> Attach Database... menu item. > > * Attached databases can be easily detached using the schema tree view's > context menu. > > * ALTER TABLE ... ADD COLUMN automatically updates the schema tree view. The > schema tree view should now automatically adjust to any internal change to > the database schema. > > * Executing an SQL statement which does not return any data now shows all > columns on top of an empty result grid. This change was requested by many > users who felt confused when the grid was not cleared if no results were > returned. > > Best Regards, > > Ralf > > -- With Best Regards, Vishal Kashyap. http://www.vishal.net.in
[sqlite] Sqllite As server
Dear All, We have an existing Sqlite application which till now was fine running on single machine. Now we need flexibility of client server model. Is this possible with Sqlite ? . Or alternatively is it possible to use Sqlite db file from shared drives. -- With Best Regards, Vishal Kashyap. http://www.vishal.net.in
Re: [sqlite] Importing Tab delimited data
Nemanja, I never knew this could happen. In one of my latest project I had to use sed to convert data into csv. Later this data was imported by import command. But the example stated here would reduce atleast one step in my project. Moreover I am only concerned that the data may not be tab limited by offcource seperated by space. Thanks On 1/30/06, Nemanja Corlija <[EMAIL PROTECTED]> wrote: > On 1/30/06, Clint Bailey <[EMAIL PROTECTED]> wrote: > > Is it possible to import tab delimited data into sqlite in order to > > start testing? > You can use sqlite3 command for that. Something like this: > > E:\SQLite>sqlite3.exe test.db3 > SQLite version 3.2.6 > Enter ".help" for instructions > sqlite> CREATE TABLE test(a, b, c, d); > sqlite> .mode tabs > sqlite> .import "tab_delimited_data.txt" test > sqlite> .mode column > sqlite> SELECT * FROM test LIMIT 10; > > Of course, replace "test" table above with something that matches > number of columns in your input file. > There's a patch attached to > http://www.sqlite.org/cvstrac/tktview?tn=1506 that adds 2 flags to > .import. If you are on windows I can send you sqlite3.exe compiled > with that patch if you need it. > > -- > Nemanja Corlija <[EMAIL PROTECTED]> > -- With Best Regards, Vishal Kashyap. http://www.vishal.net.in
[sqlite] Functions
Dear All , Was looking on the functions code. Wondered if their's any way I can do something like for select from table do something here loop the field have a array of data may be single row but only single column -- With Best Regards, Vishal Kashyap. http://vishalkashyap.tk
[sqlite] VB.Net
Dear All , Any possibility of using VB.NET with Sqlite as Backend. Please do mention some links. -- With Best Regards, Vishal Kashyap. http://vishalkashyap.tk
[sqlite] Stored Procedure or Functions
Dear All , Is their any way we can write simple stored procedures or functions in sqlite. If yes please do guide me I need this functionality in one of my open source project. -- With Best Regards, Vishal Kashyap. http://vishalkashyap.tk
