C# Sqlite on UserVoice

Entity Framework Support

2012-03-27T17:04:53-07:00

pm suggested:
I think can be a very good idea EF Support.

vfs for WinRT [is now started]

2012-03-26T12:24:46-07:00

vfs for WinRT [updated]

2012-03-26T12:24:46-07:00

noah_hart (admin) responded:

Needs some other people to test and confirm functionality

vfs for WinRT [updated]

2012-03-26T12:21:48-07:00

noah_hart said:

Functional as of changeset 3329cf52e93, contributed by Michael Schoneman

vfs for WinRT [updated]

2012-03-14T11:39:02-07:00

Sven said:

Yes, please! That is absolutely required to get applications for Windows 8 tablets.

vfs for WinRT [updated]

2012-03-06T06:26:22-08:00

Michael O. Schoneman said:

I've started work on this. I'm still in the early stages, but I do have a dll that can open and read an existing db. What's the best way to get the stuff I'm working integrated into the project?

vfs for WinRT [updated]

2012-03-04T01:54:13-08:00

Markus Ewald said:

WinRT-compatible databases are few and far between right now (Perst.NET, RavenDB, IndexedDB - 2 commercial, one only available to HTML5) - this would be really useful and work around the native code platform issue (having to include ARM, x64 and x86 builds)

vfs for WinRT

2012-03-01T20:10:34-08:00

Make binding for System.Data.Sqlite

2012-01-31T04:43:10-08:00

