Author: cored0mp

A script that was working fine on 100 records per batch choked when I fed it 1,000 records.
It gave:

mysql.connector.errors.OperationalError: 1040 (08004): Too many connections

So I went ahead and made sure to connect.close() everywhere that I opened a connection, and the script made it much further but eventually crashed, giving the same error.
Obviously, increasing the connection limit would only encourage sloppy coding? It would be better if I developed a methodology to prevent this type of crash. Because if this were PHP it wouldn't be happening, I admit that.

How can I prevent this type of error from happening again, short of switching to PHP?

This week I'm working on the data warehousing capabilities of my application. Now most people here who have built more than a couple of applications can tell you how useful it is to include a datestamp on records or requests as they come in. The advantages are numerous.

So much so that I'm now fighting the temptation to include a datestamp on every table. Won't that bloat my database?

I suppose what I'm looking for is guidance on making a per table decision to include or exclude the datestamp. Because if space were free I'd put one on every darn table! But space isn't free and my app is likely to generate a factor of five to ten times the amount of metadata per data and so datestamps would put me in danger of doubling that again, or trebling it. That's fine up to a point but will impact load times.

Hello Gang! I'm grateful once again for the advice to use MySQL over Postgres. It's been a pretty smooth experience so far. Unfortunately I had to migrate to a different host and have been getting an undefined variable error.

Mysql is Running. I used the package manager to get python-mysql.connector installed. And yet I keep getting an undefined variable error.

Here is the output:

Exception creating initial db connection
Error:  module 'ssl' has no attribute 'wrap_socket'
Error type:  <class 'AttributeError'>

Here is some test code if you need to replicate it:

import base64
import mysql.connector as mysql
try:
    connection=mysql.connect( host="localhost", database="iheartdaniweb", user="funuser", password="supersekritpass") 
except Exception as error:
    print("Exception creating initial db connection")
    print("Error: ", error)
    print("Error type: ", type(error))
connection.autocommit=True

Thanks in advance gang! Unfortunately the interwebs were no help with this one or I wouldn't bother you guys! Thanks again!! !!