Yes, it is slow actually. But I could not do it with SQL. I wish I could do
more with SQL than code, which would give a good performance improvement.
>From overall application point of view, I may be considering using threads to
>read from database, so that the performance will be improved a bit
Yes, it turned out that achieving the goal with C code is much simpler than
using SQL statements (I also take my limited sql knowledge into account)
Now, I'll have two sqlite3_exec() calls, one of which is invoked by first
call's callback function. This led having some natsy C structs around to
ion as well.
https://github.com/fnoyanisi/sqlite3_capi_extensions
On 26/07/2013, at 5:55 PM, "Rob Slater" wrote:
> I have an iPad app that uses several (4) different SQLITE databases and I
> currently build these databases using Mozilla Firefox SQLite Manager utility
> (on a Ma
This may help
http://stackoverflow.com/questions/5562322/difference-between-int-and-int3-data-types-in-my-sql
On 10/07/2013, at 6:33 PM, Woody Wu wrote:
> On Wed, Jul 10, 2013 at 10:50:06AM +0200, Paolo Bolzoni wrote:
>> Yes, I think it is possible to put only for
>> compatibility reasons. Mayb
Is this a repeated post?
You cannot use shell commands as Sql statements in c api. Write your own export
routine. Here is one I wrote.
https://github.com/fnoyanisi/sqlite3_capi_extensions
On 06/06/2013, at 11:02 PM, Maxime Gerum wrote:
>
> Hello, i’m french, sorry if i make err
Use
http://php.net/manual/en/function.system.php
Or
http://www.php.net/manual/en/function.exec.php
On 30/05/2013, at 10:41 PM, Lior Hazan wrote:
> Dear All,
>
> If I'm using Command Line , I can use the next command
>
> sqlite.exe -init FILENAME file.db
> This let me init the SQLite with so
Once more, googling gives some handy stuff
http://code.google.com/p/csharp-sqlite
On 31/05/2013, at 8:46 PM, Ali Dirik wrote:
> Thanks for answers.
>
> I use c# (VS2008)
> I am looking for c# sample source code.
>
>
> 2013/5/31 Noel Frankinet
>
>> I've used C++, do you want to use anything
This is the first shot from google
http://sqlite-wince.sourceforge.net/index.html
If you'd like to use sqlitecin your app, I do not think it will be an issue for
any playform once you have the proper C compiler. You may try to statically
compiling your application.
On 31/05/2013, at 7:42 PM, Al
The dll and exe should be sufficient to run sqlite.
What version of sqlite are you using?
sqlite3 --version
Not sure about this, but may it be something related to user privilages?
On 22/05/2013, at 11:21 PM, Sean Dzafovic wrote:
> On Wed, May 22, 2013 at 10:30 AM, Igor Tandetnik wrote:
>> On
of
> providing the script file to API?
>
>
> On Tue, May 14, 2013 at 6:07 PM, wrote:
>
>> If you are dealing with CSV files, there is a simple API I wrote you can
>> use.
>>
>> https://github.com/fnoyanisi/sqlite3_capi_extensions
>>
>> I was lo
If you are dealing with CSV files, there is a simple API I wrote you can use.
https://github.com/fnoyanisi/sqlite3_capi_extensions
I was looking for .import functionality for C API, but I ended up writing my
own fınctions.
On 14/05/2013, at 9:39 PM, Richard Hipp wrote:
> On Tue, May 14, 2
ls to read the file line by line and
>> parse each line according to your needs.
>>
>> Here is an example
>>
>> https://github.com/fnoyanisi/sqlite3_capi_extensions
>>
>> On 05/05/2013, at 6:20 PM, Newbie89 <
>
>> sh_tan89@
>
>> >
To read txt, use fread() or fgets() . This is the most convenient answer I
think.
It is up to your programming skills to read the file line by line and parse
each line according to your needs.
Here is an example
https://github.com/fnoyanisi/sqlite3_capi_extensions
On 05/05/2013, at 6:20 PM
What is your format? Please ask questions that make sense!
On 05/05/2013, at 6:09 PM, Newbie89 wrote:
> any example/tutorial?thanks.
>
>
>
> --
> View this message in context:
> http://sqlite.1065341.n5.nabble.com/How-to-read-log-file-format-into-sqlite-database-tp68676.html
> Sent from the
I cannot understand "So I need to create a table Packet right?", but you do
need to create a table first.
You may need to bother yourself by reading the API reference for the functions
I gave.
On 01/05/2013, at 9:09 PM, Newbie89 wrote:
> So I need to create a table Packet right?
He means, in your HOST struct, instead of defining a lot of in variables for
each protocol type, just define your ENUM type to hold all possible protocol
types, so you will insert only one protocol value into your sqlite db.
When you fetch data, it will be just a matter of simple switch/case sta
16 matches
Mail list logo