question

Ankur A3 avatar image
0 Likes"
Ankur A3 asked Jeanette F commented

How to open sqlite file?

Hi Team,

I would like to open sqlite file directly to check the optimizer results.

Can you help me if it is possible?

Thank you!

FlexSim 23.1.0
filesqliteopen
· 1
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Jeanette F avatar image Jeanette F ♦♦ commented ·

Hi @Ankur A3, was Felix Möhlmann's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always comment back to reopen your question.

0 Likes 0 ·

1 Answer

Felix Möhlmann avatar image
2 Likes"
Felix Möhlmann answered Jason Lightfoot commented

I've used the open source software DB Browser for this once.

https://sqlitebrowser.org/

· 3
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Jason Lightfoot avatar image Jason Lightfoot ♦♦ commented ·
Same here.
0 Likes 0 ·
Ankur A3 avatar image Ankur A3 commented ·

Hi @Felix Möhlmann,

Thank you for your response!

I think we need to download and buy license to make use of it.


The reason I am looking towards it is because my system got down due to some reason and I am not sure whether optimizer has finished the run till that time. Now I can see the sqlite file in the same folder. So I am assuming it might have saved the results and just want to check it.


Thank you!

0 Likes 0 ·
Jason Lightfoot avatar image Jason Lightfoot ♦♦ Ankur A3 commented ·

Can't you just uncheck "Use Default Path" and enter your filename to see the results?

1705674256332.png

1 Like 1 ·
1705674256332.png (18.4 KiB)