[sqlite] multiple databases

Hello, i am a newbie and i would like to ask if it is possible to use sqlite in order to simulate a wireless network where each node will have each own database. I mean, can i attach each node to a database? What shall i do? I am sorry if my question seems naive, but i am just learning

[sqlite] RE: multiple databases

Mr Samuel thank you very much for your reply. I am a little bit confused though.. I use network simulator 2 and what i am doing is to simulate a wireless network. I have to mention that the simulation is done on the same machine. Network simulator2 uses c++ interface, so i thought that i could

RE: [sqlite] multiple databases

Most likely if you're simulating networks where there is a db in each node then you really want to simulate network traffic based on that db protocol. SQLite is an embedded database that runs in-process and by definition has no network traffic or protocol (except if you count opening a database

[sqlite] SQLite.Net

Hi all, I try to use SQLite (sqlite3.dll) in DotNet; this is my code : SQLiteClient db= new SQLiteClient("test.db"); SQLiteResultSet results; results = db.Execute("create table Table1(one int primary key, two varchar(10));"); results =

RE: [sqlite] SQLite.Net

What .NET wrapper are you using? > -Original Message- > From: Michael Martin [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 19, 2007 7:13 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] SQLite.Net > > Hi all, > > > > I try to use SQLite (sqlite3.dll) in DotNet; this

RE: [sqlite] SQLite.Net

SQLite.NET.2.0.1 -Message d'origine- De : Robert Simpson [mailto:[EMAIL PROTECTED] Envoyé : mercredi 19 septembre 2007 16:31 À : sqlite-users@sqlite.org Objet : RE: [sqlite] SQLite.Net What .NET wrapper are you using? > -Original Message- > From: Michael Martin [mailto:[EMAIL

RE: [sqlite] SQLite.Net

If you're using the Finisar library, it doesn't work with the later sqlite3 libraries. If you're using the PHP one, it hasn't been updated in almost 3 years so it probably has issues as well. Your best bet is to use the ADO.NET 2.0 provider at http://sqlite.phxsoftware.com Robert >

RE: [sqlite] SQLite.Net

I am using this http://www.phpguru.org/static/SQLite.NET.html I have the "attempted to read or write protected memory" exception with this wrapper. If I try to define my own wrapper with sqlite3.dll it crashes on select statement. -Message d'origine- De : Robert Simpson [mailto:[EMAIL

RE: [sqlite] SQLite.Net

And for good reason ... Adapting the sqlite3 api to .NET is not trivial. > -Original Message- > From: Michael Martin [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 19, 2007 8:09 AM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] SQLite.Net > > I am using this

RE: [sqlite] SQLite.Net

Ok, but why I can't use this wrapper http://www.phpguru.org/static/SQLite.NET.html ? -Message d'origine- De : Robert Simpson [mailto:[EMAIL PROTECTED] Envoyé : mercredi 19 septembre 2007 17:16 À : sqlite-users@sqlite.org Objet : RE: [sqlite] SQLite.Net And for good reason ... Adapting

RE: [sqlite] SQLite.Net

The wrapper on phpguru hasn't been updated in almost 3 years and isn't actively maintained or supported. I'm sure it worked fine against an older version of the SQLite engine, but there've been quite a few changes to the engine since then. Robert > -Original Message- > From: Michael

RE: [sqlite] SQLite.Net

Michael, I haven't used the wrapper you mentioned so I can't help with the specific problem in that wrapper. However, I do use the one Robert suggested heavily and can attest to the fact that it is extremely well written and works without errors. It's also an ADO.NET implementation making the

[sqlite] Callback Function Not Working In Example Code

I appreciate the help yesterday. John Stanton's advice with the compiler option got me going. I have the example code from http://www.sqlite.org/quickstart.html running. See code below. However, the callback function is not getting executed. Everything looks correct to me and the callback

RE: [sqlite] Callback Function Not Working In Example Code

Gary, Your email sounds like you are executing an INSERT record command. The callback function is only called when you execute a SELECT and data is returned as a result of your query. Lee Crain ___ -Original Message- From: Gary G Allen

Re: [sqlite] Opinions about per-row tokenizers for fts?

On 9/19/07, Ralf Junker <[EMAIL PROTECTED]> wrote: > >Regarding per-row versus per-column tokenizers, your suggesting to > >have something like 'content_kr TOKENIZER icu_kr' for each variant is > >reasonable, but I'm not certain what gain it would have over simply > >having separate tables for

[sqlite] Moving database connections across threads

Hi- We have an application that wraps SQLite 3.4.1. Due to some vxWorks platform issues with non-standard posix behavior, we are considering compiling SQLite with THREADSAFE = 0, and then having our application make sure that only one thread can access SQLite at a time. I was wondering about

[sqlite] DB initial creation?

Thanks for the help thus far. The nice people on the list have provided me with solutions to my issues I have run into so far. We are considering using SQLite for a backend db on our device. It will be used by the CLI & to store configuration data. I do not see in the source code for any api to

RE: [sqlite] DB initial creation?

Gary, When you execute a sqlite3_open( ) function call, the database will be created if it does not already exist. Lee Crain ___ -Original Message- From: Gary G Allen [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 19, 2007 2:16 PM To:

Re: [sqlite] multiple databases

nadiap wrote: Hello, i am a newbie and i would like to ask if it is possible to use sqlite in order to simulate a wireless network where each node will have each own database. I mean, can i attach each node to a database? What shall i do? I am sorry if my question seems naive, but i am just

Re: [sqlite] DB initial creation?

Sqlite is your friend. It will automatically create the DB if it does not exist. Gary G Allen wrote: Thanks for the help thus far. The nice people on the list have provided me with solutions to my issues I have run into so far. We are considering using SQLite for a backend db on our device.

Re: [sqlite] Moving database connections across threads

The underlying issue with thread misbehaviour is that POSIX file locks are process specific, not thread specific requiring some tormented logic . You only need the POSIX locks if you have multiple access to the same database and are writing to the database. If you have a multi-threaded

Re: [sqlite] multiple databases

I think that his project is to use simulation software to build a model of a network in software using a simulation package like NS2. It models the network by implementing algorithms, not by setting up hardware. Vitali Lovich wrote: I think you need to clarify your needs a bit, cause it seems

Re: [sqlite] multiple databases

[EMAIL PROTECTED] wrote: There are no SQLite-specific talks or tutorials this year Well, my talk Thursday afternoon is on using an SQLite database for storing Tcl/Tk scripts which are used for displaying and modifying SQLite databases. So although your statement is strictly correct, I

[sqlite] DBIException: The name 'bdate' is not a valid index.

Greetings! I have this db containing this table: CREATE TABLE LSOpenJobs ( id integer primary key, ProjID integer, subProjID integer, parent, children, login, cust, proj, PClass, PSubClass, bdate, ddate, edate, pm, pmuk, lang, vendor, vEmail, invoice, ProjFund, PMTime, A_No,