Video On Using A Database With Ez-builder Through Ez-dbmulti

 
#1

Before I start, this video requires some knowledge of MSSQL server. To do what this video shows, you will need an MSSQL server installed on a machine on your network and will have to setup some tables and possibly some User Defined Stored Proceedures (USP's) in MSSQL Server. It also requires that you have EZ-DBMulti installed and working.

With all of that out of the way, some people have asked me what you would use a database for with EZ-Builder in the past. This is a video of an example of why I use databases. All of this could be done in the script engine in EZ-Builder and could be done with text files instead of a database, but here is an example of what I am doing with the database. There are many more examples that could be provided and the possibilities become pretty endless.

I have over 20 years of experience with MSSQL and with programming in multiple languages for many companies. This video makes some assumptions that the person attempting this has the knowledge necessary to do this. If you are not at that point, there are many sources for help and I will do what I can, especially with EZ-DBMulti, but I wont be able to teach you how to query a database or how to setup a USP or MSSQL. I can check your USP to see if there is anything that I see is wrong with it, or your script in EZ-Builder to call EZ-DBMulti.

There are a few relationships that you need to know about when watching this video. David and Tatia are the parents of McKay and Tanner. Tanner is married to Kaitlynn and they have a daughter (a pretty awesome one if I do say so myself) named Rori. The video shows how the robot can change based on who is using the robot because of a username that is supplied.

Let me know if you have any questions and I will do what I can to help you out if you choose to go down this path. It is a pretty fun one and gives you a lot more capabilities of decision making through queries instead of through if statements in scripts. This is also the reason that I cant wait for the cloud option to be enabled in EZ-Builder. I dont know if extensive queries or USP's will be possible with the cloud feature, but if not, you can always use EZ-DBMulti.

Here is the video.


#2

Great effort and I know it's a lot of work. Guess I will have to Google how to software define a MSSQL server on a dedicated platform and go from there.

Looks like this "Microsoft SQL Server 2014 Express" is free, will it be sufficient for a trial ?

#3

It's more than sufficient. Also download the management tools.

Yes, all express versions are free. I would recommend these and you wouldn't need to upgrade ever unless you end up going far further than I have any plans of going. It doesn't need to be a dedicated machine. Odds are that you could run sql server on the same computer ez builder is running on.

#4

EZ-DBMulti (the compiled version) is available for download from my website but I wont be posting the source until I am finished with this project so that there wont be a lot of changes that you will need to download.


EZ-Robot Plug Ins

If you would like to have the source code, just ask me and I would be more than happy to send it your way. I will also send you the project in EZ-Builder and a backup of the database for you to restore and use.

#5

@CochranRobotics

Hello dear eng,
would you send me the video link plz ? the above link doesn't work

#6

that was old and was rolled into EZ-AI which was rewritten. basically, long story, there wasn't enough interest. For what I wanted databases for, I now do in EZ-AI.