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.

#7

hello @CochranRobotics
please can you tell me how I can connect the EZ-Builder mobile to a database?
It is very urgent and important to the senior project I'm currently working on to graduate. Frown

#8

Dave has not been participating in the forum lately. He ended the EZ-AI project and has been working on other projects outside EZ-B. I would not hold my breath waiting for him to respond.

Alan

#9

@IPIA_KU I don't think CochranRobotics is active on the forum anymore.

Cochran used .Net and SQL database running on Windows desktop with the desktop version of EZ-Builder. If you visit the Plug-In Getting Started Guide you can learn how to make your own plug in and you'll see how this might work and where in .Net you could link to a database, assuming you are proficient with .Net
https://www.ez-robot.com/Tutorials/UserTutorials/146/1

There are many ways you "can" work with a data because EZ-Builder provides many options, but for purely the mobile version I am not sure.

Do you have any specifics like a type of database or what mobile platform?

#10

Oh thanks you guys for informing me that he is not active anymore Smile

@JustinRatliff no i don’t have any specification for the database as long as i can access it through xcode and through ez scripts to make ez builder mobile app.
So i have two applications that should be able to acces this database; one in xcode and the other is ez builder mobile app. *tired*