Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.
Mango with sqlite databse
-
Hi,
- I would like to know if I can read and write Sqlite data base via SQL data type in mango
- if it is possible what is the driver class name and connection string
- If I install the sqlite database in RAM for fast access of data, still can I connect to that from Mango and how?
thanks
-
Hi Pradeep,
- it is probably possible to exchange data with a Sqlite database using the SQL datasource.
- Google suggested to me the driver: org.sqlite.JDBC and a connection string: jdbc:sqlite:/path/to/database ... We did not include the jar for Sqlite on the classpath. You will want to add that jar to Mango/overrides/lib/ so that the driver is available.
- If you are using a Linux system, I would suspect so, as it will still have an addressable file location for the connection string.
