-
Replied To a Post in Bulk Data Inserts - From File or Memory
No RDBMS or ETL app has a magic bullet. Getting data in is the big challenge. Some RDBMS have bulk input for CSV or the like. One pitfall is that … -
Gave Reputation to cored0mp in Bulk Data Inserts - From File or Memory
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 … -
Gave Reputation to verrandhack in Help with functions - basics
So im working on functions for the first time in vscode using c++. i'm want to declare functions and having trouble understanding some things. i'm very new to programming so … -
Gave Reputation to FarrisFahad in How can I make my website easier to use?
I have a memes site that users can earn from. I want to make the website easier to use and more fun. What should I do to make the website … -
Replied To a Post in Insertion in Binomial Heap in C
I optimized a Binomial min heap in c++, great for low costs when you discard the heap not empty because you have your spanning tree or shortest route. I changed … -
Replied To a Post in unique c characters
C is pretty married to ASCII but that leaves 128 more characters 128-255. ISO8859-1 assigns them to support Nordic/Germanic languages, often called LATIN-1. Even in the old days of 6 … -
Replied To a Post in SQL Query Optimization: Combining Multiple Joins for Improved Performance
Generally any column named id is an artificial, auto-incremented, indexed key. Are your id's also primary keys, and so indexed? If a btree index, maybe make a hash index? A … -
Replied To a Post in Display the given SSNs from a text file in ascending order (C++)
Assuming the file is utterly consistent (3 line sets, ssn w/o dashes in the second line), you can toss a line, read a line as a string or int, toss … -
Replied To a Post in Are we able to start coding without a computer?
I write all my code in my brain as pseudo code, and later encode it in the language of the moment. Sometime I use paper in the middle. I have … -
Replied To a Post in CONVERTING PHYTON TO JAVA
Assuming there is no magic free direct conversion tool, convert the python to pseudo code and then to JAVA. This will test your knowledge of when python does nice things … -
Replied To a Post in Which transactions are deadlocked?
It depends on locks already held. Deadlock is p1 gets a and wants b bu about the same time p2 gets b and wants a. If all threads always lock … -
Replied To a Post in control reaches end of non-void function [-Wreturn-type]
I usually go with another int set to -max (0x80000000) when seeking a max, so the first is generally greater and replaces it. Using <= means equal values get copied, … -
Replied To a Post in Delete files matching pattern
The newer 'find' has a batch execution mode, but I find it easier to use 'xargs'. I usually do 'xargs -n101 ...' to both prevent execution with no arguments and … -
Replied To a Post in can u help this
Once you have the average, you need another loop that reviews the input against it and prints the desired items. -
Replied To a Post in syntax error in update statement
No comma before where in SQL. -
Replied To a Post in Char[][] for value list
Or better yet, make it an array of char*, since a double quoted literal value is a char pointer to a constant on the heap. -
Replied To a Post in please help me.. in this one 199202
Not seeing a lot of morphine, just a loop, a few ints, some io! -
Replied To a Post in Please help. There is a Syntax error in line 17 and I don´t know why. :c
identical switch within switch is just wrong, and printing inside swtch ouside any case is not at all nice. -
Replied To a Post in "Syntax Error in INSERT INTO statement" error in VB.Net Programming while Adding a Record in Access Database
More values than columns! -
Replied To a Post in Copy paste link should get redirected to home page.
Generally, when you go to a web site without a valid timed login cookie, the server redirects you to the login page, possibly with a cookie or variable saying where … -
Replied To a Post in converting C++ program to C program
You need to track both the number of cells used (top for a stack) and the capacity (max cells allocated) so you know when to expand the container (stack). Evict … -
Replied To a Post in converting C++ program to C program
Since auto resizing arrays are not there in c, not classes, you might want to use a linked list or realloc() a char[] to size. -
Replied To a Post in how to change source coding to OOP C ++ Using I / O fstream
If you open an output ofstream and use it not cout, the data is saved in a file. -
Replied To a Post in Testing RAM Sticks
If stick 3 runs the machine OK alone, then incompatibility is a strong possibility. However, there is usually one way things can work and an infinite number of ways they … -
Replied To a Post in JavaScript Object Comparison
Somehow, the last time i added an equals() to a JAVA List (not Set, as Set does not support lookup like List and Map), it got ignored. I wrote my … -
Replied To a Post in Read and write files in C++. Not allowing user input
EOF check between read and write, use get() to pick up white space characters, getline() removes the lew line. dgp@dgp-p6803w:~ $ myCC c++rw dgp@dgp-p6803w:~ $ c++rw Type in file name … -
Replied To a Post in JavaScript Object Comparison
Lots of references on the dangers and costs of various equalities. This one seems very nice: https://www.mattzeunert.com/2016/01/28/javascript-deep-equal.html -
Replied To a Post in Read and write files in C++. Not allowing user input
Just like scanf() and the JAVA Scanner Class, when you >> the next string, int, double, char, etc., then it reads, initially skipping over white space, into the variable from … -
Gave Reputation to JamesCherrill in JavaScript Object Comparison
> == is a shallow comparison Some spectacular Java nonsense here. The == operator cannot be overloaded and checks for referential identity. If two variables contain the same reference then … -
Replied To a Post in my browser title is not working
I have had good luck with: "<HTML><HEAD><TITLE>My Title</TITLE>...</HEAD><BODY>...</BODY></HTML>" -
Replied To a Post in How do I integrate a db into this html table?
Wow, I just write a service that runs the query and reformats the column titles and values into an HTML table. If I wanted it to be more spreadsheet-like, there … -
Replied To a Post in HOW to use math in MS ACCESS? (Project PHOTO)
In a database, you can just keep the count of every part, and as the users take or return stock, the count changes. If you want to know about the … -
Replied To a Post in Write data to excel in multiple sheets using c#
The easiest thing is to write CSV files, which follow 4 simple rules: 1) cells are separated by a comma, 2) rows are separated by a cr-lf, 3) unless the … -
Replied To a Post in print out number in ascending order in c++ WITHOUT USING ARRAY AND FUNCTION
Wow, can of 'sorts'. You need some sort of container, and there are others besides array: linked list, tree, hash table, skip list. Tree sorts as it adds, and even … -
Replied To a Post in JavaScript Object Comparison
== is a shallow comparison, like shallow copy, true only if the refrences are identical, not the objects. http://adripofjavascript.com/blog/drips/object-equality-in-javascript.html JAVA and C++ also have this sort of limitation unless you … -
Replied To a Post in Can you get a software job right out of college without an internship?
There is consulting, where they run interference for you, freelance work, volunteer work, teaching, tutoring and open source collaboration to get your status up and your skills sharp. -
Replied To a Post in Database Forms and logins
Google sheets keeps track of all changes and who entered them, and allows multiple user concurrent access. An RDBMS app needs to know who is logged in to make changes, … -
Replied To a Post in Can someone help me with this?
Hash tables are containers. Hashing creates an integer from other types, usually the characters of a key, where it represents the values and positions of those characters. One divides the … -
Replied To a Post in How to return parameters from different table rows
The join table to itself tactic is very good for converting rows to columns. There are other tricks you can use with aggregates and case statements. -
Replied To a Post in Resizing images without loss of quality
The major methods for image reduction in size are compression, like in jpeg, and resampling. Resampling may take something like a weighted average, which can make things muddy, or select … -
Replied To a Post in Router have many ip's referenced to it. How to differenciate per usage?
DHCP operates a pool of IPs for clients that need them. Usage is a bit worthless unless they stay assigned a long time. As noted, the mac from the ethernet … -
Replied To a Post in Information about GUI in C++. Do people use C++ for GUI applications????
The Securities/Stock trading crowd like c++ for the speed, and XWindows was there long before most others. -
Replied To a Post in C++ Assignment, Hollow Diamond & Average of Positive Integers
How do you teach those who fall off the official wagon? -
Replied To a Post in C++ Assignment, Hollow Diamond & Average of Positive Integers
The hollow diamond is about distance from center column and distance from center row; their sum s/b half the height to print. In this case, 3. So: for ( int … -
Replied To a Post in reading and printing array using functions
Maybe put the array and indexes in parens after the & ? Debug messages on stderr , which, unlike stdout, is unbuffered! -
Replied To a Post in Reading columns from a text/csv file
There are just 4 rules to parsing a CSV: Commas separate fields Carriage return linefeed separates rows Unless inside “ But “” is a literal “ -
Replied To a Post in Why this code is not working for a palindrome number
A palindrome check should be a loop through the first half of the string or 1/2 less checking the mirror byte for a match. To make it a number check, … -
Replied To a Post in convert from dbf (foxpro) database to mysql database
JDBC tools like SQuirreL and jisql let you extract schema and data. I like to use LINUX sed to pipe a select into an insert, no intermediate files. -
Replied To a Post in C++ Parallel arrays
To read a file, you need to declare an ifstream, open it, read from it using using >> into the appropriate types and check for eof(), bad(), fail() to detect … -
Replied To a Post in If-else showing weird results
Comparing null terminated char arrays is: #include <string.h> int strcmp(const char *s1, const char *s2); but for known length unterminated strings: #include <string.h> int memcmp(const void *s1, const void *s2, …
The End.