Charlie Brumbaugh‭

It is not wrong to ask for changes or features or report problems, so long as you realize that the maintainer of the project is under no obligation to make those changes. You aren't paying them, so...

posted 4y ago by Charlie Brumbaugh‭

Let's say I have a script that needs the user to set X number of variables at the start. One can either Pass the arguments in on the command line. Start the program and then have the user input...

6 answers  ·  posted 4y ago by Charlie Brumbaugh‭  ·  last activity 2y ago by Dirk Herrmann‭

Lets say I have two tables, A and B and I need to join a subset of them. Is there best practices of sticking the conditions in the WHERE clause like this, SELECT * FROM A JOIN B on a.fk_b = b....

3 answers  ·  posted 4y ago by Charlie Brumbaugh‭  ·  last activity 1y ago by billkarwin‭

From time to time I will have large structural changes to make on my MySQL DB, things like adding columns, changing datatypes, adding indexes etc. These types of changes result in downtime and what...

1 answer  ·  posted 4y ago by Charlie Brumbaugh‭  ·  last activity 4y ago by meriton‭

I have two tables with millions of records. Every so often I need to join them and exclude just a handful of records where a bit(1) column is set to 1 instead of 0. I can do it with either, WHERE ...

2 answers  ·  posted 4y ago by Charlie Brumbaugh‭  ·  edited 4y ago by Alexei‭

Sometimes, either to reduce the amount of typing big table names or when joining a table to itself one will need to alias a table. Personally I find SQL statements with aliases harder to read and a...

1 answer  ·  posted 4y ago by Charlie Brumbaugh‭  ·  edited 4y ago by Alexei‭

I have a number of command line PHP scripts that are either run by a user or by Windows Task Scheduler. These scripts use DB and API credentials and I am wondering if there is a better way of stori...

1 answer  ·  posted 4y ago by Charlie Brumbaugh‭  ·  edited 4y ago by Charlie Brumbaugh‭

Its possible to execute a MySQL file from the command line like so, mysql -u USER -pPASSWORD < FILENAME which triggers a warning, mysql: [Warning] Using a password on the command line int...

2 answers  ·  posted 4y ago by Charlie Brumbaugh‭  ·  edited 4y ago by ghost-in-the-zsh‭

The objective here is to create a set of square kml coordinates centered on a point. I use this to create a square map centered on a mountain peak and then turn that into a STL that I can 3D print....

2 answers  ·  posted 4y ago by Charlie Brumbaugh‭  ·  edited 4y ago by Moshi‭

You should be able to alias the string to something short. For example, I have git config --global alias.a 'add .' git config --global alias.ci commit and so instead of git add . git commi...

posted 4y ago by Charlie Brumbaugh‭

If one is using SASS to build a websites CSS and using version control one can either, Keep both the SASS and the resulting CSS files in version control. Only storing the SASS files in version con...

4 answers  ·  posted 4y ago by Charlie Brumbaugh‭  ·  last activity 4y ago by ben‭

Let's say I have a table with 10,000 rows and instead of selecting all of the rows at once I select 1,000 at a time like LIMIT 0,1000 LIMIT 1000,1000 etc. Without an ORDER BY statement the or...

1 answer  ·  posted 4y ago by Charlie Brumbaugh‭  ·  edited 3y ago by Alexei‭

I have tables A and B and then I have a many to many join table with foreign keys to both called a_b. Neither foreign key can be null and the combinations for the foreign keys to A and B are unique...

2 answers  ·  posted 4y ago by Charlie Brumbaugh‭  ·  last activity 4y ago by Alexei‭

Let's say we have two tables A and B and a join table C that has foreign keys to both A and B and the combination of those foreign keys is unique. One could either do a unique constraint or a comp...

2 answers  ·  posted 4y ago by Charlie Brumbaugh‭  ·  edited 4y ago by Alexei‭

In programming instead of arrowcode where one has many layers of indented if statements, you can return a result as soon as possible. So instead of, if if end if end if It looks like if ret...

1 answer  ·  posted 4y ago by Charlie Brumbaugh‭  ·  edited 4y ago by Moshi‭