Naming conventions? We don't need no stinkin' naming conventions (or any convention or even common sense for that matter)!
-
Had to write some query on a SQL Server database today. Opening the database took close to a minute. What I saw then will forever haunt me. Table names like [01 Some Company & Partner l.l.c.$Customer Ledger item], but also [01 Some Company & Partner llc$Cust something else], because sometimes you need Customer while other times you simply need Cust. Each table had columns with names like [Entry No_], [Customer report code 1] and [Amount (CNY)] (CNY apparently means "currency", but with column names like that why even bother to abbreviate?) :sigh: So we've got names with spaces, dots, numbers and symbols, complex enough to pass a password complexity validation! Now there's something particularly odd about the table name... The part before the $ is actually a company name and it turned out this database has the same tables for 23(!) companies, and some other (un?)related tables, giving the database a staggering 41,000+ tables! :wtf: So let me say this again so you can be sure you read it right and I spelled it correctly... OVER FORTY-ONE THOUSAND TABLES! :wtf: It was a bit over 1700 tables per company, which I already think is A LOT, combined in a single database. SQL Server allows for int.MaxValue objects in a single database and I have a feeling this application was pushing the limit (if not, not for lack of trying) :laugh: I'm assuming most of it is generated, but even then, WHY WOULD YOU GENERATE SUCH !G($#&#$(!#F:elephant:J!#(P!? :mad: Sometimes you think you've seen it all and then you run into something like this and realize there really is no limit to human stupidity :sigh:
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
The part before the $ is actually a company name and it turned out this database has the same tables for 23(!) companies, and some other (un?)related tables, giving the database a staggering 41,000+ tables!
Probably not intended, but this sounds like a great way to be GPDR compliant - each table can have different access controls so that someone who is allowed to view the data for $COMPANY_A will never be allowed to view the data for $COMPANY_B. Unintended consequences, and all that...
-
And I'll bet some company tables are unique so combining them will be a challenge. I made a tidy living in the 90's attempting to normalise such horrors, never quite that big and ugly though. I wonder if the original was converted from MS Access, it is definitely an end user built database. So quote a rate and don't offer a time frame (or even a guarantee) if you are going to try and clean it up. PS CNY is definitely the Chinese currency.
Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP
Mycroft Holmes wrote:
And I'll bet some company tables are unique so combining them will be a challenge.
No doubt, luckily there's no need to combine them :D Hopefully I'll never see this database again :laugh:
Mycroft Holmes wrote:
it is definitely an end user built database
Don't think so, end users here are typically as a-technical as they come. I think a lot of it was generated though. The database is owned by another supplier and kept around for historical purposes, I don't think it's actively being used anymore.
Mycroft Holmes wrote:
PS CNY is definitely the Chinese currency.
Nope, it's short for CurreNcY :laugh: The amount in the column is usually the same as that in the regular amount column, except when the customer is not a Euro country. This supplier doesn't do anything with China specifically.
Mycroft Holmes wrote:
So quote a rate and don't offer a time frame (or even a guarantee) if you are going to try and clean it up.
Already did that years ago for another project, and both my customer and I are still reaping the benefits ;)
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
-
Never used SQL but :laugh: Could CNY be Chinese Yuan? It's the standard forex abbreviation for it.
Robust Services Core | Software Techniques for Lemmings | Articles
The fox knows many things, but the hedgehog knows one big thing.Greg Utas wrote:
Could CNY be Chinese Yuan?
Nope, it's actually short for CurreNcY. Makes perfect sense if you designed that database I guess :~
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
-
No challenges here. Another company owns the database, someone else sometimes works with it. That someone else asked me if I could do him a favor and write that query. Other than that the database is not used anymore and kept around for historical data. I've got other (fun) challenges coming my way :D
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
Ha damn... You still sound like the man of the hour, nay, the man of the year! :D
A new .NET Serializer All in one Menu-Ribbon Bar Taking over the world since 1371!
-
I'm afraid I have been there, just not with so many tables (maybe 20) nor companies (only 3), and using MySQL. I just made a "SQL template" script and separated the companies into separate databases. Any common change would be made to the template and would be inherited by all (when the script was run against each of the databases). But I guess they have to justify buying new hardware when their queries are not fast enough. Hey, at least those have their queries in the database, right? Right?! In my case they were doing all queries (even simple ones like "select * from tableA where userID=x") in a weird PHP backend because they claimed that "the database is not good enough to filter the tables the way we want it" :wtf: Anyway, I think some whipping is in order. Grab your whip and get the guy that wrote that database. Don't let him procreate more databases like that :mad: :-D
ElectronProgrammer wrote:
the guy that wrote that database
If it was indeed created by a human and not dynamically created by some program :laugh: Anyway, the person responsible is probably a supplier of a supplier of my customer somewhere in the 80's, but I can't say for sure :laugh:
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
-
I apologize. I was in a mood when I generated that. :laugh:
Real programmers use butterflies
I must admit I thought of you, but more along the lines of "if honey generated this, it would at least look a lot better X|" And also "she probably already wrote something that could generate exactly this." :D
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
-
Clearly, I'm going to die working. When I read stuff like this, the inmates are running the asylum.
Charlie Gilley <italic>Stuck in a dysfunctional matrix from which I must escape... "Where liberty dwells, there is my country." B. Franklin, 1783 “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
It's always been the inmates! :laugh:
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
-
Ha damn... You still sound like the man of the hour, nay, the man of the year! :D
A new .NET Serializer All in one Menu-Ribbon Bar Taking over the world since 1371!
I am! I solve their problems, better, faster and cheaper than any other supplier they have! :omg:
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
-
The part before the $ is actually a company name and it turned out this database has the same tables for 23(!) companies, and some other (un?)related tables, giving the database a staggering 41,000+ tables!
Probably not intended, but this sounds like a great way to be GPDR compliant - each table can have different access controls so that someone who is allowed to view the data for $COMPANY_A will never be allowed to view the data for $COMPANY_B. Unintended consequences, and all that...
Yeah, it's probably to keep one company out of the other's data, but giving them separate databases may have been a better option... Also, I'm not sure if GDPR applies to businesses (it's all B2B) ;)
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
-
Be thankful... it could have been access... or even better, excel tables :laugh: :laugh:
M.D.V. ;) If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about? Help me to understand what I'm saying, and I'll explain it better to you Rating helpful answers is nice, but saying thanks can be even nicer.
Nelek wrote:
or even better, excel tables
That's my next project :omg:
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
-
Had to write some query on a SQL Server database today. Opening the database took close to a minute. What I saw then will forever haunt me. Table names like [01 Some Company & Partner l.l.c.$Customer Ledger item], but also [01 Some Company & Partner llc$Cust something else], because sometimes you need Customer while other times you simply need Cust. Each table had columns with names like [Entry No_], [Customer report code 1] and [Amount (CNY)] (CNY apparently means "currency", but with column names like that why even bother to abbreviate?) :sigh: So we've got names with spaces, dots, numbers and symbols, complex enough to pass a password complexity validation! Now there's something particularly odd about the table name... The part before the $ is actually a company name and it turned out this database has the same tables for 23(!) companies, and some other (un?)related tables, giving the database a staggering 41,000+ tables! :wtf: So let me say this again so you can be sure you read it right and I spelled it correctly... OVER FORTY-ONE THOUSAND TABLES! :wtf: It was a bit over 1700 tables per company, which I already think is A LOT, combined in a single database. SQL Server allows for int.MaxValue objects in a single database and I have a feeling this application was pushing the limit (if not, not for lack of trying) :laugh: I'm assuming most of it is generated, but even then, WHY WOULD YOU GENERATE SUCH !G($#&#$(!#F:elephant:J!#(P!? :mad: Sometimes you think you've seen it all and then you run into something like this and realize there really is no limit to human stupidity :sigh:
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
Well, it seemed like a good idea at the time. :)
If you can keep your head while those about you are losing theirs, perhaps you don't understand the situation.
-
Had to write some query on a SQL Server database today. Opening the database took close to a minute. What I saw then will forever haunt me. Table names like [01 Some Company & Partner l.l.c.$Customer Ledger item], but also [01 Some Company & Partner llc$Cust something else], because sometimes you need Customer while other times you simply need Cust. Each table had columns with names like [Entry No_], [Customer report code 1] and [Amount (CNY)] (CNY apparently means "currency", but with column names like that why even bother to abbreviate?) :sigh: So we've got names with spaces, dots, numbers and symbols, complex enough to pass a password complexity validation! Now there's something particularly odd about the table name... The part before the $ is actually a company name and it turned out this database has the same tables for 23(!) companies, and some other (un?)related tables, giving the database a staggering 41,000+ tables! :wtf: So let me say this again so you can be sure you read it right and I spelled it correctly... OVER FORTY-ONE THOUSAND TABLES! :wtf: It was a bit over 1700 tables per company, which I already think is A LOT, combined in a single database. SQL Server allows for int.MaxValue objects in a single database and I have a feeling this application was pushing the limit (if not, not for lack of trying) :laugh: I'm assuming most of it is generated, but even then, WHY WOULD YOU GENERATE SUCH !G($#&#$(!#F:elephant:J!#(P!? :mad: Sometimes you think you've seen it all and then you run into something like this and realize there really is no limit to human stupidity :sigh:
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
Because the unsupervised junior devs thought multi-tenant tables were too much work for the prototype, and when it needed to scale out management balked at paying for one database/customer or a major refactor of the tables to do multi-tenant the sane way so the juniors -still without any meaningful supervision - came up with a WTF pattern.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius
-
Greg Utas wrote:
Could CNY be Chinese Yuan?
Nope, it's actually short for CurreNcY. Makes perfect sense if you designed that database I guess :~
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
Death to abbreviations. Just die! Also, fix your elephanting spelling errors.
Charlie Gilley <italic>Stuck in a dysfunctional matrix from which I must escape... "Where liberty dwells, there is my country." B. Franklin, 1783 “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
-
Had to write some query on a SQL Server database today. Opening the database took close to a minute. What I saw then will forever haunt me. Table names like [01 Some Company & Partner l.l.c.$Customer Ledger item], but also [01 Some Company & Partner llc$Cust something else], because sometimes you need Customer while other times you simply need Cust. Each table had columns with names like [Entry No_], [Customer report code 1] and [Amount (CNY)] (CNY apparently means "currency", but with column names like that why even bother to abbreviate?) :sigh: So we've got names with spaces, dots, numbers and symbols, complex enough to pass a password complexity validation! Now there's something particularly odd about the table name... The part before the $ is actually a company name and it turned out this database has the same tables for 23(!) companies, and some other (un?)related tables, giving the database a staggering 41,000+ tables! :wtf: So let me say this again so you can be sure you read it right and I spelled it correctly... OVER FORTY-ONE THOUSAND TABLES! :wtf: It was a bit over 1700 tables per company, which I already think is A LOT, combined in a single database. SQL Server allows for int.MaxValue objects in a single database and I have a feeling this application was pushing the limit (if not, not for lack of trying) :laugh: I'm assuming most of it is generated, but even then, WHY WOULD YOU GENERATE SUCH !G($#&#$(!#F:elephant:J!#(P!? :mad: Sometimes you think you've seen it all and then you run into something like this and realize there really is no limit to human stupidity :sigh:
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
Sander Rossel wrote:
a staggering 41,000+ tables
Why go deep, when you can go wide? If each company has its own set of tables dedicated to it, think of how much faster queries are gonna run than if all the data for all companies was combined... I'm sure that was the line of reasoning...
-
Had to write some query on a SQL Server database today. Opening the database took close to a minute. What I saw then will forever haunt me. Table names like [01 Some Company & Partner l.l.c.$Customer Ledger item], but also [01 Some Company & Partner llc$Cust something else], because sometimes you need Customer while other times you simply need Cust. Each table had columns with names like [Entry No_], [Customer report code 1] and [Amount (CNY)] (CNY apparently means "currency", but with column names like that why even bother to abbreviate?) :sigh: So we've got names with spaces, dots, numbers and symbols, complex enough to pass a password complexity validation! Now there's something particularly odd about the table name... The part before the $ is actually a company name and it turned out this database has the same tables for 23(!) companies, and some other (un?)related tables, giving the database a staggering 41,000+ tables! :wtf: So let me say this again so you can be sure you read it right and I spelled it correctly... OVER FORTY-ONE THOUSAND TABLES! :wtf: It was a bit over 1700 tables per company, which I already think is A LOT, combined in a single database. SQL Server allows for int.MaxValue objects in a single database and I have a feeling this application was pushing the limit (if not, not for lack of trying) :laugh: I'm assuming most of it is generated, but even then, WHY WOULD YOU GENERATE SUCH !G($#&#$(!#F:elephant:J!#(P!? :mad: Sometimes you think you've seen it all and then you run into something like this and realize there really is no limit to human stupidity :sigh:
Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript
Though attributed to Albert Einstein, there is no evidence that he actually said the following... The difference between genius and stupidity is that genius has its limits... :laugh:
Steve Naidamast Sr. Software Engineer Black Falcon Software, Inc. blackfalconsoftware@outlook.com
-
Clearly, I'm going to die working. When I read stuff like this, the inmates are running the asylum.
Charlie Gilley <italic>Stuck in a dysfunctional matrix from which I must escape... "Where liberty dwells, there is my country." B. Franklin, 1783 “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
I have that book the inmates are running the asylum it's an interesting read, especially 22 years after it was written. things haven't changed much.
