- Strength to Increase Rep
- +2
- Strength to Decrease Rep
- -0
- Upvotes Received
- 28
- Posts with Upvotes
- 21
- Upvoting Members
- 11
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
I like to work on networks. Sometimes I dabble in application development?
 | 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 …  |
| | 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 …  |
| | 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 … |
 | Carrie, I want to try to help you with this. But I have a question. Did you write this app firewall yourself, or are you hosting a firewall that was developed by a third party? Regards! |
 | You'd be surprised, but if you spend over a year on a shopping app here are two things you will have wished to have spent more time planning on: sales tax calculation payment gateway integration Best of luck! |
 | Assuming you intend to ignore the sound advice of your compatriots here, I recommend having a look at a tool called Foremost. I'm a specialist and that's what I would use. |
| | Recently made a decision for an app I'm working on to accumulate data in batches AND THEN to insert it into the database with one statement rather than adding 1,000 records through one thousand separate inserts. Is this done better through file or memory? If I write the segments of …  |
| | Hey Gang! I'm hitting a point with my (python/mysql/linux) app for processing large amounts of network records where I need to make a design decision. I definitely want my app to have high performance. Because optimization as a skill set is so rare there is no reason not to employ … |
| | I had some fun this weekend having a go at pdfkit with mixed results. Can anyone nominate a candidate for best PDF writing?  |
| | Maybe this is an outside of the box answer? I think there have been many good suggestions so far, but a custom answer might depend upon what topic you are SEO'ing a website for. Like if we were about to SEO a website about turtles, we might want to try … |
 | Interesting question. I happen to like Qwant better for everything except maps. I don't feel that Google is any longer the leader in search, but probably the leader for maps as of now. Maps and ads.  |
| | I was thinking that one way that a coding team could work would be that coders would be rotated through several roles. This would prevent people from getting too comfortable towards the goal of preventing problem areas (code quality wise) from developing in the department. * Architecture * Production Coding … |
 | "With so many options available, it can be challenging to determine the best fit for the project's needs. " Yes, that's why so many people rush through planning. I now think that the longer you go without writing your first line of code, the better. |
| | I'll admit that I have an opinion about this. Is the point of professional coding to write creative software or to write software that adheres closely to standards? |
| | Hey Gang! OK today I am having trouble with my transaction processing application implemented in python/MySQL. Here is some "working" testing code. import psycopg2 from psycopg2 import Error import binascii from binascii import unhexlify import mysql.connector as mysql sql='''CREATE PROCEDURE testprocedure(OUT tacos INT) BEGIN show tables; SET tacos := 1 …  |
| | Realistically your choice is going to be dominated by two factors, for most people making this decision. **Maintainability **- Finding help to maintain an app written in the older of the two languages will become increasingly difficult over time. **Library Support** - Which of the two languages has better library … |
| | I want to get distracted less! I'm off to a good start, though.  |
| | Hey! I've been asked to store some data from a client in mysql in an encoded format using python. Nothing could be easier, right? I will later need to decode the same data using mysql exclusively. Given that constraint, I thought that base64 would be the go to since nearly … |
| | I had decent luck with Hostinger, but like some of us here I'll admit that I'm shopping around. |
 | Happy New Year web tech friends! Hopefully 2024 will be web-tastic! |
| | I agree with what Dani said. Debug code is so easy to write if you're not used to doing that. I used to think it was only for experts, but it can about double your productivity really. Also, if you try to run the database statements by hand in the …  |
| | More programming fun! OK this time around I'm trying to create a table with the statement, CREATE TABLE tablename ( recnumber SERIAL PRIMARY KEY, recordvalues VARCHAR ( 500 ) NOT NULL, datecreated DATE ) And it basically works, and I can add records using the dba account. However when I … |
| | I'm working on an application, certainly not my first. Some aspects of my coding background are quite informal, for example I have only a rudimentary understanding of source code repositories. Take library formation, for example? I'm reasonably proud that my source is of sufficient quality and organization to pass an … |
| | How do I create a table in postgres that's associated with a specific database? Obviously from the command line one can do Create table tablename (); But how do I make sure that the table is associated with the correct database? CREATE table dbname.tablename(); is giving me the error: ERROR: … |