Jump to content

Please read the Forum Rules before posting.

Photo
- - - - -

SQLite


13 replies to this topic

#11 JPG

JPG

    Jon.

  • Moderators
  • 1,678 posts
Online

Posted 24 September 2022 - 08:32 AM

Thanks Jon.

I got me a neat little decompiler called dotPeek by a company called JetBrains. The beaut thing about this program is its free. So you can't beat that. Another thing is that you can export the code have it opened in Visual Studio.

 

All the software I've written are in C#, including the e-Sword Installer Menu (ESM). If you downloaded dotPeek and installed it, you be able to decompile ESM and view the code. (EEKS! I've just given a way for anyone to hack into a program.)

 

Blessings,

Stephen (Php 1:21).

 

 

Hi Stephen,

Did you manage to decompile the e-Sword Library Manager?

Have you made any progress on adding a print feature to it?



#12 APsit190

APsit190

    e-Sword Tools Developer

  • Members (T)
  • PipPipPipPipPip
  • 2,870 posts
  • LocationLand of the Long White Cloud (AKA New Zealand)
Offline

Posted 26 September 2022 - 05:37 PM

Hi Stephen,

Did you manage to decompile the e-Sword Library Manager?

Have you made any progress on adding a print feature to it?

Hi Jon,

All I've done thus far, is look at the code in dotPeek, then imported it into Visual Studio and tried to recompile it. Well, the importation bit worked fine, but the recompiling part didn't.

 

So, it looks like I might just have to write a similar program using his code as a guide.

 

One thing I've noticed in the code is that the author doesn't believe in naming conventions of the Controls. Just sticks with default names that Visual Studio spits out, like main form is just Form1 instead of giving naming it as, e.g., frmMain, frmAbout etc., or something like that. Without having proper names identifying the individual controls and declarations really makes it difficult to identify what belongs to what. So a lot of guess work is going to have to be done, or figure out what belongs to where.

 

With respect to comments with the syntax, dotPeek strips them out, so that is really unhelpful. Comments for the code really goes a long way. One thing is good, is that his code is legible. I can understand it.

 

The fun part is the design of the GUI. And my thought of it is to make it more intuitive by making it flow a lot better, and giving it a cleaner look.

 

Well, that's it from me for now.

 

Blessings,

Autograph.png

Edited by APsit190, 26 September 2022 - 05:38 PM.

X (formerly Twitter)

 


#13 JPG

JPG

    Jon.

  • Moderators
  • 1,678 posts
Online

Posted 27 September 2022 - 05:20 AM

No need to re-invent the wheel.... Just use DB Browser for SQlite.

To get a list of topics from a .topx file use the command

SELECT Title FROM Topics

in the Execute SQL tab.

Then click the Execute SQL button.

Select all those titles in the output window and mouse click for the context menu... Print



#14 APsit190

APsit190

    e-Sword Tools Developer

  • Members (T)
  • PipPipPipPipPip
  • 2,870 posts
  • LocationLand of the Long White Cloud (AKA New Zealand)
Offline

Posted 28 September 2022 - 08:53 PM

No need to re-invent the wheel....

It's funny you said that because of the many brands of SQL type Databases and office software running around. So when looking at this kind of stuff, one would think that the re-invention of the wheel is an ongoing enterprise.

 

That said, you're right, and never said a truer word.

 

Blessings,

Stephen (Php 1:21).
 


X (formerly Twitter)

 




Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users




Similar Topics



Latest Blogs