#1 2020-01-16 09:34:37

keinn
Member
Registered: 2014-10-20
Posts: 103

Sqlite db created by mORMot Framework can Not be operated by 3rd tools

Database created by mORMot Framework can Not be operated by 3rd tools
like  Navicat

take Sqlite3\sample\ 30 - MVC Server for demo,

navicat can open and do select Query operation

but write operation like Insert will trigger an error:

no such collation sequence: SYSTEMNOCASE

Offline

#2 2020-01-16 12:39:31

edwinsn
Member
Registered: 2010-07-02
Posts: 1,218

Re: Sqlite db created by mORMot Framework can Not be operated by 3rd tools

I think you'll have to disable those mORMot's built-in collations, I can't tell the details so please check the document.

Last edited by edwinsn (2020-01-16 12:41:47)


Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.

Offline

#3 2020-01-16 14:28:14

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,661
Website

Re: Sqlite db created by mORMot Framework can Not be operated by 3rd tools

Just inherit from TSQLRecordNoCase or TSQLRecordCaseSensitive instead of plain TSQLRecord, if you don't want to use SYSTEMNOCASE.

You can also override the procedure InternalDefineModel() but it is a bit more verbose.

Offline

#4 2020-01-17 00:20:13

DelphiRio
Member
Registered: 2020-01-17
Posts: 2

Re: Sqlite db created by mORMot Framework can Not be operated by 3rd tools

Hi @ab

If the db created with mORMot by using a password, it can't be open in any 3rd tools. Would you please use https://github.com/utelle/wxsqlite3 for the db engine. It is shipped with encryption and 3rd tools can use the dll from there to open the db files.

This help a lot when debugging because I can take a look into the db, execute SQL query and see the result in 3rd tools.

Thank you very much!

Offline

#5 2020-01-17 02:55:38

edwinsn
Member
Registered: 2010-07-02
Posts: 1,218

Re: Sqlite db created by mORMot Framework can Not be operated by 3rd tools

You can use wxsqlite3 with mORMot with the dynamic linking mode. Search 'wxsqlite'  in https://synopse.info/files/html/Synopse … 01.18.html


Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.

Offline

#6 2020-01-17 05:00:16

DelphiRio
Member
Registered: 2020-01-17
Posts: 2

Re: Sqlite db created by mORMot Framework can Not be operated by 3rd tools

I know the dynamic linking mode. I mean static link mode! wxlsqlite provides full source code with encryption and can be built with C++Builder for linking into the app!

Last edited by DelphiRio (2020-01-17 05:02:54)

Offline

#7 2020-01-17 09:46:01

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,661
Website

Re: Sqlite db created by mORMot Framework can Not be operated by 3rd tools

There is no standard encryption way with SQlite3.
The wxlsqlite version is not standard either.

Our SynDBExplorer tool handles our encryption scheme, and allow to inspect the DB files.

If anyone is willing to find out what is wrong with Delphi XE4 linking bug, and provide a fix, you are welcome!

Offline

#8 2020-01-17 10:04:45

edwinsn
Member
Registered: 2010-07-02
Posts: 1,218

Re: Sqlite db created by mORMot Framework can Not be operated by 3rd tools

ab wrote:

If anyone is willing to find out what is wrong with Delphi XE4 linking bug, and provide a fix, you are welcome!

I guess your last line was intended to reply "Delphi 64bit sqlite compilation" ( https://synopse.info/forum/viewtopic.php?id=5127) big_smile


Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.

Offline

#9 2020-01-17 10:05:11

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,661
Website

Re: Sqlite db created by mORMot Framework can Not be operated by 3rd tools

Yes, XE4 + Win64.

Offline

Board footer

Powered by FluxBB