Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Export DataFrame to SQL table #684

Open
lucasmsoares96 opened this issue May 2, 2024 · 1 comment
Open

Export DataFrame to SQL table #684

lucasmsoares96 opened this issue May 2, 2024 · 1 comment
Assignees
Labels
databases enhancement New feature or request
Milestone

Comments

@lucasmsoares96
Copy link

This is very straightforward in Python

import pandas as pd
from sqlalchemy import create_engine
engine = create_engine('postgresql://username:password@localhost:5432/mydatabase')
df=pd.read_csv('example.csv')
df.to_sql('table_name', engine)

It would be very useful to have this in the Kotlin ecosystem.

@zaleslaw zaleslaw added the enhancement New feature or request label May 2, 2024
@zaleslaw zaleslaw added this to the Backlog milestone May 2, 2024
@zaleslaw zaleslaw changed the title Create Postgres table from CSV Export DataFrame to SQL table May 2, 2024
@zaleslaw zaleslaw self-assigned this May 2, 2024
@zaleslaw
Copy link
Collaborator

zaleslaw commented May 2, 2024

@lucasmsoares96 thanks for the interest and user request!
It will take time, but become a part of the 0.15 or 0.16 release, I believe

I've a little bit edited the name of the issue to avoid creation of a duplicate

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
databases enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants