Raspberry PI - MS SQL Server - Features Speed and Access using Python

Raspberry PI Python MS SQL Server - by popashack
Sorry about the sound guys.

I shot this show some basic features and speed using Python and Tkinter and MS Sql Server. This was amazing how fast this was. This video is not a how to but just shows the results of Tkinter GUI and pyODBC using Python on the PI in Raspian.

I must admitt it took me 10 times as long as it should have, due to a lot of outdated documentation and in some cases lack of docs. This project should ultimately be done on web services with Java or Microsoft Soap XML, but it works this way and it is fast. I am sure those results will work out the same way on the Web services.

I have had this thing about a week, so I cannot wait to get more into it. This is the nerdiest thing I have ever seen. Pretty cool LED's, Motors, robots, and more.

I will try to reproduce this with better volume later or another database that I can show. I have this now in new Raspberry Pi and Windows 10 IoT. This is a book titled Raspberry Pi and Visual Basic - Programming in Windows 10 Iot. The Book coming out in a few weeks.

[DaveNorthWest]

Hi id like to install MS SQL Server and the .NET 8 framework and deploy a ASP/MVC project to run on it. Is this possible you think? I've got the latest PI5 ARM64 . Thanks

[jmarusiak]

Hi, I am working on something very similar. Do you mind sharing any of the documentation you used to create this? I am trying to pass a where clause into MSSQL and return the results like you have via tkinter. Thanks!