# What Database Engine is used for Manager **URL:** \ **Category:** Uncategorized\ **Created:** [December 11, 2014, 5:23am UTC](https://forum.manager.io/t/what-database-engine-is-used-for-manager/1931 "2014-12-11T05:23:50Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![zawwp](https://avatars.discourse-cdn.com/v4/letter/z/48db29/32.png) [@zawwp](https://forum.manager.io/u/zawwp)\ **Post date:** [December 11, 2014, 5:23am UTC](https://forum.manager.io/t/what-database-engine-is-used-for-manager/1931/1 "2014-12-11T05:23:50Z")
Currently, I am evaluating the manager server edition. Can some one tell me what database engine is used for the manager? Is it SQLite? ---
**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\ **Post date:** [December 11, 2014, 5:41am UTC](https://forum.manager.io/t/what-database-engine-is-used-for-manager/1931/2 "2014-12-11T05:41:38Z")
Manager is using proprietary database engine. It’s not SQLite however `Manager.dll` is a managed library written in C# which allows to read/write data in `*.manager` files. You can’t query data through SQL but it can be queried with [LINQ](http://en.wikipedia.org/wiki/Language_Integrated_Query). ---
**Author:** ![zawwp](https://avatars.discourse-cdn.com/v4/letter/z/48db29/32.png) [@zawwp](https://forum.manager.io/u/zawwp)\ **Post date:** [December 11, 2014, 6:34am UTC](https://forum.manager.io/t/what-database-engine-is-used-for-manager/1931/3 "2014-12-11T06:34:01Z")
Under this topic [CSS and DB schema customizations](http://forum.manager.io/t/css-and-db-schema-customizations/974) You stated that there will be fee .NET lib to access the .manager file. When will it be available? ---
**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\ **Post date:** [December 11, 2014, 7:13am UTC](https://forum.manager.io/t/what-database-engine-is-used-for-manager/1931/4 "2014-12-11T07:13:54Z")
It is already available. `Manager.dll` is that library and server edition is using it to access `.manager` files. Do you actually need it and if so, for what use case? Documentation for the library hasn’t been done yet but the library is fully functional. ---
**Author:** ![zawwp](https://avatars.discourse-cdn.com/v4/letter/z/48db29/32.png) [@zawwp](https://forum.manager.io/u/zawwp)\ **Post date:** [December 11, 2014, 7:44am UTC](https://forum.manager.io/t/what-database-engine-is-used-for-manager/1931/5 "2014-12-11T07:44:04Z")
Right now, I don’t need it. But I want to understand how much control has given to user regarding to the data. I love to see the documentation for that library. Do you have estimated time line to come out that documentation? ---
**Author:** ![niknah](https://avatars.discourse-cdn.com/v4/letter/n/f04885/32.png) [@niknah](https://forum.manager.io/u/niknah)\ **Post date:** [January 4, 2015, 2:04am UTC](https://forum.manager.io/t/what-database-engine-is-used-for-manager/1931/6 "2015-01-04T02:04:44Z")
Looks like the user can grab all the data, so it’s not locked away or anything. You can get monodevelop and add a reference to the Manager.dll file and browse around Manager.Model But the program doesn’t look like it uses any database, it’s just a list of objects. .manager files are very slim for this reason. I just loaded up about 5k of transactions and the .manager file is about 500k in size. Everything is loaded into memory. The program is using about 180mb of memory when I play with the file with 5k of transactions, so it can handle a lot more than that. But browsing around the transactions list is slightly slower with 5k transactions(100 pages). ---
**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\ **Post date:** [January 4, 2015, 8:19am UTC](https://forum.manager.io/t/what-database-engine-is-used-for-manager/1931/7 "2015-01-04T08:19:22Z")
Keep in mind, there are a lot of optimizations that could be added to improve performance. I look forward when businesses will start pushing a lot more data into Manager so I can start working on specific use-cases. I don’t want to optimize performance prematurely if nobody really has any performance issues yet. ---
**Author:** ![jacobG](https://avatars.discourse-cdn.com/v4/letter/j/ecc23a/32.png) [@jacobG](https://forum.manager.io/u/jacobG)\ **Post date:** [January 4, 2015, 8:06pm UTC](https://forum.manager.io/t/what-database-engine-is-used-for-manager/1931/8 "2015-01-04T20:06:52Z")
Is there an option to use SQL express or mySQL in the server edition. ---
**Author:** ![theeley](https://avatars.discourse-cdn.com/v4/letter/t/e99b99/32.png) [@theeley](https://forum.manager.io/u/theeley)\ **Post date:** [November 24, 2016, 7:14pm UTC](https://forum.manager.io/t/what-database-engine-is-used-for-manager/1931/9 "2016-11-24T19:14:23Z")
@niknah do you have an example of how you have accessed data from manager using something like c# with reference to manager.dll ? ---
**Author:** ![Giora](https://avatars.discourse-cdn.com/v4/letter/g/35a633/32.png) [@Giora](https://forum.manager.io/u/Giora)\ **Post date:** [November 24, 2016, 7:51pm UTC](https://forum.manager.io/t/what-database-engine-is-used-for-manager/1931/10 "2016-11-24T19:51:33Z")
Lubos, I can send you project with 15,000 invoices + 5,000 sale order records but it is not full double accounting… as I wrote, I’m managing projects costing without “full” double accounting system. If it’ll help you I can send it to you. Giora ---
**Author:** ![niknah](https://avatars.discourse-cdn.com/v4/letter/n/f04885/32.png) [@niknah](https://forum.manager.io/u/niknah)\ **Post date:** [November 24, 2016, 9:23pm UTC](https://forum.manager.io/t/what-database-engine-is-used-for-manager/1931/11 "2016-11-24T21:23:32Z")
Yes, > **[GitHub - niknah/ManagerIO\_ConvertToTransfer: This is a tool to convert...](https://github.com/niknah/ManagerIO_ConvertToTransfer)** > > This is a tool to convert payment/receipts into transfers in manager.io - GitHub - niknah/ManagerIO\_ConvertToTransfer: This is a tool to convert payment/receipts into transfers in manager.io But you may need to update the manager.dll there, it’s not the latest one. ---
**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\ **Post date:** [November 24, 2016, 9:44pm UTC](https://forum.manager.io/t/what-database-engine-is-used-for-manager/1931/12 "2016-11-24T21:44:29Z")
@Giora, that’s fine. But if you have performance issues, you need to give me more context such as on what screens do you experience slowness. ---
**Author:** ![theeley](https://avatars.discourse-cdn.com/v4/letter/t/e99b99/32.png) [@theeley](https://forum.manager.io/u/theeley)\ **Post date:** [November 24, 2016, 10:12pm UTC](https://forum.manager.io/t/what-database-engine-is-used-for-manager/1931/13 "2016-11-24T22:12:53Z")
Thank you very much #niknah, I will have a look at this tomorrow. Much appreciated. This is a good Forum… ---
**Author:** ![Giora](https://avatars.discourse-cdn.com/v4/letter/g/35a633/32.png) [@Giora](https://forum.manager.io/u/Giora)\ **Post date:** [November 25, 2016, 7:04am UTC](https://forum.manager.io/t/what-database-engine-is-used-for-manager/1931/14 "2016-11-25T07:04:14Z")
Hi Lubos I don’t experiencing performance issues in all Manager editions including the cloud. Regards, Giora ---
**Author:** ![FBachofner](https://avatars.discourse-cdn.com/v4/letter/f/51bf81/32.png) [@FBachofner](https://forum.manager.io/u/FBachofner)\ **Post date:** [January 23, 2019, 10:34pm UTC](https://forum.manager.io/t/what-database-engine-is-used-for-manager/1931/15 "2019-01-23T22:34:14Z")
@lubos, you say: > Manager is using proprietary database engine. It’s not SQLite however, on the more recent(?) [8394 guide page](https://www.manager.io/guides/8394), you indicate the following: > 00000000000000000000000000000000.manager is an SQLite database holding a list of businesses, users, and global preferences. Does Manager now use SQLite? Sorry for the Necropost resurrection. This seems like the best discussion of the topic. ---
**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\ **Post date:** [January 23, 2019, 10:52pm UTC](https://forum.manager.io/t/what-database-engine-is-used-for-manager/1931/16 "2019-01-23T22:52:13Z")
Yeah, this is old topic. Manager is using SQLite now. ---
**Author:** ![FBachofner](https://avatars.discourse-cdn.com/v4/letter/f/51bf81/32.png) [@FBachofner](https://forum.manager.io/u/FBachofner)\ **Post date:** [January 23, 2019, 11:12pm UTC](https://forum.manager.io/t/what-database-engine-is-used-for-manager/1931/17 "2019-01-23T23:12:30Z")
@lubos, thank you for your quick reply! > [@lubos](#): > > Manager is using SQLite now. Presumably this means any regular SQLite browser can be used to examine the data? My only other main questions are: 1. how simple is it to specify the location of the database? Various forum posts have described it as “difficult” to find the data files. [I would be running Manager Server edition on Ubuntu or (possibly) Debian . . .] 2. now that you have moved to SQLite, are there still multiple files for multiple companies? Or are all companies put into a single SQLite file? Thanks in advance! ---
**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\ **Post date:** [January 23, 2019, 11:19pm UTC](https://forum.manager.io/t/what-database-engine-is-used-for-manager/1931/18 "2019-01-23T23:19:22Z")
> [@FBachofner](#): > > Presumably this means any regular SQLite browser can be used to examine the data? No. Mostly because Manager is not using normalized schema. But eventually I would like it to use normalized schema - it’s just not practical at the moment considering how often the program changes and not being under constrain of normalized schema makes things a lot more easier. Once the program is feature complete, I imagine I will transition to normalized schema. For now, the only way to access data would be API. > [@FBachofner](#): > > how simple is it to specify the location of the database? Under `Preferences` tab, it will show you `Application Folder` which is where all SQLite databases reside. > [@FBachofner](#): > > now that you have moved to SQLite, are there still multiple files for multiple companies? Yes, every business is still separate SQLite database. ---
**Author:** ![angelgarcia](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/angelgarcia/32/17710_2.png) [@angelgarcia](https://forum.manager.io/u/angelgarcia)\ **Post date:** [January 25, 2019, 10:51pm UTC](https://forum.manager.io/t/what-database-engine-is-used-for-manager/1931/19 "2019-01-25T22:51:27Z")
Hey Lubos, I read a few months a ago that the database is encrypted. Does it mean that I can’t use for example Microsoft PowerBI to access my manager data and do some visualization? ---
**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\ **Post date:** [January 25, 2019, 11:01pm UTC](https://forum.manager.io/t/what-database-engine-is-used-for-manager/1931/20 "2019-01-25T23:01:00Z")
Correct. You cannot [Next page](https://forum.manager.io/t/what-database-engine-is-used-for-manager/1931.md?page=2)