sqlite-pcl vs sqlite-net xamarin component

Question

I have installed sqlite-pcl, but there is also component for Xamarin sqlite-net.

What is the main difference between those references? And which of them has better performance?

As I know pcl doesn't support relationships (foreign key), but sqlite-net does. So I use [Indexed] attribute for better performance, does it make seance?

Alex.F · Accepted Answer · 2014-12-04 13:34:18Z

3

They are both based on the same Sqlite.Net library but the PCL project is a fork which tries to improve on the previous project:

This is a fork of the original sqlite-net library (https://github.com/praeclarum/sqlite-net), which aims to improve the code quality by using modern technologies such as PCL (portable class library).

The project will avoid the use of #if-based conditional code and use platform-specific code injection instead.

I welcome pull requests, but keep in mind that this library is in heavy use and all changes must be:

Backwards-compatible (don't change database defaults). Well tested (please add unit tests).

Both don't support foreign keys. Performance-wise the PCL project supposed to be better, but that is untested as far as I know.

answered Dec 4, 2014 at 13:34

Alex.F

6,3513 gold badges43 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

sqlite-pcl vs sqlite-net xamarin component

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related