# Barebones SQLite support **URL:** \ **Category:** Show and Tell\ **Created:** [November 13, 2015, 11:03am UTC](https://forums.fusetools.com/t/barebones-sqlite-support/2478 "2015-11-13T11:03:47Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Bjorn-Olav\_Strand](https://yyz1.discourse-cdn.com/flex035/user_avatar/forums.fusetools.com/bjorn-olav_strand/32/583_2.png) [@Bjorn-Olav\_Strand](https://forums.fusetools.com/u/Bjorn-Olav_Strand)\ **Post date:** [November 13, 2015, 11:03am UTC](https://forums.fusetools.com/t/barebones-sqlite-support/2478/1 "2015-11-13T11:03:47Z")
I’ve started on a library for SQLite. It now works for iOS, Android and Fuse Local Preview. I’m not sure it’s usable for live apps yet, but I’m sure it will get there if I or someone else start to use it. Anyways, here it is: [https://github.com/bolav/fuse-sqlite](https://github.com/bolav/fuse-sqlite) ---
**Author:** ![Anders\_Lassen](https://yyz1.discourse-cdn.com/flex035/user_avatar/forums.fusetools.com/anders_lassen/32/522_2.png) [@Anders\_Lassen](https://forums.fusetools.com/u/Anders_Lassen)\ **Post date:** [November 14, 2015, 1:51am UTC](https://forums.fusetools.com/t/barebones-sqlite-support/2478/2 "2015-11-14T01:51:23Z")
Sweet! 😃 ---
**Author:** ![eric](https://avatars.discourse-cdn.com/v4/letter/e/898d66/32.png) [@eric](https://forums.fusetools.com/u/eric)\ **Post date:** [December 5, 2015, 7:15am UTC](https://forums.fusetools.com/t/barebones-sqlite-support/2478/3 "2015-12-05T07:15:57Z")
Looks awesome! ---
**Author:** ![Casey\_Williams](https://yyz1.discourse-cdn.com/flex035/user_avatar/forums.fusetools.com/casey_williams/32/147_2.png) [@Casey\_Williams](https://forums.fusetools.com/u/Casey_Williams)\ **Post date:** [December 30, 2015, 6:31pm UTC](https://forums.fusetools.com/t/barebones-sqlite-support/2478/4 "2015-12-30T18:31:14Z")
How would I import the library into my project? ---
**Author:** ![Bjorn-Olav\_Strand](https://yyz1.discourse-cdn.com/flex035/user_avatar/forums.fusetools.com/bjorn-olav_strand/32/583_2.png) [@Bjorn-Olav\_Strand](https://forums.fusetools.com/u/Bjorn-Olav_Strand)\ **Post date:** [December 30, 2015, 6:38pm UTC](https://forums.fusetools.com/t/barebones-sqlite-support/2478/5 "2015-12-30T18:38:48Z")
Either use the `Projects` key in your `.unoproj` file, or copy the files to your project. ---
**Author:** ![Casey\_Williams](https://yyz1.discourse-cdn.com/flex035/user_avatar/forums.fusetools.com/casey_williams/32/147_2.png) [@Casey\_Williams](https://forums.fusetools.com/u/Casey_Williams)\ **Post date:** [December 30, 2015, 7:09pm UTC](https://forums.fusetools.com/t/barebones-sqlite-support/2478/6 "2015-12-30T19:09:31Z")
So I’d add this to my .unoproj ? ```auto "Projects": [ "?????" ] ``` I’d download the GitHub repo and place it where? Then reference it in the Projects key how? Sorry for the ‘newbieness’. ---
**Author:** ![Bjorn-Olav\_Strand](https://yyz1.discourse-cdn.com/flex035/user_avatar/forums.fusetools.com/bjorn-olav_strand/32/583_2.png) [@Bjorn-Olav\_Strand](https://forums.fusetools.com/u/Bjorn-Olav_Strand)\ **Post date:** [December 30, 2015, 7:11pm UTC](https://forums.fusetools.com/t/barebones-sqlite-support/2478/7 "2015-12-30T19:11:38Z")
Not newbie. This should be documented. Point to the unoproj of the other file in Projects. Delete MainView.ux if it contains a tag. ---
**Author:** ![Casey\_Williams](https://yyz1.discourse-cdn.com/flex035/user_avatar/forums.fusetools.com/casey_williams/32/147_2.png) [@Casey\_Williams](https://forums.fusetools.com/u/Casey_Williams)\ **Post date:** [December 30, 2015, 7:18pm UTC](https://forums.fusetools.com/t/barebones-sqlite-support/2478/8 "2015-12-30T19:18:26Z")
Not entirely sure, I’ve got the repo on my desktop and my project is in my documents. Shall I copy the `sqlite.unproj` to my project directory then put this is my `.unoproj` : ```auto "Projects": [ "sqlite.unoproj" ] ``` ? EDIT: This definitely didn’t work haha! ---
**Author:** ![Casey\_Williams](https://yyz1.discourse-cdn.com/flex035/user_avatar/forums.fusetools.com/casey_williams/32/147_2.png) [@Casey\_Williams](https://forums.fusetools.com/u/Casey_Williams)\ **Post date:** [December 30, 2015, 7:24pm UTC](https://forums.fusetools.com/t/barebones-sqlite-support/2478/9 "2015-12-30T19:24:31Z")
Also when compiled I get this: ```auto Failed to load assembly '/Users/caseywilliams/Desktop/fuse-sqlite-master/SQLiteImpl.CIL.dll': Could not load file or assembly '/Users/caseywilliams/Desktop/fuse-sqlite-master/SQLiteImpl.CIL.dll' or one of its dependencies. The system cannot find the file specified. /Users/caseywilliams/Desktop/fuse-sqlite-master/SQLiteImpl.CIL.uno(8,30): E0000: 'SQLiteImpl.OpenImpl(string)' is marked as 'extern', but target does not provide an implementation ``` ---
**Author:** ![Casey\_Williams](https://yyz1.discourse-cdn.com/flex035/user_avatar/forums.fusetools.com/casey_williams/32/147_2.png) [@Casey\_Williams](https://forums.fusetools.com/u/Casey_Williams)\ **Post date:** [December 30, 2015, 7:35pm UTC](https://forums.fusetools.com/t/barebones-sqlite-support/2478/10 "2015-12-30T19:35:21Z")
Sorry about all this! So I just copied the files to a folder within my project and I have pointed my `.unoproj` to the sqlite one and that is all fine. However these are the errors when I attempt to preview: ```auto Generating code and data /Users/caseywilliams/Documents/SSMXCBookingIn/SQLite/SQLiteImpl.CIL.uxl(3,11): E0000: Failed to load assembly '/Users/caseywilliams/Documents/SSMXCBookingIn/SQLite/SQLiteImpl.CIL.dll': Could not load file or assembly '/Users/caseywilliams/Documents/SSMXCBookingIn/SQLite/SQLiteImpl.CIL.dll' or one of its dependencies. The system cannot find the file specified. /Users/caseywilliams/Documents/SSMXCBookingIn/SQLite/SQLiteImpl.CIL.uno(8,30): E0000: 'SQLiteImpl.OpenImpl(string)' is marked as 'extern', but target does not provide an implementation /Users/caseywilliams/Documents/SSMXCBookingIn/SQLite/SQLiteImpl.CIL.uno(11,28): E0000: 'SQLiteImpl.ExecImpl(string,string)' is marked as 'extern', but target does not provide an implementation /Users/caseywilliams/Documents/SSMXCBookingIn/SQLite/SQLiteImpl.CIL.uno(14,28): E0000: 'SQLiteImpl.CloseImpl(string)' is marked as 'extern', but target does not provide an implementation /Users/caseywilliams/Documents/SSMXCBookingIn/SQLite/SQLiteImpl.CIL.uno(17,55): E0000: 'SQLiteImpl.QueryImpl(string,string)' is marked as 'extern', but target does not provide an implementation ``` ---
**Author:** ![Bjorn-Olav\_Strand](https://yyz1.discourse-cdn.com/flex035/user_avatar/forums.fusetools.com/bjorn-olav_strand/32/583_2.png) [@Bjorn-Olav\_Strand](https://forums.fusetools.com/u/Bjorn-Olav_Strand)\ **Post date:** [December 30, 2015, 7:36pm UTC](https://forums.fusetools.com/t/barebones-sqlite-support/2478/11 "2015-12-30T19:36:58Z")
Did you compile the DLL? Try with this, if you didn’t. [https://www.dropbox.com/s/8hhummb1657lgv8/SQLiteImpl.CIL.dll?dl=0](https://www.dropbox.com/s/8hhummb1657lgv8/SQLiteImpl.CIL.dll?dl=0) ---
**Author:** ![Casey\_Williams](https://yyz1.discourse-cdn.com/flex035/user_avatar/forums.fusetools.com/casey_williams/32/147_2.png) [@Casey\_Williams](https://forums.fusetools.com/u/Casey_Williams)\ **Post date:** [December 30, 2015, 7:55pm UTC](https://forums.fusetools.com/t/barebones-sqlite-support/2478/12 "2015-12-30T19:55:50Z")
Works perfectly now thankyou very much! Just starting to learn some Uno now so hopefully I might be a bit better soon! Thankyou again, I can see you have contributed loads to this! ---
**Author:** ![Bjorn-Olav\_Strand](https://yyz1.discourse-cdn.com/flex035/user_avatar/forums.fusetools.com/bjorn-olav_strand/32/583_2.png) [@Bjorn-Olav\_Strand](https://forums.fusetools.com/u/Bjorn-Olav_Strand)\ **Post date:** [December 30, 2015, 8:29pm UTC](https://forums.fusetools.com/t/barebones-sqlite-support/2478/13 "2015-12-30T20:29:12Z")
Please let me know if you have some feature requests, or if you start using this in a real project, and need some production features. (Error handling ++ 🙂 ) ---
**Author:** ![Casey\_Williams](https://yyz1.discourse-cdn.com/flex035/user_avatar/forums.fusetools.com/casey_williams/32/147_2.png) [@Casey\_Williams](https://forums.fusetools.com/u/Casey_Williams)\ **Post date:** [January 1, 2016, 3:42pm UTC](https://forums.fusetools.com/t/barebones-sqlite-support/2478/14 "2016-01-01T15:42:18Z")
Is there anyway I can contact you off forums? If so please email me at: [williamshoops96@gmail.com](mailto:williamshoops96@gmail.com) As I’d like to keep in contact so I can use this in my project, thankyou 🙂 ---
**Author:** ![Bjorn-Olav\_Strand](https://yyz1.discourse-cdn.com/flex035/user_avatar/forums.fusetools.com/bjorn-olav_strand/32/583_2.png) [@Bjorn-Olav\_Strand](https://forums.fusetools.com/u/Bjorn-Olav_Strand)\ **Post date:** [January 1, 2016, 7:29pm UTC](https://forums.fusetools.com/t/barebones-sqlite-support/2478/15 "2016-01-01T19:29:09Z")
I’m on Fuse’s slack, and you can contact me on github. 🙂 ---
**Author:** ![Casey\_Williams](https://yyz1.discourse-cdn.com/flex035/user_avatar/forums.fusetools.com/casey_williams/32/147_2.png) [@Casey\_Williams](https://forums.fusetools.com/u/Casey_Williams)\ **Post date:** [January 1, 2016, 8:29pm UTC](https://forums.fusetools.com/t/barebones-sqlite-support/2478/16 "2016-01-01T20:29:15Z")
Thanks very much!🙂 ---
**Author:** ![massimiliano.aronica](https://avatars.discourse-cdn.com/v4/letter/m/b5ac83/32.png) [@massimiliano.aronica](https://forums.fusetools.com/u/massimiliano.aronica)\ **Post date:** [January 3, 2016, 9:20am UTC](https://forums.fusetools.com/t/barebones-sqlite-support/2478/17 "2016-01-03T09:20:31Z")
Hi Bjorn, when trying to run your sqlite project, I get : Could not load file or assembly ‘Mono.Data.Sqlite, Version=4.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756’ or one of its dependencies. I’m on Windows 10, Fuse version 0.9.5, and I’ve already added the DLL from your dropbox. Where am I wrong ? Thanks Max ---
**Author:** ![Bjorn-Olav\_Strand](https://yyz1.discourse-cdn.com/flex035/user_avatar/forums.fusetools.com/bjorn-olav_strand/32/583_2.png) [@Bjorn-Olav\_Strand](https://forums.fusetools.com/u/Bjorn-Olav_Strand)\ **Post date:** [January 3, 2016, 9:49am UTC](https://forums.fusetools.com/t/barebones-sqlite-support/2478/18 "2016-01-03T09:49:22Z")
Hi Max, I actually don’t know. I haven’t got a Windows computer at the moment. From what I understand the project needs to have explicit Windows support, which is not what I hoped for. 🙂 I will let you know when I have a time to look at it. If you take a look at `test.cs` and `cil_compile.sh` you see what I did to make it work on OSX. ---
**Author:** ![massimiliano.aronica](https://avatars.discourse-cdn.com/v4/letter/m/b5ac83/32.png) [@massimiliano.aronica](https://forums.fusetools.com/u/massimiliano.aronica)\ **Post date:** [January 3, 2016, 10:25am UTC](https://forums.fusetools.com/t/barebones-sqlite-support/2478/19 "2016-01-03T10:25:05Z")
Hi Bjorn, I have just installed Mono on my windows laptop, and have compiled DLL by myself with cil\_compile.sh command to obtain SQLiteImpl.CIL.dll It compiles the dll without errors, but when starting app, it agains claims mono.data.sqlite is missing. So have taken mono.data.sqlite.dll from Mono binaries, and copied it to project directory, no joy. Copied it also to /simulator/Local… where I see other dlls, and restarted the app, same error. No other idea. What I am wondering is if someone else got it working on windows… When you will have time to test it for windows, please let us know. Thanks a lot Max ---
**Author:** ![Casey\_Williams](https://yyz1.discourse-cdn.com/flex035/user_avatar/forums.fusetools.com/casey_williams/32/147_2.png) [@Casey\_Williams](https://forums.fusetools.com/u/Casey_Williams)\ **Post date:** [January 3, 2016, 10:48am UTC](https://forums.fusetools.com/t/barebones-sqlite-support/2478/20 "2016-01-03T10:48:39Z")
Hi Max, I will give it a go on Windows now and let you know what happens. [Next page](https://forums.fusetools.com/t/barebones-sqlite-support/2478.md?page=2)