610 karma · joined March 22, 2009
.mode csv
.import filename.csv table_name
On my 2-year old Windows laptop (i7, lenovo x1) importing a 2M rows 1.4GB file takes about ~70 seconds.So not 10 seconds but no need to create an insert statement (I'm sure you can access this functionality from python if you need to)
If you don't need any plugin - then, yes, it's simple.
But once you need specialized plugins it's no better than gradle/bazel. The latter two lets you add some logic in the build scripts - so at least it's visible to users. If you need special functionality in Maven you have to write a plugin or gather a few plugins. And when it breaks down (as all tools do) -- it's difficult to find the code and understand the problems.
A typical workflow would be to look for common errors reported by Sentry, then take a few example cases and examine the logs to understand what went wrong.
So while everyone can implement the standard, very few can do this profitably (In practice, Qualcomm, Mediatek and to some extent Samsung)
This reduces the cognitive load and gives the compiler a way to enforce separation.
In short - files in C can give you namespaces -- which are sometimes a useful way to organize code.
After a process gets automated, people forget the details of how to do the work manually. Now, when the automation breaks (and it will break at some point. It takes a huge amount of work to make these things failsafe and scripting doesn't really encourage robustness) -- no one remembers the details and fixing the issue is more difficult and requires specialized knowledge that is no longer common in the organization.
Where I work we are not on-call. Nevertheless, I try to help the ops team when they encounter issues. This does make you improve logging and error handling since you know it takes a lot more time when it's difficult to filter logs for the interesting events.
Engineers not exposed to production issues and customers will never understand why you need these extra measures.
Microsoft can have dedicated teams for each platform (perhaps Linux is not as important but certainly for Windows, macOS, android and iOS)
Along with an ML training pipeline where you can train the figures in the sim to behave similarly to certain people in the office and a prediction phase where you can ask "what if"-s type of questions :)
The "Quarantine bread" receipt was wonderful last week. This week, for some reason it turns out terrible (dough very sticky, bread burnt on the outside, etc.) No idea what went wrong and what I should have done to fix this.
Yes, the basic controls do not change. But more advanced functionality is easier presented through menus and screens which guide you through a process -- instead of adding tons of switches for every possible function.
So sometimes I give up on my favorite command line tools and switch to "CMD".
But yes, it is possible.
One thing is though - TLS1.3 is getting more popular and so is session resumption. So even now quite a bit of traffic cannot be identified and it will get harder and harder.
Encrypting DNS requests is one required piece of the puzzle.
They can certainly afford to have separate teams doing web, iOS and Android development and optimize for each environment.
Then if you make an error you can always ROLLBACK. If it looks OK -- COMMIT.
Assuming you're on a modern Linux distribution, it's pretty easy creating a systemd service file which will make it easier to manage the service.
If a network DHCP server publishes a local DNS server that is not on the list, DNS traffic will not bt encrypted?
So a network operator wishing to continue spying on its users just needs a local DNS proxy?
I like that approach but couldn't find the "show/edit source button" (using the Sugarizer web based platform)
Perhaps a simplified Smalltalk environment would be better?