Hi everyone, I'm trendtrove Community Center Say Hello! by trendtrove … a passionate writer and SEO specialist. I’m excited to connect with like-minded individuals who share a love for fashion… Re: Help needed with php website Programming Web Development by Dani Daniweb’s forums are not a marketplace and we don’t allow solicitations. However, may I recommend Upwork or (for higher budgets) Toptal? I have had a really good experience hiring from Upwork. Help needed with php website Programming Web Development by Classica Blue Need webmaster fluent in php/mysql to make ongoing updates to my fairly simple e-commerce website. Please advise hourly rate and availability. Re: Python - MySQL - Too many connections? Programming Databases by cored0mp **Are you connecting to MySQL with persistent connections? ** Most coders close connections (…a loop. I haven’t a notion if python mysql connect API is thread-safe. High db connection recycling … a single script opening and closing a connection to MySQL? Hmmm…** `grep -r 'mysql.connect' ../daniwebisthebest | wc 41 220 3928` **… Python - MySQL - Too many connections? Programming Databases by cored0mp …. It gave: mysql.connector.errors.OperationalError: 1040 (08004): Too many connections So I went ahead and made sure to connect.close() everywhere… Re: Python - MySQL - Too many connections? Programming Databases by Dani > So I went ahead and made sure to connect.close() everywhere that I opened a connection How many times do you have a single script opening and closing a connection to MySQL? Is this a web script? Re: Python - MySQL - Too many connections? Programming Databases by Dani …modifying the database. GET Requests: * Open a persistent MySQL connection at the beginning of the PHP script * Execute…PHP script POST Requests: * Open a non-persistent MySQL connection at the beginning of the PHP script * Start… PHP script * End the transaction * Close the MySQL connection On average, a rough guess is that each… Re: Python - MySQL - Too many connections? Programming Databases by Dani Are you connecting to MySQL with persistent connections? What happens if you don't use persistent connections? Also, I'm confused what you mean about it complaining about too many connections simply by you changing how many records a single connection works with? Re: Python - MySQL - Too many connections? Programming Databases by Reverend Jim Generally it is hard to offer SQL suggestions without seeing the code. Are you closing the connection manually, or are you using a context manager? Re: Python - MySQL - Too many connections? Programming Databases by jkon Its hard in a Python script to "create too many connections" to a DB. You don't have many concurrent clients , you don't have web requests , is this a server of some kind ? . From your line " Specifically it was choking on a scanning algorithm." I thought that it might create a new connection for each query (or for a group). … Image Analysis Using Llama 3.2 Vision Instruct Model Programming Computer Science by usmanmalik57 … multimodal models](https://ai.meta.com/blog/llama-3-2-connect-2024-vision-edge-mobile-devices/). The models are lightweight yet… Excited to Join the Daniweb Community! Community Center Say Hello! by devin-dev …’m always excited to explore new ideas, discuss trends, and connect with fellow tech enthusiasts. Looking forward to contributing here, learning… Re: Hello Everyone, I'm Ray Brad Programming Software Development by Osama_21 Hi Ray, can you guide what kind of this error is ? i am getting this on my e-commerce store which is on shopify. I got to know this error from microsoft clarity summary. (Most users encountered JavaScript errors on various product pages, such as "t[n] is not a function" and "Cannot read properties of null (reading 'includes').) Re: Excited to Join the Daniweb Community! Community Center Say Hello! by pritaeas Welcome. Re: Excited to Join the Daniweb Community! Community Center Say Hello! by Dani Hi and welcome! Re: Excited to Join the Daniweb Community! Community Center Say Hello! by autowrecking Hii Weclcome to DaniWeb! Re: Java Language Course Programming Software Development by Dani I would say just a simple understanding of the concept of \[mathematical] variables, and a willingness to learn. Back when I was in school 20 years ago, I recall the business school offering an introduction to Java course as student's first (and often only) foray into programming. Re: Java - Random Number Generation Programming Software Development by WendyDolan Yes, use Java's Random class to generate random numbers like nextInt() and nextFloat(). Example: Random random = new Random(); int randomInt = random.nextInt(); float randomFloat = random.nextFloat(); Hope this helps! Re: OOP Concepts in Java Programming by DEEPAK_84 Java OOPs concepts are the fundamental principle that help in designing and developing the modular applications. The main OOPs concepts in Java are as follows: * Class and objects * Inheritance * Encapsulation * Polymosphism * Abstraction * Association, Aggregation, and Composition. Python Undefined Variable - Mysql Connector Programming Web Development by cored0mp …grateful once again for the advice to use MySQL over Postgres. It's been a pretty smooth…and have been getting an undefined variable error. Mysql is Running. I used the package manager …to replicate it: import base64 import mysql.connector as mysql try: connection=mysql.connect( host="localhost", database=&… Re: Python Undefined Variable - Mysql Connector Programming Web Development by Salem I would suggest you do `pip list` in your working and non-working environments. It seems that `wrap_socket` is deprecated (and insecure) https://github.com/eventlet/eventlet/issues/795 I would have thought your `mysql` would have depended on the right version to begin with. Re: Python Undefined Variable - Mysql Connector Programming Web Development by cored0mp …2.0.1 more-itertools 8.10.0 mysql-connector-python 8.0.15 netifaces 0.11…MarkupSafe 2.1.5 mdurl 0.1.2 mysql-connector-python 8.0.15 netaddr 0.8…Debian really should have had this straightened out. Mysql-Connector is scarcely a niche library. It would… Re: Python Undefined Variable - Mysql Connector Programming Web Development by Salem A couple of things stand out. First, mysql-connector-python is listed at 8.0.15 on both …systems. Looking on https://pypi.org/project/mysql-connector-python/#history that version was released beginning of 2019… Preparing for the upcoming Java Interview in September 2024 with BlackRock Programming by sarfaraz_2 Hello, i've cleared my java certification exam and got the job interview. The interview will … to miss it. Anyone has any helpful resource related to Java Interview Questions please share. Re: Preparing for the upcoming Java Interview in September 2024 with BlackRock Programming by DEEPAK_84 To crack Java interview, your Core Java concepts must be clear. I have studied Core Java interview questions from Scientech Easy where you will get coding related problem with solution that will clear your core java concepts. So you must visit once. Re: Preparing for the upcoming Java Interview in September 2024 with BlackRock Programming by sarfaraz_2 I have been preparing with this free resouce from edureka on Core Java Interview Questions. Re: Python Undefined Variable - Mysql Connector Programming Web Development by cored0mp I tried this on a mint system, a debian system and an ubuntu system with the same error. Should I just bite the bullet and maybe migrate to red hat? That would be skurry but perhaps necessary?? Re: Python Undefined Variable - Mysql Connector Programming Web Development by cored0mp @Salem Thanks again, Salem!! OK I ran `pip install --upgrade` as suggested and predictably pip complained that I should probably be using a python virtual environment. I'm going to spend some time reading up on this today. ...I'd like to request for comments on whether or not this is the right approach? I'd consider it to be the right … Re: Preparing for the upcoming Java Interview in September 2024 with BlackRock Programming by Dani Thank you for the status update. Let us know how it goes! Re: Hello Everyone, I'm Ray Brad Programming Software Development by Dani A long time ago I had a tool that imported a person's top business matches per the [DaniWeb API](https://www.daniweb.com/connect/developers) into Salesforce as potential leads.