kSPvhmTOlwvMd7Y7E 14 hours ago • 100%
I don't understand why this is called a "subset", while clearly containing new syntax
A subset would be understood by older compilers, this is a superset
kSPvhmTOlwvMd7Y7E 2 days ago • 80%
Absolutely not a replacement to VBA. Not even close. As usual, Microsoft hypes something everyone wants, and then implements something nobody asked
kSPvhmTOlwvMd7Y7E 2 days ago • 100%
I feel offended by you somehow equalizing perl and lisp
kSPvhmTOlwvMd7Y7E 2 days ago • 100%
This a much better done meme
The other one before makes zero sense
kSPvhmTOlwvMd7Y7E 2 weeks ago • 25%
2100 parameters is a documented ODBC limitation( which applies on all statements in a batch)
This means that a
"insert into (c1, c2) values (?,?), (?,?)..." can only have 2100 bound parameters, and has nothing to do with code, and even less that surrounding code is "spaghetti"
The tables ARE normalised, the fact that there are 50 colums is because underlying market - data calibration functions expects dozens of parameters, and returns back dozens of other results, such as volatility, implied durations, forward duration and more
The amount of immaturity, inexperience, and ignorance coming from 2 people here is astounding
Blocked
kSPvhmTOlwvMd7Y7E 2 weeks ago • 10%
You should take a break from trolling
kSPvhmTOlwvMd7Y7E 2 weeks ago • 100%
I timed the transaction and opening of the connection, it takes maybe a 100 milliseconds, absolutely doesn't explain ghe abysmal performance
Transaction is needed because 2 tables are touched, i don't want to deal with partially inserted data
Cannot share the code, but it's python calling .NET through "clr", and using SqlBulkCopy
What do you suggest i shouldn't be using that? It's either a prepared query, with thousands of parameters, or a plain text string with parameters inside (which admittedly, i didn't try, might be faster lol)
kSPvhmTOlwvMd7Y7E 2 weeks ago • 50%
Will try bcp & report back EDIT: I can't install bcp because it is only distributed with SQLServer itself, and I cannot install it on my corporate laptop.
kSPvhmTOlwvMd7Y7E 2 weeks ago • 33%
I will try bcp. Somehow, i was convinced I had to have access to the machine running the sql server to use it, but from the doca i see i can specify a remote host.. Will report back! EDIT: I can't install bcp because it is only distributed with SQLServer itself, and I cannot install it on my corporate laptop.
kSPvhmTOlwvMd7Y7E 2 weeks ago • 33%
Please enlighten us? You barely know anything about the system or usage, and you have deduced nosql is better? Lol
kSPvhmTOlwvMd7Y7E 2 weeks ago • 33%
I am using SqlBulkInsert, given how bad MS is with naming things, that might as well be row inserts instead of bulks
kSPvhmTOlwvMd7Y7E 2 weeks ago • 70%
Oh buddy, enjoy your life & don't touch Microsoft even with a 10 meters stick
Omg it's sooo daammmn slooow it takes around 30 seconds to bulk - insert 15000 rows Disabling indices doesn't help. Database log is at SIMPLE. My table is 50 columns wide, and from what i understand the main reason is the stupid limit of 2100 parameters in query in ODBC driver. I am using the . NET SqlBulkCopy. I only open the connection + transaction once per ~15000 inserts I have 50 millions rows to insert, it takes literally days, please send help, i can fucking write with a pen and paper faster than damned Microsoft driver inserts rows
kSPvhmTOlwvMd7Y7E 2 weeks ago • 95%
I would not recommend using parquet instead of csv. Indeed, parquet is a type of wooden flooring, while csv is a human readable file format. As you can see, it is not wise to replace one with the other. Don't hesitate about asking more questions regarding your home design!
kSPvhmTOlwvMd7Y7E 7 months ago • 100%
I would be lying if I said that I was a professional Ocaml developer.
I do definitely think the Jane's library is very hard to read... But that might be my inexperience
I personally think regular, procedural code is much easier to read ¯_(ツ)_/¯
kSPvhmTOlwvMd7Y7E 7 months ago • 100%
If you want to read some monads in the wild, go check the code for Jane's Street "core_unix.command_unix"
Otherwise, GADT, but they are used sparingly because they make type inference undecidable
kSPvhmTOlwvMd7Y7E 8 months ago • 30%
Sorry to that guy, but Python is a terrible choice for GUI. It simply doesn't even exist in the wild, except in newbies' minds. You should pick something that allows you to* easily & immediately* reload your GUI in progress without restarting the program; AND also maybe think about how to distribute your GUI on other computers without requiring them to duplicate your python setup
kSPvhmTOlwvMd7Y7E 12 months ago • 50%
Meh. He s wrong and he knows it. Computer science is definitely about efficient use of computational resources and memory.
kSPvhmTOlwvMd7Y7E 12 months ago • 71%
React +python + postgres/sqlite
kSPvhmTOlwvMd7Y7E 12 months ago • 100%
We have a solution
kSPvhmTOlwvMd7Y7E 1 year ago • 100%
Did they pay every news outlet out there to publish stupid titles? That's not a fucking apology. Stop pretending
kSPvhmTOlwvMd7Y7E 1 year ago • 100%
Your last question is equivalent to : why there so many math theories? Can't we just reuse the old ones?
New language appear as a natural product from research in type theory for ex
kSPvhmTOlwvMd7Y7E 1 year ago • 100%
Even something as ubiquitous as JSON is not handled in the same way in different databases, same goes for Dates, and UUID. I am not even mentioning migrations scripts. As soon as you start writing raw SQL, I pretty sure you will hit a compatibility issue.
I was specifically talking about python, can't argue with golang. OK you have a valid point for performance, gotta keep an eye on that. However, I am satisfied for our CRUD api
kSPvhmTOlwvMd7Y7E 1 year ago • 100%
and how you run your tests? Do you spawn a DB backend for test purposes?
kSPvhmTOlwvMd7Y7E 1 year ago • 94%
You don't even mention the 2 main advantages:
- ORM lets you to use plain objects over untyped strings. I take typed anything over untyped anything, everyday
- ORM lets you to use multiple database backends. For ex, you don't need to spawn a local postgres server, then clean/migrate it after each test suit, you can just use in-memory sqlite for that. OK this has some gotchas, but that's a massive improvement in productivity
kSPvhmTOlwvMd7Y7E 1 year ago • 100%
Advertisement is a fucking syphilis, a cancer and a gangrene combined. Don't tell me what to watch what to visit
kSPvhmTOlwvMd7Y7E 1 year ago • 66%
Unfortunately sometimes the code base is fuckd up beyond repair, it can't even be tested. that's why i submitted 3000 line PR ☠️
kSPvhmTOlwvMd7Y7E 1 year ago • 100%
All IO related stuff should be a replaceable dependency
But this is very readable tho
kSPvhmTOlwvMd7Y7E 1 year ago • 100%
Aw, of course, go ahead Microsoft's OCaml, we ll definitely visit you
kSPvhmTOlwvMd7Y7E 1 year ago • 100%
It's not "every system" which proves all truth is inconsistent right? Propositional logic, and first order logics are both sound, and complete. The article talks about propositional logic, so in my understanding, it should be complete and sound too.
kSPvhmTOlwvMd7Y7E 1 year ago • 100%
fair enough.
Are you doing data science? Statistics? No? Then for god's sake don't use pandas, you just look dumb af when you pull several MB of a package just to load csv. If you find yourself doing that, just stop programming and look for another job Thanks for attention
kSPvhmTOlwvMd7Y7E 1 year ago • 40%
Why every class creates its own logger? That might make sense, but looks suspicious
Use global imported variables for configs.
kSPvhmTOlwvMd7Y7E 1 year ago • 88%
it's «la torture» tho …