Database Playtime Session Follow Up

[swatts]

What-ho friends,

I trust you are all well.

We had nearly 60 attendees for this session with some excellent comments and some lovely feedback, it's really appreciated. I'll use this article to tie in the contents to any existing articles and also respond to some of the comments too.

But first I'd like us to think about the next playtime session(s), I'm thinking of an improvised prototype design session. You guys can give us an example or a set of requirements and we could generate a prototype ready for a design review...There is a lot can go wrong with this idea.... The DSH team are kicking the idea around. We'd quite like to expand it out to include DQMH too, so maybe I thrash out the prototype using my templates and the rest of the gang do the same with DQMH.

Here's the articles 

Database Types -----> 174 - Databases - MySQL and SQLite

Connecting to LabVIEW ----> 174 - Databases - MySQL and SQLite

Self-description ----> 177 - Self-Managing Designs Make Your Life Easier

A technique for working with tree controls ---> 74 - Tree Control - A Little Present

A conversation in chat talked about tables and complete queries - using a combination of LIMIT modifier to the SELECT query and 163 - A neat trick for dealing with Large Table Data would help. This would give a nice responsive and scale-able display.

I've used Navicat for ages now and it's saved me a lot of time, check it out here https://www.navicat.com/en/

I also use SQL Server Management Studio in my demos - https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server...

And various toolkits were mentioned - Dr James Powells excellent toolkit - http://sine.ni.com/nips/cds/view/p/lang/en/nid/212894

Fab mentioned SAPHIR in the chat - http://sine.ni.com/nips/cds/view/p/lang/en/nid/209317, http://sine.ni.com/nips/cds/view/p/lang/en/nid/210228

Lots of Love