SQLite DB borked when opened on a different machine

Posted by pruefsumme on Super User See other posts from Super User or by pruefsumme
Published on 2010-12-27T15:55:14Z Indexed on 2010/12/27 16:56 UTC
Read the original article Hit count: 244

Filed under:

cross-platform

|

sqlite

Hello,

I'm using SQLite to store some data. The primary database is on a NAS (Debian Lenny, 2.6.15, armv4l) since the NAS runs a script which updates the data every day. A typical "select * from tableX" looks like this:

2010-12-28|20|62.09|25170.0
2010-12-28|21|49.28|23305.7
2010-12-28|22|48.51|22051.1
2010-12-28|23|47.17|21809.9

When I copy the DB to my main computer (Mac OS X) and run the same SQL query, the output is:

2010-12-28|20|1.08115035175016e-160|25170.0
2010-12-28|21|2.39343503830763e-259|-9.25596535779558e+61
2010-12-28|22|-1.02951149572792e-86|1.90359837597183e+185
2010-12-28|23|-1.10707273937033e-234|-2.35343828462275e-185

The 3rd and 4th column have the type REAL. Interesting fact: When the numbers are integer (i.e. they end with ".0"), there is no difference between the two databases. In all other cases, the differences are ... hm ... surprising? I can't seem to find a pattern.

If someone's got a clue - please share!

© Super User or respective owner

Related posts about cross-platform

Creating cross platform applications

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a fair bit of knowledge of Java and C#.NET (prefer C#). What should I use to create small applications that will work well in Windows, Mac and Linux? Speed will probably not be the main concern (small applications; using Sockets etc). >>> More
Is there a trend for cross-platform GUI toolkits?

as seen on Programmers - Search for 'Programmers'
What is the trend like for the usage of cross-platform GUI frameworks right now? Are more people starting to use cross-platform frameworks (such as GTK+, Qt and wxWidgets) or are there more who use more platform-tied frameworks (e.g. Cocoa or WPF)? Is it more or less stagnant? Is it like a rollercoaster… >>> More
Appcelerator Set to Release Titanium Cross-Platform App Dev Technology

as seen on Internet.com - Search for 'Internet.com'
The product will Web developers to use languages they already know to build mobile and desktop apps >>> More
Looking for a permissive and active cross-platform image processing library in C/C++

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm looking a cross-platform image processing library in C/C++ which is under active development. One more requirement: No GPL license. Some references: http://stackoverflow.com/questions/796364/fast-cross-platform-c-c-image-processing-libraries http://stackoverflow.com/questions/1200727/cross-platform-drawing-librar… >>> More
SQLite on C# Cross-Platform Applications

as seen on Stack Overflow - Search for 'Stack Overflow'
Can someone help/guide me with using SQLite lib on Linux (MONO) and Windows (.NET) On linux i use native mono sqlite client, and on windows i use http://sqlite.phxsoftware.com/ is there a way to define 'using' directives like this : #if (linux) using Mono.Data.Sqlite; #else using System.Data… >>> More

Related posts about sqlite

How to add SQLite (SQLite.NET) to my C# project

as seen on Stack Overflow - Search for 'Stack Overflow'
I followed the instructions in the documentation: Scenario 1: Version Independent (does not use the Global Assembly Cache) This method allows you to drop any new version of the System.Data.SQLite.DLL into your application's folder and use it without any code modifications or recompiling… >>> More
dotConnect or "sqlite.phxsoftware.com" for using Entity Framework with SQLite

as seen on Stack Overflow - Search for 'Stack Overflow'
Which is the better choice out of dotConnect or "sqlite.phxsoftware.com" for using Entity Framework with SQLite (in C#)? >>> More
SQLite table does not exist exception for existing SQLite database (and table)

as seen on Stack Overflow - Search for 'Stack Overflow'
I've followed the instructions given here for introducing an existing SQLite database to your Android app. When I query the table "android_metadata" this is fine. But when I run a similar query on my own table "words" (which has _id for primary integer key) I get a table does not exist exception… >>> More
Android Jelly bean database is locked (code 5)

as seen on Stack Overflow - Search for 'Stack Overflow'
Im getting a database is locked (code 5) in my ListActivity the code works in the other versions of the Emulator but fails in the 4.1 version of the emulator E/SQLiteLog( 2132): (5) database is locked E/SQLiteDatabase( 2132): Failed to open database '/data/data/id.online.mydroid/databases/geo… >>> More
Android:accessing assets folder sqlite databse file with .sqlite extension

as seen on Stack Overflow - Search for 'Stack Overflow'
How to read data from the assets folder sqlite database file with .sqlite extension in my android application? Thanks >>> More