[sqlalchemy] Re: Dialect for Vertica db connectivity ?
I put a rework of the code posted by Bo into a package https://pypi.python.org/pypi/vertica-sqlalchemy/0.1 Selects, joins, table introspection works. Let me know if you can use it. Does anyone have an email for Bo so I can attribute him and check the license? thanks, James On Saturday, 16 March 2013 22:44:56 UTC, Femi Anthony wrote: Jonathan, thanks a lot. I'll test it out using the postgresSQL dialect. Femi On Friday, March 15, 2013 4:06:33 PM UTC-4, Jonathan Vanasco wrote: @Femi - I did a quick search online, but couldn't find any current ( since HP acquisition ) documentation. HOWEVER -- all of the old documentation and QAs that are still online talk about Vertica reimplementing the PostgreSQL syntax and functions. That's in line with what I remembered earlier, where the psql client was even their recommended command-line interface. ( Also, it was invented/started by the same guy who started PostgreSQL ) It's possible that things have changed, but I would try treating it as PostgreSQL. Unless they did a HUGE 360 pivot, I think that should work. -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
[sqlalchemy] Re: Dialect for Vertica db connectivity ?
Jonathan, thanks a lot. I'll test it out using the postgresSQL dialect. Femi On Friday, March 15, 2013 4:06:33 PM UTC-4, Jonathan Vanasco wrote: @Femi - I did a quick search online, but couldn't find any current ( since HP acquisition ) documentation. HOWEVER -- all of the old documentation and QAs that are still online talk about Vertica reimplementing the PostgreSQL syntax and functions. That's in line with what I remembered earlier, where the psql client was even their recommended command-line interface. ( Also, it was invented/started by the same guy who started PostgreSQL ) It's possible that things have changed, but I would try treating it as PostgreSQL. Unless they did a HUGE 360 pivot, I think that should work. -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
[sqlalchemy] Re: Dialect for Vertica db connectivity ?
doesn't vertica just implement the postgresql sql set one-to-one ? i haven't looked at it in a while, but i remember their sales pitch the trial was all postgres based. -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
[sqlalchemy] Re: Dialect for Vertica db connectivity ?
@Femi - I did a quick search online, but couldn't find any current ( since HP acquisition ) documentation. HOWEVER -- all of the old documentation and QAs that are still online talk about Vertica reimplementing the PostgreSQL syntax and functions. That's in line with what I remembered earlier, where the psql client was even their recommended command-line interface. ( Also, it was invented/started by the same guy who started PostgreSQL ) It's possible that things have changed, but I would try treating it as PostgreSQL. Unless they did a HUGE 360 pivot, I think that should work. -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. For more options, visit https://groups.google.com/groups/opt_out.