Comments (11)
I'll try creating a SQLAlchemy dialect for mssql + turbodbc, should be fairly trivial, (except perhaps for unicode data).
from turbodbc.
Took me a bit longer than expected (priorities, learning C, etc.) but I have created a very simple SQLAlchemy dialect for turbodbc + SQL Server.
https://github.com/dirkjonker/sqlalchemy-turbodbc
Feel free to fork/clone/report bugs/create pull requests/etc.
from turbodbc.
@MathMagique of course! Here you go: #66
from turbodbc.
Since the answer to this question is now part of the Readme, and there is initial support for MSSQL with SQLAlchemy, I'll mark this question as resolved.
from turbodbc.
Hi!
Thanks for the question. SQLAlchemy support has not landed yet, so it is not that easy yet.
BUT: My colleague @bjoernmeier already put some work in that. He has even created a pull request for exasol/sqlalchemy-exasol#50, a project which adds a dialect for the Exasolution database. It is probably not as general as one would wish, but it is a start.
from turbodbc.
You would definitely keep your existing FreeTDS driver, though.
from turbodbc.
Short update: The pull request I mentioned above has been accepted.
from turbodbc.
@dirkjonker That would be really awesome! The unicode stuff needs fixing on the turbodbc side, obviously. You could have a look at the codebase of https://github.com/blue-yonder/sqlalchemy_exasol for inspiration. I am not really familiar with that code base, but I suspect a little cargo culting in there ;-).
If you encounter turbodbc issues, please keep reporting them :-)
from turbodbc.
Status update on the MSSQL + turbodbc dialect. It works in certain situations but there are still some weird cases with "invalid cursor state" errors and situations where SQLAlchemy is calling rollback without an active transaction, which also raises errors. Those can probably be solved in the dialect, but I'll report if it's actually turbodbc that is causing problems.
As soon as I have something that works reasonably well I'll release an alpha version under MIT license, should be somewhere this week.
from turbodbc.
That sounds great!
from turbodbc.
Excellent news @dirkjonker! Good job!
If you want, you could create a pull request to include a small SQLAlchemy section in the Readme that mentions your efforts and those at https://github.com/blue-yonder/sqlalchemy_exasol. Otherwise I will just add the note myself :-).
from turbodbc.
Related Issues (20)
- Not detecting installed numpy after installing turbodbc 4.5.6 with Python 3.11 HOT 1
- Arrow support doesn't work in 3.10 with pyarrow-9.0.0/10.0.1 on Ubuntu 22.04
- 4..5.10 produces ImportError with pyarrow-11.0.0 and Python 3.10 on Linux-x86_64 HOT 4
- Issues Parsing Multiple Result Sets HOT 2
- To build turbodbc with arrow support with pyarrow 12.0.0
- Add pyarrow 12.0.0 support
- How to set pre-connect connection attributes? HOT 1
- Advanced use: Arrow 'double' type as supported dtype -> is not a pyarrow dtype? HOT 1
- Using more than 2 threads
- How to deal with Snowflake string length reporting HOT 2
- turbodbc does not play well with poetry HOT 6
- Support pyarrow=14.0.1 HOT 2
- Does turbodbc still need boost as a dependency?
- executemany does not execute sql statement HOT 3
- release 4.10.1 broke pip/poetry installation because of missing dependency. HOT 6
- Can't resolve correct pyarrow verision with pip and pyproject.toml
- Numpy version issue when installing turbodbc
- 4.11.0 Installation error: fatal error C1083: Cannot open include file: 'simdutf.h': No such file or directory HOT 4
- Return pyarrow.RecordBatchReader from cursor.fetcharrowbatches
- Turbodbc + pyarrow installation issue HOT 6
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from turbodbc.