sqlite, mono, C# cross platform

Question

I am using sqlite in my C# project. MoMA complains about the DLLs and i am unsure what to do on the mac/linux side. What are things i generally need to do when porting external DLLs?

What exactly is MoMA complaining about. As far as I know SQLite is supported by using the Mono.Data.SqliteClient namespace. — Dale Ragan, Apr 12 '09 at 01:30
@DaleRagan That old lib has been all but replaced by Mono.Data.Sqlite now — IanNorton, Nov 22 '11 at 06:50

score 3 · Answer 1 · answered Jun 25 '10 at 14:41

3

You might want to look at the C# reimplementation of SQLite on googlecode. This started life as a line-by-line port of the C++ SQLite but after lots of improvements now outperforms the original for many types of operation.

answered Jun 25 '10 at 14:41

Stewart

4,223
6
31
39

@acidzombie24 - the original was about 5x slower, typically. The latest version is much faster than that as shown in the benchmarks at http://code.google.com/p/csharp-sqlite/wiki/Benchmarks – Stewart Jul 22 '10 at 10:55
@Stewart: You do know that bigger values are worse? as its time and you want the shortest time. Interesting, it looks like some of these values are shorter then SQLite. Very interesting. It looks like most of these values are larger and SQLite is still the fastest on inserting. I wonder what stats i should look at for updates. But, both are pretty fast so it doesnt matter. – Jul 22 '10 at 19:58
2

@acidzombie24 - LOL - I didn't say SQLite was faster overall. I was originally just pointing out that for many (not all) operations it was faster. In my comment, I was merely pointing out that it was now better than "about 5x slower". – Stewart Jul 23 '10 at 10:25
Also, don't bother using this if you want x64... it won't run on anything except x86. – Karl Dec 20 '10 at 01:28
"Any CPU" build is coming to support NHibernate 3.0 straight from the box. [link](http://code.google.com/p/csharp-sqlite/issues/detail?id=77) – NagyI Feb 12 '11 at 18:30
@Karl - it works fine with x64. You just need to be careful when choosing the target platform for the build. – Stewart Feb 24 '11 at 16:42

score 1 · Accepted Answer · answered Apr 12 '09 at 01:29

1

You could use the SQLite assembly that's shipped with Mono - it's derived from the one you are probably using now.

See http://mono-project.com/SQLite for more details

answered Apr 12 '09 at 01:29

AngryHacker

59,598
102
325
594

makes it useless: If you do not have SQLite, download it. There are binaries for Windows and Linux. You can put the .dll or .so along side your application binaries, or in a system-wide library path. – Ivan G. Jul 09 '12 at 14:35

score 1 · Answer 3 · answered Apr 12 '09 at 16:05

1

PHXSoftware's System.Data.Sqlite runs on Mono.

answered Apr 12 '09 at 16:05

Kris Erickson

33,454
26
120
175

sqlite, mono, C# cross platform

3 Answers3

Linked