Hello
I have written a small Wep application with PHP (PDO Apache,). This web app
uses a sqlite db3 database. Also there is a Windows application which uses
the same database file.
Now we heard one time that there war a problem and in a log file we saw the
error code
"Database is locked"
My questio
14 Jan 2016, at 10:57am, Werner Kleiner wrote:
>
> > I have written a small Wep application with PHP (PDO Apache,). This web
> app
> > uses a sqlite db3 database. Also there is a Windows application which
> uses
> > the same database file.
> > Now we heard one tim
;) ;
instead of
$dbConnection->setAttribute(PDO:: ATTR_TIMEOUT, 60);
is this the same?
Werner
2016-01-14 16:00 GMT+01:00 Simon Slavin :
>
> On 14 Jan 2016, at 1:42pm, Werner Kleiner wrote:
>
> > The windows application is written in C# and uses the
> sqlite.systemData.
/16, Werner Kleiner wrote:
> > Hello
> > I have written a small Wep application with PHP (PDO Apache,). This web
> app
> > uses a sqlite db3 database. Also there is a Windows application which
> uses
> > the same database file.
> > Now we heard one time that there
Hello,
a program written in C# makes inserts from an SQL script into a sqlite db.
We now saw that the database will be malformed after 6000 records.
Is there a limitation with huge inserts?
What could be the problem?
regards
Werner
___
sqlite-users mail
t; access to the database and how is the native library compiled and configured?
>
> Jim Borden
> (Sent from a mobile device)
>
>> On 4 Oct 2016, at 19:12, Werner Kleiner wrote:
>>
>> Hello,
>> a program written in C# makes inserts from an SQL script into a sqlite d
Hello,
I am a little bit confused about the sqlite db version numbers.
1. On Windows 7 I have created a new db with command
sqlite3.exe test.db3
The sqlite3.exe is from date 2013-05-20 and the version number shows 3.7.17
2. Same computer but now I create a db with sqlite3.exe from 2016-09
Hello,
In an error log there is a message like:
SQlite warning (284) automatic index on is_mytable(internalvalue)
What does this mean?
Can sqlite not use the index correct?
How can we check or optimize the index?
What do I have to do to cancel the message?
Here is the Table DDL:
-- Table: is_my
I have dropped the double index
DROP INDEX 'InternalName';
Then executed the SQL Select statement which caused the sqlite warning.
But same warning, nothing changed.
Then I added a new index CREATE INDEX idx_installid ON ...
Now the sqlite warning is gone away. :-)
The SQL statement has a JOIN
The result is:
2015-05-04 19:13:25 850c11866686a7b39d7b163fb60898c11283688e
2016-10-24 14:28 GMT+02:00 Richard Hipp :
> Please post the result of the following query:
>
> SELECT sqlite_source_id();
>
> On 10/24/16, Werner Kleiner wrote:
>> I have dropped the doubl
Hello,
there is a small application which uses MYSQL db and can also switch to sqlite
In MySQL a table "prices" has a column "basicprice" which is decimal(7,4)
I can store a price in form 1.500 there.
Same table and same columns in sqlite with datatype float(7,4) stores
this value like
1.5
It would
<<:
> On 30 Nov 2016 at 14:42, Werner Kleiner wrote:
>
>> Hello,
>> there is a small application which uses MYSQL db and can also switch to
>> sqlite
>> In MySQL a table "prices" has a column "basicprice" which is decimal(7,4)
>> I
<< All you need to store in the database table is the number. How it is
formatted for viewing or printing is controlled by the user interface.
yes thats right, but it would be nice to have same behavior between
MySQL and sqlite
I think to use a char datatype is not a good solution.
2016-11-30 16:
@Simon
<:
> << All you need to store in the database table is the number. How it is
> formatted for viewing or printing is controlled by the user interface.
>
> yes thats right, but it would be nice to have same behavior between
> MySQL and sqlite
> I think to use a char datatype is not a good sol
As I can see storing prices is a topic with different ways and
different solutions.
The advice to store prices in Cent or Integer:
Yes you can do: but how will you sore hundredth cents amounts or tenth
cent prices?
I have prices like 0,0020 or 0,0008 Euro
I think I have to manipulate the prices f
Your examples would then be stored as 20 or 8 respectively. And every other
> possible value you could store in the MySQL you can now store in SQLite,
> consistently.
>
> -- Darren Duncan
>
> On 2016-12-01 12:08 AM, Werner Kleiner wrote:
>>
>> As I can see stor
Hello Simon,
thanks for help.
I use the PDO library.
The typeOf results in "real"
If I change the "swsalary" column to "numeric(10,0) it results in integer
and then the value of
5 ist stored correct without . (dot).
So is it better to take datatype "numeric" for storing amounts without dots
>SQLite does not understand column types like "numeric(10,0)". It has only
two number types: INTEGER and >REAL.
So if the column is datatype REAL and you will store amount 5, SQLite
results in 5000.0 ?
Why not 5.0 ?
And if the columns datatype is REAL, you need a helper tool or script wh
Hmm, but would it not be better to store the value 5 as
5.0 , which would be correct for the decimal point
instead of
5000.0 ?
--
View this message in context:
http://sqlite.1065341.n5.nabble.com/Storing-amount-tp75527p75539.html
Sent from the SQLite mailing list archive at Nabble.com.
Strange thing is:
If I connect to this db with PHPLiteadmin it tells me "No Table in Database"
But if I connect on Windows with e.g. Sqlitestudio all is fine.
???
--
View this message in context:
http://sqlite.1065341.n5.nabble.com/General-error-11-malformed-database-schema-near-NOCASE-tp7557
What I mean is: The original MySQL DB has columns with int(10). And the
converting tool converts all these columns in SQLite to Int
I can change the conversion so that all columns would be INTEGER in SQLite.
As I understand for SQLite it is equal if the column is declared as Int or
INTEGER?
--
Simon Slavin-3 wrote
> There is no need to do anything special. f you use 'Int' in SQLite it
> will be interpreted as 'INTEGER' anyway.
Yes, but back to my datareader problem it seems that the Datareader differs
between a column which is 'INTEGER' or 'Int'.
Especially we had a problem with a
What we use is this:
System.Data.SQLite
System.Data.SQLite Download Page
http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
And this is not part of SQLite?
--
View this message in context:
http://sqlite.1065341.n5.nabble.com/SQLite-Datareader-problems-with-Int-tp75670p75
23 matches
Mail list logo