{"library":"sqlalchemy-solr","title":"SQLAlchemy Solr Dialect","type":"library","description":"Apache Solr dialect for SQLAlchemy, allowing Solr to be queried using SQLAlchemy ORM and Core. Current version 0.2.4.3, supports Python >=3.8 and Solr 6.x-9.x. Release cadence is irregular.","language":"python","status":"active","last_verified":"Mon Apr 27","install":{"commands":["pip install sqlalchemy-solr"],"cli":null},"imports":["from sqlalchemy import create_engine","from sqlalchemy_solr import savoir"],"auth":{"required":false,"env_vars":[]},"links":{"homepage":null,"github":"https://github.com/aadel/sqlalchemy-solr","docs":null,"changelog":null,"pypi":"https://pypi.org/project/sqlalchemy-solr/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null},"quickstart":{"code":"from sqlalchemy import create_engine, text\nimport os\n\n# Solr URL, default 'http://localhost:8983/solr'\nsolr_url = os.environ.get('SOLR_URL', 'http://localhost:8983/solr')\n# Create engine with solr:// prefix, database name is Solr core/collection\nengine = create_engine(f'solr://admin:@localhost:8983/solr/collection1')\nwith engine.connect() as conn:\n    result = conn.execute(text(\"SELECT * FROM collection1 LIMIT 10\"))\n    for row in result:\n        print(row)\n","lang":"python","description":"Connect to a Solr core and run a basic SQL query.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}