Mike Fayer suggested:
Bindings for the OSS System.Data.Sqlite (http://sqlite.phxsoftware.com/) would allow a lot of existing code to work with CS-Sqlite, and also provide a uniform API for sqlite across the major mobile platforms - currently Mono provides an ADO.NET API for iOS and Android, and it would be great if Windows Phone 7 could also be added to the list.

Support UTF-16 [updated]

2011-12-06T01:49:02-08:00

Would love to see this supported, especially for people that are handed a DB to read from that we didn't create ourselves... critical for a Windows Phone application I'm working on.

Jide hem said:

Need UTF-16 support to read moving-pictures Database (for MediaPortal).

Provide NuGet packages [updated]

2011-11-16T08:38:06-08:00

This would greatly simplify deployment.

FObermaier said:

All relevant documentation is here:
http://docs.nuget.org/

Additional information is provided by David Ebbo:
http://blog.davidebbo.com/2011/08/easy-way-to-set-up-nuget-to-restore.html

Support Mono [updated]

2011-09-29T12:50:29-07:00

There are a few problems when trying to run under Mono (2.10.2, most recent official). It would be great to have Mono support, so that the platform-independence transfers over to C#-Sqlite

Рустам Губайдуллин said:

It would be really great if this would be implemented!

Support Mono

2011-09-15T17:40:43-07:00

Michael suggested:
There are a few problems when trying to run under Mono (2.10.2, most recent official). It would be great to have Mono support, so that the platform-independence transfers over to C#-Sqlite

CompactFramework [is now started]

2011-09-02T09:28:54-07:00

I would be happy to see you having a Compact Framework version. Not Windows Phone 7! "Old" CF2.0 or CF3.5 version for older devices.

CompactFramework [updated]

2011-09-02T09:28:54-07:00

I would be happy to see you having a Compact Framework version. Not Windows Phone 7! "Old" CF2.0 or CF3.5 version for older devices.

noah_hart (admin) responded:

Actively working on implementing the CF

Use and install Uservoice account [updated]

2011-08-16T16:04:45-07:00

Fernando Silva said:

Para testar.

Support UTF-16 [updated]

2011-06-12T04:14:40-07:00

Would love to see this supported, especially for people that are handed a DB to read from that we didn't create ourselves... critical for a Windows Phone application I'm working on.

Wilson Chan said:

I also found the same problem, please refer to http://code.google.com/p/csharp-sqlite/issues/detail?id=111&can=1&start=100

Support UTF-16

2011-06-08T22:46:06-07:00

Randy suggested:
Would love to see this supported, especially for people that are handed a DB to read from that we didn't create ourselves... critical for a Windows Phone application I'm working on.

Support Silverlight & Windows Phone 7 [updated]

2011-04-21T18:02:08-07:00

Hi, I'd love to have C#-SQLite available for WP7.

noah_hart (admin) responded:

Silverlight is now fully supported; Thank you Alex West!

Support Silverlight & Windows Phone 7 [is now completed]

2011-04-21T18:01:46-07:00

Hi, I'd love to have C#-SQLite available for WP7.

Provide NuGet packages

2011-04-02T16:27:08-07:00

Mike Reith suggested:
This would greatly simplify deployment.

CompactFramework

2011-03-31T07:31:21-07:00

Bilik Tamás suggested:
I would be happy to see you having a Compact Framework version. Not Windows Phone 7! "Old" CF2.0 or CF3.5 version for older devices.

Include a client [is now declined]

2011-02-28T17:34:13-08:00

Great work so far and it also (my need) runs on WP7 - but a .NET client (useable with WP7) would help a lot

Include a client [updated]

2011-02-28T17:34:13-08:00

Great work so far and it also (my need) runs on WP7 - but a .NET client (useable with WP7) would help a lot

noah_hart (admin) responded:

.NET client already exists; Combined with "Support Silverlight & Windows Phone 7"

Support Silverlight & Windows Phone 7 [is now started]

2011-02-28T17:33:19-08:00

Hi, I'd love to have C#-SQLite available for WP7.

Support Silverlight & Windows Phone 7 [updated]

2011-02-28T17:33:19-08:00

Hi, I'd love to have C#-SQLite available for WP7.

noah_hart (admin) responded:

Silverlight and WP7 needs to be tested under 3.7.5; Awaiting sample WP7 project to include

Make an x64 compatible version [is now completed]

2011-02-28T17:31:27-08:00

I noticed that csharp-sqlite is explicitely x86 to the point even the "Any CPU" profile was changed to output x86. While it does seem to work when recompiling for Any CPU and while there doesn't seem to be any unsafe code left, I wonder if there are any known issues or if it can be officially made x64 compatible (preferably compile to Any CPU)

Make an x64 compatible version [updated]

2011-02-28T17:31:27-08:00

noah_hart (admin) responded:

Corrected with 3.7.5 RC2

Include a client [updated]

2010-08-31T10:09:31-07:00

Great work so far and it also (my need) runs on WP7 - but a .NET client (useable with WP7) would help a lot

noah_hart said:

What about the Community.CsharpSqlite.SQLiteClient already included in the source tree?

Support encryption [is now completed]

2010-08-13T06:31:52-07:00

You have ported the crypto.cs file over to C#, but this is not used anywhere in the project. The original SQLite understands the connection string keyword "password" but the current SqliteConnectionStringBuilder.cs has no mention of it. (As a sidenote there are other keywords that are not implemented are: FailIfMissing, Synchronous, Pooling) Please consider at least supporting encryption! Thanks!

Support encryption [updated]

2010-08-13T06:31:52-07:00

noah_hart (admin) responded:

This has already been done. Basically, you need to compile with the option SQLITE_HAS_CODEC, and that will turn on the encryption routines

make c#sqlite compile with SQLITE_HAS_CODEC [is now completed]

2010-06-22T17:05:36-07:00

make c#sqlite compile with -D SQLITE_HAS_CODE, so it is easier to implement a db encryption layer. all the code hooks are there, so only some code needs to be written to get a per page encrypted db, but current c#sqlite won't compile if SQLITE_HAS_CODEC is defined (there is some #if/#endif mismatch, and some functions/structs aren't ported from c to cs.

make c#sqlite compile with SQLITE_HAS_CODEC [updated]

2010-06-22T17:04:48-07:00

noah_hart said:

Implements SQLITE_HAS_CODED with AesManaged

Pushed working version 6/21 with changeset cfb824b19b6c

Let me know how it works for you

Noah

make c#sqlite compile with SQLITE_HAS_CODEC [updated]

2010-06-10T10:54:56-07:00

noah_hart said:

Work has started on this, and will be tracked under

http://code.google.com/p/csharp-sqlite/issues/detail?id=62

Implement FTS4 support [updated]

2010-03-28T11:49:42-07:00

I think that SQLite is in the process of implementing the next version of FTS (4); That would be a good time to look at implementation

Filip Navara said:

I would be happy for FTS3 support as well since we already use that in our application.

Make an x64 compatible version [is now started]

2010-03-13T04:09:43-08:00

Make an x64 compatible version [updated]

2010-03-13T04:09:43-08:00

Kosenko Max (admin) responded:

Solution needs correction in setting

Make an x64 compatible version [updated]

2010-03-12T16:04:54-08:00

noah_hart said:

It is x64 compatible; Simply add a x64 solution

Remove commented old code [updated]

2010-02-22T15:05:43-08:00

Kosenko Max said:

There are lots of unused comments inside code which left from original SQLite I suppose.

Remove commented old code [updated]

2010-02-22T09:49:49-08:00

noah_hart said:

Which old commented code are we talking about?

Use and install Uservoice account [is now started]

2010-02-19T08:07:59-08:00

Use and install Uservoice account [is now under review]

2010-02-18T12:52:23-08:00

Remove commented old code

2010-02-18T06:15:33-08:00

Implement FTS4 support

2010-02-18T06:09:59-08:00

Kosenko Max suggested:
I think that SQLite is in the process of implementing the next version of FTS (4); That would be a good time to look at implementation

Use and install Uservoice account

2010-02-18T06:08:59-08:00