Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Search
I need to rename one column in 170 tables in a MySQL database and its going really slow. The columns all have an index plus a foreign key on them, would dropping the index/temporarily removing the...
This is a bit opinionated, but personally, I would not do it. It would just clutter the code and could hide sources of bugs. But it depends a lot on what function it is. It's also hard to give a ve...
I am considering either removing some columns or changing the datatypes if I could significantly reduce the amount of storage that is currently used by those columns. Some of the columns are ints a...
I just completed my first install of SQL as a server-based, Enterprise Edition. I wanted to check it out using SSMS on PC using my Admin Access. But could not connect. For security reasons my adm...
Why SDL (the Simple Directmedia Layer) apps are showing in a single quarter of the window, while the other three are blacked out, and what can I do about it? I'm using Xcode. I think this started h...
My team lead, pointed out the issue. As I could not find the issue/solution here, posting it for others. I knew I could not use windows authentication, so I was trying to use SQL Server Authentica...
Easy enough: if this code is only ever going to be used in a browser, just add it to the Window object: export default class AutoComplete { // ... }; window.AutoComplete = AutoComplete; You c...
I added a QPushButton to my ui file named pushButton, and manually connected it using connect. There are no errors or warnings emitted at any point in the compilation stage The button does show up...
When creating a new Blazor Webassembly project, there is a checkbox ASP.NET Core hosted where if selected will create three projects at once, a blazor webassembly project, an ASP.NET Core project, ...
(The user who created the tag) The tag was to make it clear that (somewhat) opinion-based questions are allowed on site, with the [software-practices] marking which questions are about "best practi...
I cannot find anything in the Oracle documentation (apart from the reference that you found already). However, by looking at the source code (for javax.swing.UIManager) I can see references to the...
I agree that company name tags should not be used, since tag can point to a product, framework etc. and that tag description includes the information about the owner of the product. Of course, for ...
If one finds where the past number of months equals the past number of days like this, select distinct DATE_SUB(now(), INTERVAL 92 DAY),DATE_SUB(now(), INTERVAL 3 MONTH) The numbers that are curre...
I think the best solution is to have specific canned close reasons, with vetted messages clearly communicating what was bad, why that is bad, and specific tips for improving it. Here are some attem...
I don't know any SQL at all, so credits go to the top answer of Mysql - How to quit/exit from stored procedure on StackOverflow. You can simply wrap the code in a label and LEAVE the label, ex. CR...
I have recently posted this question on Web Application SE and I am wondering if such a question would be on-topic here. The questions deals with understanding a feature of Google Chrome Developer ...
Currently, we have a CRUD plus reporting application that talks to one MySQL database. Intermittently users will report locks when searching, currently, I can only get the approximate time of when ...
I am training the following model using Keras as shown: model = tf.keras.models.Sequential([tf.keras.layers.Conv2D(64, (3,3), activation='relu', input_shape=(256, 256, 3)), tf.keras.layers.MaxPooli...
I nominate Lundin, who is very active on main and meta, has proposed some initiatives on meta, and is well-positioned to help us firm up sometimes-fuzzy scope and help this young community grow.
I'll throw my hat in. I don't post much, but I do keep up with the site every day. I try to model a style of leadership that emphasizes consensus building, compromise, and "the third way." That's h...
Regarding length, the correct answer used 43 characters, but one was a space serving no purpose, so say 42 for: =CONCATENATE(LOWER(MID(A1,1,1)),LOWER(B1)) Most obviously, the concatenating functi...
In this Q a user asked for a simple way to represent this data: - PERSON 1 | PERSON 2 | YES - PERSON 1 | PERSON 3 | YES - PERSON 2 | PERSON 1 | YES - PERSON 2 | PERSON 3 | YES - PERSON 3 | PER...
This seems to be looking at the outcome of a bracket in which successive players show an outcome. The table can be easily created by looking at each combination of players and listing them in the t...
For the git branch parameter, set Branch Filter to: origin/(.*) I found the parentheses to be counter-intuitive, because if you don't specify a filter you get: .* (No parens.) If you are filteri...
I'm using Jenkins with a branch parameter to specify the branch to build from. Other stuff downstream needs the branch name to not have the leading "origin/" -- just "feature/blahblah" or "bugfix/1...
