EuroPython 2019: Conference and training ticket sale opens today

[M.-A. Lemburg]

We will be starting the EuroPython 2019 conference and training ticket
sales

 today (Monday) at 12:00 CEST

  * https://ep2019.europython.eu/registration/buy-tickets/ *



Only 300 training tickets available
---

After the rush to the early-bird tickets last week (we sold more than
290 tickets in 10 minutes), we expect a rush to the regular and
training tickets this week as well.

We only have 300 training tickets available, so if you want to attend
the training days, please consider getting your ticket soon.

Available ticket types
--

We will have the following ticket types available:

- regular conference tickets - admission to the conference days (July
  10-12) and sprints (July 13-14)

- training tickets - admission to the training days (July 8-9)

- combined tickets - admission to training, conference and sprint days
  (July 8-14)

Please see our registration page for full details on the available
tickets.

As reminder, here’s the conference layout:

- Monday & Tuesday, July 8 & 9: Trainings, Beginners’ Day and other
  workshops

- Wednesday–Friday, July 10–12: Conference talks, keynotes &
  exhibition

- Saturday & Sunday, July 13 & 14: Sprints

Combined Tickets


These are a new ticket type we are introducing for EuroPython 2019, to
simplify purchase and check-in at the conference for attendees who
want to attend the complete EuroPython 2019 week with a single ticket.

To make the ticket more attractive, we are granting a small discount
compared to purchasing training and conference tickets separately.



Dates and Venues


EuroPython will be held from July 8-14 2019 in Basel, Switzerland, at
the Congress Center Basel (BCC) for the main conference days (Wed-Fri)
and the FHNW Muttenz for the workshops/trainings/sprints days
(Mon-Tue, Sat-Sun).

For more details, please have a look at our website and the FAQ:

https://ep2019.europython.eu/faq


Help spread the word


Please help us spread this message by sharing it on your social
networks as widely as possible. Thank you !

Link to the blog post:

https://blog.europython.eu/post/185008362672/europython-2019-conference-and-training-ticket

Tweet:

https://twitter.com/europython/status/1130371157440512000


Enjoy,
--
EuroPython 2019 Team
https://ep2019.europython.eu/
https://www.europython-society.org/

-- 
https://mail.python.org/mailman/listinfo/python-list

Re: Why Python has no equivalent of JDBC of Java?

[Thomas Jollans]

On 19/05/2019 14.27, Marco Sulla via Python-list wrote:
> I programmed in Python 2 and 3 for many years, and I find it a fantastic
> language.
> 
> Now I'm programming in Java by m ore than 2 years, and even if I found its
> code much more boilerplate, I admit that JDBC is fantastic.

Python has a the "Python Database API" (DB API 2.0)
https://www.python.org/dev/peps/pep-0249/

All SQL database modules that I know of use this API. It's more
decentralized than JDBC (not that I know much about JDBC), but it does
the trick: as long as the SQL syntax is sufficiently compatible, you can
easily swap in one database for another.

> 
> One example over all: Oracle. If you want to access an Oracle DB from
> Python, you have to:

If Oracle wants to be a pain in the arse, that's Oracle's doing. The
open source databases aren't like that.

-- Thomas
-- 
https://mail.python.org/mailman/listinfo/python-list

Installation Problems with Python 3.7.3

[Carolyn Evans]

I am having trouble with re-installing python 3.7.3.

I keep getting the following message:

Modify
Repair
Remove

I have tried all three numerous times and can not complete the setup

I am working on a Windows 8 system,  64 bit OS,  4GB ram.

How can this be fixed?

Thanks

C. Evans
-- 
https://mail.python.org/mailman/listinfo/python-list

Re: Installation Problems with Python 3.7.3

[Igor Korot]

Hi,

On Mon, May 20, 2019 at 1:53 PM Carolyn Evans  wrote:
>
> I am having trouble with re-installing python 3.7.3.

Why do you need to reinstall?
What seems to be the problem?

Thank you.

>
> I keep getting the following message:
>
> Modify
> Repair
> Remove
>
> I have tried all three numerous times and can not complete the setup
>
> I am working on a Windows 8 system,  64 bit OS,  4GB ram.
>
> How can this be fixed?
>
> Thanks
>
> C. Evans
> --
> https://mail.python.org/mailman/listinfo/python-list
-- 
https://mail.python.org/mailman/listinfo/python-list

Re: Why Python has no equivalent of JDBC of Java?

[Marco Sulla via Python-list]

On Mon, 20 May 2019 at 17:32, Thomas Jollans  wrote:

> Python has a the "Python Database API" (DB API 2.0)
> https://www.python.org/dev/peps/pep-0249/
>

