Tools Used with Xojo

Affinity Designer for creating logo’s, icons, user-interface objects and other graphical projects
Affinity Photo for editing and manipulating photographs
Affinity Publisher (beta) for future desktop publishing
Clip Paint Studio EX mostly for game objects
Rebelle for game characters
Blender for animations
Scirra Construct 3 for game development and creation
Jutoh for writing ebooks
Writers Cafe
HiLogic FontCreator
Brackets for coding responsive websites in HTML5/CSS/JavaScript
Sublime Text Editor for some HTML5/CSS but mostly JavaScript projects
FastStone Screencapture
Blueberry FlashBack for video tutorials
ProShow Producer for slideshows
RagTime for document processing

@Eugene Dakin which tool do you use to setup and maintain databases and which database do you use most. ?

For desktop applications I like to use the SQLite database and use the SQLite Database Browser for manual editing. Loading an SQLite database in memory is nice for applications that need fast information.

Internet applications or a busy business network that requires multiple users accessing the database, I prefer the PostgreSQL database, and the PGAdmin IV editor is nice.

If I am training a class of people who have never seen a database before, then I like to use Microsoft Access because they can visually see the information and the editor is included. Once the students are able to understand the basics behind a database, then its easy for them to use SQLite or PostreSQL.

[quote=423427:@Joost Rongen]@Paul Sondervan - you forgot at least one:

  • QueryDb - the fantastic SQL-tool (+ classes) we have build 2 years ago.[/quote]

Is this a public database editor, and where could I find out more information about it?

For Windows
Actual Installer for packaging app for distribution
kSign for code signing your app
Help Scribble for creating Windows help files
WinSCP for SFTP and FTP client

Pixelmator and GraphicConverter for creating app icons and in-app graphics, although I use Xojo’s iOSImageMaker for the the bazillion different icon sizes I need for iOS.

On OSX:

Default Folder X (https://www.stclairsoft.com/DefaultFolderX/) - Wraps around all OSX file open dialogs. Example: has a list of the most recently touched files

HoudaSpot (https://www.houdah.com/houdahSpot/) - instant file find utility based on the Spotlight index with tons of options

ChronoSync (https://www.econtechnologies.com) - Copy/move/manipulate files on schedule

FIleJuicer (https://echoone.com/filejuicer/) - Tears apart a file into component parts like embedded graphics

GeekTool (https://www.tynsoe.org/v2/geektool/) - Displays things on your desktop like how many days since you rebooted or just a picture.

And one more

Better Touch Tool () - https://folivora.ai - Lots of geeky things to do with mice, trackpads, Touch Bar, Keyboard. I started using it to slow down the track pad tracking while pressing the control key to help make a pixel level selection during a screen shot with SnagIT.

Hi Emily,

I did not think about UML for use with a database. I am sure that UML could be use with DB creation. I do not mean anything negative, and here is a quote from DataVersity:

DataVersity

Sure, it can be used, and I don’t believe that it is common. Maybe someone has better information on this question?

Started using UML back in 1999 already, used Enterprise Architect , but it has fallen into disuse because no one around me is using / understanding it.
Since I use Navicat, I do work with ERD for database design and synchronizing database structures.

[quote=423595:@Eugene Dakin]@Joost Rongen @Paul Sondervan - you forgot at least one:

  • QueryDb - the fantastic SQL-tool (+ classes) we have build 2 years ago.

Is this a public database editor, and where could I find out more information about it?[/quote]

Although we’re using this self made (with Xojo) tool every day intensively in our projects, we have never exposed it to the community, except that we had it shortly in a presentation Paul and I did at the MBS Conferens in Berlin back in 2017.
In short: it abstracts database interaction (sqlite, prostgressql, mysql and sqlserver) using prepared statements under the hood, and enables the developer to create complex parameter-queries and transactional excecution, stores the sql in a encrypted sqlite file in the resource-folder, to be read by the QueryDb class on creation of it’s object.
Sharing means supporting, manuals, adding features and database-engines others want to have in, etc. I just lack the time for it at the moment.

UML:
I fall into an Open Classroom entry that uses UML (with Eclipse) for Data Base and was surprised, three days ago.
That is why I wanted to get your opinion.

Thanks.

may be you could just present it to the community with some video or web site or pdf, without having to support it ?

Is Actual Installer better / easier than Inno Setup ?

I used Inno Setup before I found Actual Installer. After trying the demo version of Actual, I bought it and have no regrets.

I’ll only add : Sketch

Mac:
TextExpander: Somebody mentioned a cheaper alternative, but I feel too embedded to change. Use it mostly for pasting template code ad comments

ScreenFloat: a utility that captures pictures of specified parts of the screen which then float above other windows. I use this primarily for capturing results of code and error messages that I can then relate back to the code when I am trying to debug. Great assistant for trying to deal with the fading memory that comes with aging.

Same with me. Bought Actual and build installers super simple and quickly. Inno is also ok, but just a little more work.

+1
Actual is really easy to use.

Hi, how about PlantUML , Input is a plain file. And there are now a lot of plugins for it.

BR Rainer