Notifications
Mark all as read
Categories Users Search
Help
Q&A Code Reviews Meta
Q&A
Posts Tags
Ask Question

General Q&A about programming, scripting, software design & architecture, process, tools, testing, and more.

147 posts · Subscribe
Activity Age Score Lottery
66%
+2 −0
How much memory is allocated for a MySQL VARCHAR variable in a stored procedure?

2 answers  ·  last activity 5 days ago by Alexei‭

mysql stored-procedures
60%
+1 −0
A function to round negative numbers towards 0

1 answer  ·  last activity 26 days ago by Alexei‭

google-sheets rounding google-sheets-formula
77%
+5 −0
Pros and cons of vaious type_traits idoms

0 answers  ·  last activity 25 days ago by dmckee‭

c++ template-metaprogramming sfinae
57%
+2 −1
Combine the first character of a cell with another cell

1 answer  ·  last activity 26 days ago by Alexei‭

excel google-sheets text excel-formula
60%
+1 −0
Permutations of an array - APL

1 answer  ·  last activity 20 days ago by Alexei‭

APL array permutations shuffle dyalog
66%
+2 −0
Having trouble adding include directories

1 answer  ·  last activity about 2 months ago by Hyperlynx‭

c++ cmake
66%
+2 −0
In PHP what is the use case for include instead of require when including PHP scripts?

1 answer  ·  last activity 13 days ago by Marijn‭

php
28%
+0 −3
Controlling format when importing CSV [closed]

1 answer  ·  last activity 16 days ago by Lundin‭

libreoffice-calc csv import file-format
75%
+4 −0
Static and thread_local initialization order

1 answer  ·  last activity 7 days ago by Alexei‭

c++ static thread-local
60%
+1 −0
Create encrypted zip archive with bsdtar [closed]

0 answers  ·  last activity 27 days ago by Lundin‭

zip bsdtar
33%
+0 −2
Merge any two rows that have the same ID value

1 answer  ·  last activity about 1 month ago by pnuts‭

google-sheets merge
42%
+1 −2
How to add to the value of one cell an amount that depends upon the range of a different cell?

1 answer  ·  last activity 26 days ago by Alexei‭

formula google-sheets google-sheets-formula
60%
+1 −0
What is happening under the hood to the selected data in a MySQL cursor?

0 answers  ·  last activity 2 months ago by Charlie Brumbaugh‭

mysql
33%
+0 −2
What formula would fetch the content of Cell B12 unless either that is blank or a space, in which case `0` should be returned instead?

1 answer  ·  last activity 26 days ago by Alexei‭

excel excel-formula
60%
+1 −0
How can I can I reduce the size of a SQL Server database after being restored and massive embedded files stripped?

1 answer  ·  last activity 21 days ago by Alexei‭

sql-server sql-server-2017
40%
+0 −1
Add difference rows for data in sets

1 answer  ·  last activity 26 days ago by Alexei‭

excel subtotal excel-formula
66%
+2 −0
pod 0.1.0-dev not accepted for required version 0.1.0 (without -dev suffix)

0 answers  ·  last activity about 1 month ago by Someone‭

cocoapods ios flutter semver
75%
+4 −0
Are generic enums completely abstract?

1 answer  ·  last activity about 2 months ago by Derek Elkins‭

rust enum
70%
+5 −1
Which abstraction should I choose for background services and why?

1 answer  ·  last activity about 1 month ago by Alexei‭

c# software-practices async-await .net
33%
+0 −2
Delete specific cells with shift cells up

1 answer  ·  last activity about 1 month ago by pnuts‭

excel delete
50%
+0 −0
How do World Wide Web interactions happen in a general level? [closed]

0 answers  ·  last activity about 1 month ago by Alexei‭

web
77%
+5 −0
How do I customize merge behavior for a shared git repo?

0 answers  ·  last activity 3 months ago by Alexei‭

git git-merge
83%
+8 −0
Does using an Integer have any speed/performance benefits over a string in JSON

3 answers  ·  last activity 3 months ago by .                                                .‭

string integer json optimization
17%
+1 −12
What is the worst code you ever saw? [closed]

1 answer  ·  last activity 2 months ago by Mithical‭

software-practices
66%
+2 −0
How to perform LINQ joins with multiple fields in a single join?

1 answer  ·  last activity 2 months ago by Alexei‭

c# linq join
80%
+6 −0
How to store credentials for PHP scripts on a Windows machine?

1 answer  ·  last activity 3 months ago by Charlie Brumbaugh‭

php windows
70%
+5 −1
What do the number entries mean in the sympy poly.diff(...) tuple syntax?