So why Oracle need instantclient for using cx_Oracle? They say they use
DB-API:

> *cx_Oracle* is a Python extension module that enables access to Oracle
> Database. It conforms to the Python database API 2.0 specification
 with
> a considerable number of additions and a couple of exclusions.

https://oracle.github.io/python-cx_Oracle/


On Sun, 19 May 2019 at 23:47, Chris Angelico  wrote:

> I've no idea what the hassles are with Oracle, as it's a database
> engine that I don't use. But with PostgreSQL, which I *do* use, I can
> assure you that it's much easier
>

I use Postgres if I can choose, but companies uses Oracle unluckily. Oracle
and MSSQL. And I must say that surprisingly, being a Microsoft product, I
find MSSQL more simple to install than Oracle, like Postregres, and has an
easier SQL syntax.  Like Postgres.
-- 
https://mail.python.org/mailman/listinfo/python-list

Re: Why Python has no equivalent of JDBC of Java?

[Andrew Z]

What does 249 specification mention about drivers?

On Mon, May 20, 2019, 17:39 Marco Sulla via Python-list <
python-list@python.org> wrote:

> On Mon, 20 May 2019 at 17:32, Thomas Jollans  wrote:
>
> > Python has a the "Python Database API" (DB API 2.0)
> > https://www.python.org/dev/peps/pep-0249/
> >
>
> So why Oracle need instantclient for using cx_Oracle? They say they use
> DB-API:
>
> > *cx_Oracle* is a Python extension module that enables access to Oracle
> > Database. It conforms to the Python database API 2.0 specification
>  with
> > a considerable number of additions and a couple of exclusions.
>
> https://oracle.github.io/python-cx_Oracle/
>
>
> On Sun, 19 May 2019 at 23:47, Chris Angelico  wrote:
>
> > I've no idea what the hassles are with Oracle, as it's a database
> > engine that I don't use. But with PostgreSQL, which I *do* use, I can
> > assure you that it's much easier
> >
>
> I use Postgres if I can choose, but companies uses Oracle unluckily. Oracle
> and MSSQL. And I must say that surprisingly, being a Microsoft product, I
> find MSSQL more simple to install than Oracle, like Postregres, and has an
> easier SQL syntax.  Like Postgres.
> --
> https://mail.python.org/mailman/listinfo/python-list
>
-- 
https://mail.python.org/mailman/listinfo/python-list

Re: Why Python has no equivalent of JDBC of Java?

[Michael Torrie]

On 05/20/2019 04:23 PM, Andrew Z wrote:
> What does 249 specification mention about drivers?

Nothing that I can see.

But it stands to reason that at some point the Python code is going to
have to interface with the SQL database server's API. And when the
database in question is proprietary, the original poster should probably
not be surprised that a special driver install is required. I assume
it's also required for JDBC also, but since Java is owned by Oracle,
they probably install such things automatically.

> 
> On Mon, May 20, 2019, 17:39 Marco Sulla via Python-list <
> python-list@python.org> wrote:
> 
>> On Mon, 20 May 2019 at 17:32, Thomas Jollans  wrote:
>>
>>> Python has a the "Python Database API" (DB API 2.0)
>>> https://www.python.org/dev/peps/pep-0249/
>>>
>>
>> So why Oracle need instantclient for using cx_Oracle? They say they use
>> DB-API:
>>
>>> *cx_Oracle* is a Python extension module that enables access to Oracle
>>> Database. It conforms to the Python database API 2.0 specification
>>  with
>>> a considerable number of additions and a couple of exclusions.
>>
>> https://oracle.github.io/python-cx_Oracle/
>>
>>
>> On Sun, 19 May 2019 at 23:47, Chris Angelico  wrote:
>>
>>> I've no idea what the hassles are with Oracle, as it's a database
>>> engine that I don't use. But with PostgreSQL, which I *do* use, I can
>>> assure you that it's much easier
>>>
>>
>> I use Postgres if I can choose, but companies uses Oracle unluckily. Oracle
>> and MSSQL. And I must say that surprisingly, being a Microsoft product, I
>> find MSSQL more simple to install than Oracle, like Postregres, and has an
>> easier SQL syntax.  Like Postgres.
>> --
>> https://mail.python.org/mailman/listinfo/python-list
>>

-- 
https://mail.python.org/mailman/listinfo/python-list

Re: Why Python has no equivalent of JDBC of Java?

[Chris Angelico]

On Tue, May 21, 2019 at 8:25 AM Andrew Z  wrote:
>
> What does 249 specification mention about drivers?
>

