pyodbc VS Bottle

Python can script and view this via pyodbc... https://github.com/mkleehammer/pyodbc/wiki

I am not 100% sure you call stored procedure correctly. in the examples they declare @out parameter for the procedures with output.

pyodbc has the odb2 part figured out. This could be useful instead of reinventing the wheel. The rest I can't think of anything that has been done. Sounds like an interesting project.

From its documentation it looks like pyodbc conforms to the DB API, so you can probably use named parameters by passing a dictionary to execute(), as described here.

~ $ pip show pyodbc Name: pyodbc Version: 4.0.34 Summary: DB API Module for ODBC Home-page: https://github.com/mkleehammer/pyodbc Author: Author-email: License: MIT Location: /data/data/com.termux/files/usr/lib/python3.10/site-packages Requires: Required-by:

I am trying to migrate data from our Enterprise Data Warehouse to one of our own reporting databases via ODBC and Python scripts. The python scripts import pyodbc to handle the database connections and execute SQL queries. A system DSN is defined on our ETL server for each database involved in the process.

See the docs.

Bottle.py: uber-fast and simple python web microframework, about 3x faster, saner, and more memory-efficient than Flask in my experience: https://github.com/bottlepy/bottle

Fossil: distributed version control and much more in a single executable, from the creators of SQLite: https://fossil-scm.org/

This walkthrough I am using as learning material says the vulnerable code (in the first snippet below, from github here: https://github.com/bottlepy/bottle/issues/900), is replicated in the webpage in the second snippet below and so I know this app is vulnerable to the exploit shown in highlighted in the github link.

Here's a web framework in a single file: bottle.py

I don't do much development for microcontrollers or limited resource environments, but it's nice to have a low boilerplate tool for throwing together quick web apps. I've used Bottle for that in the past. It looks like this might have more of an API focus, rather than templates or static pages? Very cool, will check it out.

However much makes sense for your project. bottle.py is a web framework in a single file, and it's about 4500 lines of code. Should you do the same thing? Probably not. But you can.

There was a time, I want to start a new project and have to choose what technologies to use for the frontend and backend parts as well. Research gets me to Aqueduct and Shelf, both of them weren't looking actively developing and supported and that leads me to the idea to make my own small micro-framework like Echo for Golang or Bottle for Python. And it was easy to decide: I've had time and motivation :)

It was developed by Marcel Hellkamp and Bottle was initially released on July 1 2009 it is cross-platform and open-source. its Github repository is https://github.com/bottlepy/bottle. It is integrated with Python, Vue JS, and Jinja.