2 answers  ·  last activity about 2 months ago by Derek Elkins‭

python sympy
50%
+4 −4
Is concatenation a logical AND?

3 answers  ·  last activity 2 months ago by JohnDoea‭

terminology concatenation string-concatenation
66%
+2 −0
Highlight the maximum value per row across multiple columns

1 answer  ·  last activity 26 days ago by Alexei‭

conditional-formatting openoffice-calc openoffice-calc-formula
66%
+2 −0
Why would an unique index get moved to the primary key after the underlying column is dropped?

1 answer  ·  last activity 16 days ago by Alexei‭

mysql database-index
77%
+5 −0
Search tree supporting efficient bulk sequential insert

0 answers  ·  last activity about 2 months ago by r~~‭

data-structures algorithms search-trees
40%
+0 −1
In a pivot table display date, time and value for each maximum daily value

1 answer  ·  last activity about 1 month ago by pnuts‭

libreoffice-calc pivot
60%
+1 −0
Automatic adjustment when copying of column reference within INDIRECT function

1 answer  ·  last activity about 1 month ago by pnuts‭

google-sheets
80%
+6 −0
Is MISRA-C useful outside safety-critical and embedded programming?

1 answer  ·  last activity 9 days ago by ghost-in-the-zsh‭

c misra-c
50%
+0 −0
TRUE/FALSE flags for alternating colouring by group

1 answer  ·  last activity 26 days ago by Alexei‭

openoffice-calc openoffice-calc-formula
66%
+2 −0
Is an ORDER BY required when looping through MySQL records with LIMIT?

1 answer  ·  last activity about 1 month ago by Canina‭

mysql
40%
+0 −1
Querying date time values for date only in Google Sheets

1 answer  ·  last activity 26 days ago by Alexei‭

formula google-sheets google-query-language google-sheets-formula timestamp
71%
+3 −0
Handling JSON files in Rust without manually creating mapping classes

1 answer  ·  last activity about 1 month ago by r~~‭

rust json
60%
+1 −0
Trigger Conditional Formatting by Check Box

1 answer  ·  last activity about 1 month ago by pnuts‭

conditional-formatting openoffice-calc checkbox
60%
+1 −0
How to automatically run Entity Framework Core migrations for an application which uses a user with read/write rights on certain tables?

1 answer  ·  last activity 9 days ago by Alexei‭

security entity-framework-core entity-framework-migrations
81%
+11 −1
Why would excluding records by creating a temporary table of their primary keys be faster than simply excluding by value?

2 answers  ·  last activity about 1 month ago by Alexei‭

mysql sql notin query-performance
57%
+2 −1
What is do { } while(0) in macros and should we use it?

1 answer  ·  last activity about 4 hours ago by Moshi‭

c code-style macros
40%
+0 −1
LibreOffice Calc formula returns Err:539

1 answer  ·  last activity about 1 month ago by pnuts‭

libreoffice-calc array-formula separators
57%
+2 −1
How can I reduce the size of .svn folder?

1 answer  ·  last activity 2 months ago by r~~‭

svn size
75%
+4 −0
Multiple string concatenation in Excel

2 answers  ·  last activity about 1 month ago by Alexei‭

excel string string-concatenation
50%
+0 −0
Iterative references in LibreOffice Calc

1 answer  ·  last activity 26 days ago by Alexei‭

libreoffice-calc iteration libreoffice-calc-formula
71%
+3 −0
Implementing impersonation in an ASP.NET Core Web application

0 answers  ·  last activity about 2 months ago by Alexei‭

asp.net-core impersonation
50%
+0 −0
Merge a pair of columns where in each row one is blank, without a formula

1 answer  ·  last activity about 1 month ago by pnuts‭

excel merge
85%
+10 −0
Different behavior with relative imports when using flask vs py

1 answer  ·  last activity 4 months ago by ajv‭

python flask relative-imports
75%
+4 −0
Is it possible in MySQL to require each row in a table have at least one foreign key record in a join table?

2 answers  ·  last activity 16 days ago by Alexei‭

mysql referential
Category RSS feed
Featured
Introducing the Codidact Foundation
UPDATE: Abilities update coming Soon™; downtime expected
Hot Posts
Q&A — Should a salt be stored in the same database as the hash?
Meta — Add link dialog should capture enter
Q&A — How much memory is allocated for a MySQL VARCHAR variable in a stored procedure?
Q&A — Search paths where all nodes are in a relationship with same node
Q&A — Jenkins failed to delete a file - why? How to prevent?

This community is part of the Codidact network. We have other communities too — take a look!

You can also join us in chat!

Want to advertise this community? Use our templates!