Nothing. PEP 249 defines how a Python app communicates with the
database module. For instance:

import psycopg2
db = psycopg2.connect("...")
with db, db.cursor() as cur:
cur.execute("select * from people where title = %s", [title])
for person in cur:
print(person)

You could replace the first two lines with, say, mysql.connector, or
sqlite3, and the rest of the code doesn't need to care. The only part
that needs to be database-engine-specific is the connection string
passed to the connect() function.

Some of these modules require lower level drivers, because they're
simple wrappers around lower-level C APIs. Others are linked
statically with the entire code required to make the connection (the
sqlite3 module, I believe, is like that). Still others are pure Python
implementations of wire protocols, which means they don't need
anything more than the Python standard library and its socket
services. In the case of Oracle, it sounds like it depends on a
previously-installed Oracle client.

ChrisA
-- 
https://mail.python.org/mailman/listinfo/python-list

Re: Why Python has no equivalent of JDBC of Java?

[Andrew Z]

Exactly right. Im not sure why Marco is wondering about native drivers not
to be a part of python module (for oracle).
Id be very unhappy, if a python module come with a native drivers for
something as complex as a database.

Cx guys gave you the power to install what and how your project requires.
In  Microsoft case .. that would be a different discussion :)

On a flip side, if you dont need oracle specific features, then maybe u
should use something basic for data storage. //but thats a different
discussion


On Mon, May 20, 2019, 19:18 Michael Torrie  wrote:

> On 05/20/2019 04:23 PM, Andrew Z wrote:
> > What does 249 specification mention about drivers?
>
> Nothing that I can see.
>
> But it stands to reason that at some point the Python code is going to
> have to interface with the SQL database server's API. And when the
> database in question is proprietary, the original poster should probably
> not be surprised that a special driver install is required. I assume
> it's also required for JDBC also, but since Java is owned by Oracle,
> they probably install such things automatically.
>
> >
> > On Mon, May 20, 2019, 17:39 Marco Sulla via Python-list <
> > python-list@python.org> wrote:
> >
> >> On Mon, 20 May 2019 at 17:32, Thomas Jollans  wrote:
> >>
> >>> Python has a the "Python Database API" (DB API 2.0)
> >>> https://www.python.org/dev/peps/pep-0249/
> >>>
> >>
> >> So why Oracle need instantclient for using cx_Oracle? They say they use
> >> DB-API:
> >>
> >>> *cx_Oracle* is a Python extension module that enables access to Oracle
> >>> Database. It conforms to the Python database API 2.0 specification
> >>  with
> >>> a considerable number of additions and a couple of exclusions.
> >>
> >> https://oracle.github.io/python-cx_Oracle/
> >>
> >>
> >> On Sun, 19 May 2019 at 23:47, Chris Angelico  wrote:
> >>
> >>> I've no idea what the hassles are with Oracle, as it's a database
> >>> engine that I don't use. But with PostgreSQL, which I *do* use, I can
> >>> assure you that it's much easier
> >>>
> >>
> >> I use Postgres if I can choose, but companies uses Oracle unluckily.
> Oracle
> >> and MSSQL. And I must say that surprisingly, being a Microsoft product,
> I
> >> find MSSQL more simple to install than Oracle, like Postregres, and has
> an
> >> easier SQL syntax.  Like Postgres.
> >> --
> >> https://mail.python.org/mailman/listinfo/python-list
> >>
>
> --
> https://mail.python.org/mailman/listinfo/python-list
>
-- 
https://mail.python.org/mailman/listinfo/python-list

Re: Why Python has no equivalent of JDBC of Java?

[Chris Angelico]

On Tue, May 21, 2019 at 11:10 AM Andrew Z  wrote:
>
> Exactly right. Im not sure why Marco is wondering about native drivers not
> to be a part of python module (for oracle).
> Id be very unhappy, if a python module come with a native drivers for
> something as complex as a database.

I wouldn't be. It's just a client, and sometimes the clients are
pretty simple (see, for instance, the mysql.connector module, which
AIUI is a pure-python implementation of the MySQL wire protocol). The
main reason Python doesn't include any database modules other than
sqlite3 is that there are just way too many of them (PostgreSQL,
MySQL, Oracle, MS SQL, IBM DB2, etc, etc, etc).

> On a flip side, if you dont need oracle specific features, then maybe u
> should use something basic for data storage. //but thats a different
> discussion

I rather doubt that this is open to discussion. From the sound of
things, the choice of database back end has already been made, and the
Python script just has to cope. Otherwise, PostgreSQL would be an
entirely better alternative.

ChrisA
-- 
https://mail.python.org/mailman/listinfo/python-list