Earlier quoted context omitted.
Excel can't open SQLlite files
Yes it can, using the sqlite odbc driver.
Does that work with File > Open with a stock Excel install? Does editing work seamlessly?
Hot Dog Linux – Horrible Obsolete Typeface and Dreadful Onscreen Graphics
151–160 of 167 posts
Re: Hot Dog Linux – Horrible Obsolete Typeface and Dreadful Onscreen Graphics
#152Earlier quoted context omitted.
Switch from the developer world to the business world and everybody has Excel to open the CSV files with the article information, the sales numbers and so on and can work with that. How do you even read data from SQLite to Excel? VBA? Some obscure connector? With CSV it's "import" or even "open file".
Ironically Excels implementation of CSV is terrible. It’s constantly destroying data (eg large numeric and pseudo-numeric fields) not to mention the whole issue around any cell bringing with an equal symbol being converted into a function.
And some localizations of excel uses semi colon instead of comma! So no interoperability.
Re: Hot Dog Linux – Horrible Obsolete Typeface and Dreadful Onscreen Graphics
#153Earlier quoted context omitted.
> You just move the complexity one layer up, at the composition of all those small utilities. Out of curiosity, what would the name of the metric for measuring this tradeoff be? Average lines of code per script/program? Average scripts/programs to accomplish a given task? I feel like it'd be really good to talk more about this tradeoff, e.g. having smart programs that do a lot but are bloated (OpenVPN, OpenSSL, Docke…
Average number of interfaces/solution. If you only have 1 program, you have 1 interface (1 set of command-line arguments, 1 set of environment variables, 1 STDIN, 1 STDOUT). If you have 50 programs, you can have 50 interfaces. So, more interfaces, but.... more interfaces. Composeability requires many different interfaces, but not every solution needs composeability.
Fair point, but doesn't that also kind of muddy the waters because interfaces also being a regular programming construct? E.g. you might have 50 libraries with 50 interfaces that still go in one very large program, no? And in practice that would be very different from chaining 50 different scripts/simple tools together.
Re: Hot Dog Linux – Horrible Obsolete Typeface and Dreadful Onscreen Graphics
#154Earlier quoted context omitted.
We are having at least 2 different discussions here. From a biological perspective, again, we are human beings. I can easily agree with you here, and with any of your arguments in fact. But in real life, skin pigmentation and other differences that have been attributed to the term "race" have an impact on a person's perception, whether or not they admit/realize it. My argument may be misguided or even wrong in any se…
> But in real life, skin pigmentation and other differences that have been attributed to the term "race" have an impact on a person's perception, whether or not they admit/realize it. I think, in the US, skin pigmentation has historically acted as a metonym for the social divide between European-Americans and African-Americans. But, it would be a mistake to take the metonym too literally – and people who are neither…
I grew up in Germany, born elsewhere, without giving too much personal information about myself. I now live in the US. The fact that the US has become more diversified and generally affords individuals more opportunities; community ties are not as strong or important as elsewhere; sprawling geography and population; all of these things create a different set of costs and benefits socially.
When people in other countries get more defensive or sensitive to an influx of foreigners is not an indication that racism doesn't exist or race doesn't play a part at all in how they view others. It is a different side of the same coin. Yet, look at how the plight of a white population in Ukraine is seen vs. that in Syria or Yemen or even Rwanda before that.
Re: Hot Dog Linux – Horrible Obsolete Typeface and Dreadful Onscreen Graphics
#155Earlier quoted context omitted.
An S-expression file with a newline after each top-level expression has the same property. So that's not really a problem.
Clojure's EDN is pretty decent for this. ingy and I came up with p3rl.org/JSONY as a "JSON with less ceremony" compromise that I often find useful (it has a PEG grammar that's a superset of JSON so pretty easy to re-implement elsewhere)
The hyphen prefixed arrays are very weird. It looks like YAML but behaves differently. Doesn’t help that YAML is also a superset of JSON too.
I also don’t like space (char 32) used as a field delimiter because that opens up entire categories of bugs that are already a daily annoyance for shell scripting.
I respect your thought processes but I can see this particular specification being more confusing than productive to most other people.
Re: Hot Dog Linux – Horrible Obsolete Typeface and Dreadful Onscreen Graphics
#156I like most of these better than Ubuntu's defaults.
Re: Hot Dog Linux – Horrible Obsolete Typeface and Dreadful Onscreen Graphics
#157Earlier quoted context omitted.
Yes it can, using the sqlite odbc driver.
Does that work with File > Open with a stock Excel install? Does editing work seamlessly?
No, but that's not why you would move your data to sqlite. I was only responding to the question of whether Excel could read it, which it can.
Re: Hot Dog Linux – Horrible Obsolete Typeface and Dreadful Onscreen Graphics
#158Earlier quoted context omitted.
Clojure's EDN is pretty decent for this. ingy and I came up with p3rl.org/JSONY as a "JSON with less ceremony" compromise that I often find useful (it has a PEG grammar that's a superset of JSON so pretty easy to re-implement elsewhere)
The hyphen prefixed arrays are very weird. It looks like YAML but behaves differently. Doesn’t help that YAML is also a superset of JSON too. I also don’t like space (char 32) used as a field delimiter because that opens up entire categories of bugs that are already a daily annoyance for shell scripting. I respect your thought processes but I can see this particular specification being more confusing than productive…
The hyphen prefixed arrays were an ingyism. I don't use those at all but since he wrote the grammar I didn't feel like it was particularly fair to bitch about him sneaking in a single feature he wanted.
I use it basically like:
{ key1 value1 key2 [ value2a value2b value2c ] }
Plus because JSONY isn't at all indentation sensitive pasting chunks of JSON in becomes IMO a lot easier to comprehend.
A valuable thing for me is that if e.g. I'm writing a daemon that communicates via newline delimited JSON over a TCP or UNIX socket I can have a development mode where it uses JSONY as the parser so it's faster/easier to do quick interactive tests with socat.
Re: Hot Dog Linux – Horrible Obsolete Typeface and Dreadful Onscreen Graphics
#159My company recently issued me a mac for remote work. I'm sorely tempted to load this in a VM so I can "accidentally" share my desktop via zoom and then claim ignorance that this is not in fact MacOS.
Nah. Use the Aqua one, then they can't complain it's not MacOS
Plank could provide a dock and iDesk can do desktop icons. It would probably take less than an hour to get the Aqua theme really close to the real deal.
Re: Hot Dog Linux – Horrible Obsolete Typeface and Dreadful Onscreen Graphics
#160Earlier quoted context omitted.
So, what's the argument here exactly? Many of those countries were created by colonial powers without regard for culture or any other variation among the people. Perhaps I wasn't lucky enough to benefit from the enlightenment that the British Empire has bestowed upon you. On the other hand, is your idea of "different" just another way to dismiss or categorize people? I don't know. What I do know is that, while certai…
What is race? The problem with the term race is that implies genetic differences where there are none. Regarding being able to tell apart races by looking at them, I highly doubt you could I mean are a black US American and a Nigerian the same race? How about a Namibian? In the US the Nigerian would be classified as African American which says a lot about the ridiculousness.
Classified as black/African-American. Classification is weird, true enough.