{"library":"pypyodbc","title":"pypyodbc","description":"A pure Python ctypes-based ODBC module supporting multiple databases (SQL Server, Oracle, MySQL, PostgreSQL, SQLite, etc.). Current version 1.3.6 (2022-08-29). Release cadence is sporadic; last release fixed metadata issues from 1.3.5.","language":"python","status":"active","last_verified":"Fri May 01","install":{"commands":["pip install pypyodbc"],"cli":null},"imports":["import pypyodbc","from pypyodbc import DatabaseError"],"auth":{"required":false,"env_vars":[]},"quickstart":{"code":"import pypyodbc\n\n# Replace with your actual DSN or connection string\nconnection = pypyodbc.connect('DSN=my_dsn;UID=user;PWD=password')\ncursor = connection.cursor()\ncursor.execute(\"SELECT 'Hello, World!' AS greeting\")\nfor row in cursor.fetchall():\n    print(row['greeting'])\ncursor.close()\nconnection.close()","lang":"python","description":"Simple connection and query using a DSN.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}