You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Several users have asked to add support for SQLite in Ultorg.
Ultorg 1.0.6 has some experimental support for SQLite connections, though it has not yet been exposed in the user interface. SQLite support can be enabled as follows:
In Ultorg, click Internals→Services→Databases (expand)→Drivers (right-click)→New Driver.
Click "Add" and locate the JDBC driver JAR file you downloaded in step (1).
Press OK.
Now click back on the "Folders" tab in the sidebar.
Click "Add Data Source" and "Connect to Database...", then select "SQLite" as the driver and "Next".
In the "JDBC URL" field, replace "" with the path to the SQLite file you'd like to connect to. E.g. " jdbc:sqlite:C:\Users\myusername\somedatabase.db".
The main limitation of experimental SQL dialects is that Ultorg has not yet been taught to translate every function in Ultorg's formula language to the vendor-specific SQL dialect.
SQLite also has some additional peculiarities due to the fact that columns are not strongly typed; for example, you may not be able to select filter values that are of a type that is different from the column's declared type (e.g. text values in an INTEGER column). A workaround for the latter is to create a formula field that wraps the value in the TEXT function, to convert all values to strings. Then you can filter on the formula field instead.
The text was updated successfully, but these errors were encountered:
@malcook Great! I've had quite a few people ask about SQLite, so I might make this a bit easier in the future. There are a few other things that need to be implemented on SQLite, such as support for the date/time functions (e.g. to convert from UNIX epoch times or julian times to real displayable timestamps, as mentioned in #15 ).
Several users have asked to add support for SQLite in Ultorg.
Ultorg 1.0.6 has some experimental support for SQLite connections, though it has not yet been exposed in the user interface. SQLite support can be enabled as follows:
The main limitation of experimental SQL dialects is that Ultorg has not yet been taught to translate every function in Ultorg's formula language to the vendor-specific SQL dialect.
SQLite also has some additional peculiarities due to the fact that columns are not strongly typed; for example, you may not be able to select filter values that are of a type that is different from the column's declared type (e.g. text values in an INTEGER column). A workaround for the latter is to create a formula field that wraps the value in the TEXT function, to convert all values to strings. Then you can filter on the formula field instead.
The text was updated successfully, but these errors were encountered: