skysight-inc/HackerNews huggingface dataset:
Two questions:

Wouldn't a "full" RDBMS like Mysql/Postgres offer a ton of benefits over SQLite (like the features to handle edge cases as they arise) to the point where, even if SQLite would work, SQLite still wouldn't be the ideal choice?

Does wordpress completely abstract the database or do third-party plugins use their own interfaces to the database, in which case a migration to SQLite would break a lot of them?
Note that encryption is banned, but digital signatures are not. In theory you could configure SSH to authenticate but not encrypt a connection.
SQLite also does remarkably well with recovering from all manner of power loss / crashes / worst case scenarios. We created a "power loss" rig just to test this facility for one particular system. Really SQLite's biggest weakness is concurrency, and if your app needs that in any serious amount you probably ought to look elsewhere. If you're just dealing with occasional concurrency though SQLite shouldn't be dismissed out-of-hand.
Unfinished Mission v1.9 Para Hile Mod Apk İndir – Ferhat Özal – Hile Apk İndir
So... these internet-founding Einsteins actually think that Bitcoin should be a part of "our" future Utopian web? Well what do they (and all the other blockchain fan-kiddies) think of the fact that Bitcoin has now replaced Western Union as the preferred getaway car for ransomware and other extortionists around the world?

Businesses, universities, and even hospitals whose critical activities grind to a halt at financial gunpoint, and who are advised by law enforcement to roll over and pay up because nothing can be done for them - must be delighted to know that the tools of their demise are so "Utopian".

The internet isn't never was and never will be securable. Even the most resourced orgs are unable to defend their data. The founding fathers of the internet and W3C should admit this, apologize, and stop holding out false hope for the future.
The intersection of Ham radio and SDR (software defined radio) is proving to be quite interesting.
I can't blame them. I've been a huge fan of SQLite for years. Anytime I need storage it's my default choice unless there is a specific reason to use something else.

Another nice advantage of it is if you are distributing something that requires a small dataset[0][1]. If I give you both the code and the data already imported into a sqlite database, then you can use the code right away, or you can dump the data to a different database very easily.

[0] https://github.com/jedberg/wordgen

[1] https://github.com/jedberg/Postcodes
You're doing it right for your application! MySQL or PostgreSQL would most probably be slower and introduce a lot more overhead as they are client/server oriented systems. Don't listen to those armchair architects!
Long story short - used a rainbow table against the Windows XP SAM file to get the password that they used globally - including the login credentials for modifying the content in their CMS for their website. As a joke, we threw Rick Astley up on the main page. The next day, they brought the site down, scoured the logs for my IP address and pressed felony charges against me (Made possible by the CFAA). It's all good now though, after a lot of explaining the judge eventually dropped the case.
Absolutely. I'm quite happy with online pharmacies and telemedicine as separate concepts; it's the conflict of interest inherent in "we'll refer you to a doctor who will give you a prescription so that we can sell you these pills" which concerns me.
Agreed. Not that the 3 items are not relevant, but the fact that it's a local application sounds to me like the most decisive argument in favor of an embedded DB.
For me the best thing about HAM is that it makes you learn before you can play. For a non-engineer such as myself, having to learn the electronics, physics, antenna design, FCC rules etc. forced me to acquire knowledge I probably wouldn't have otherwise gone out of my way for as an adult. I got my General class license a few years ago and keep trying to get myself motivated to go for my Amateur Extra license but doing HAM in NYC is hard. Unless you are lucky enough to have someplace you can put up some kind of antenna you are largely limited to a 5 watt HT. There is so much that is exciting happening in HAM today. SDR systems are very exciting as is all the internet hybrid. It is super fun and I do hope a new generation gets psyched about it and drives innovation.
Lopez Wins the Tour de Suisse
I'm pretty sure that if C was the first language presented to me back in college, I would have found a new major.

C was more convenient than doing assembler, but not much more, compared to say Pascal. (Having learned BASIC, FORTRAN 77, Pascal, PDP-11 ASM, Lisp at school, and some dBASE at work, before we switched over to C at school, which seemed like a big step backward)

var s : string; multi : integer;
...
s := 'Hello' + ' ' + 'world';
multi := 616;
writeln( s, ' ', multi : 4);

vs

char s[ 256 ]; int multi;
...
s = strcat( strcat( "Hello", " "), "world");
multi = 616;
printf( "%s %d4\n" s, multi);

It's a shame no work was put into good Modula 2 compilers (for various platforms) around 85-90, rather than running with C as the standard. Imagine all the security disasters that probably would have been avoided.
Everything is ruled by law, unless you are stateless. In USA, it is legally impossible for some one with net worth under a $1million to sign away protections by claiming due diligence.
I gained a newfound respect for SQLite recently after reading Dan Luu's post on file consistency (http://danluu.com/file-consistency/). I had always thought of SQLite as a bit of a toy database, but having read that post I was surprised by how rigorously it appears to have been developed.
Venezuelans Ransack Stores as Hunger Grips the Nation
The unicode BOM is code point U+FEFF. The process of encoding it determines the order.

Encoded to UTF-8 it becomes EF BB BF. Encoding to UTF-16 big endian it will become FE FF. Encoding it to UTF-16 little endian it becomes FF FE.

Converting it back from UTF-8 always gives you U+FEFF since UTF-8 doesn't care about endianess. Converting it back from UTF-16 using the correct endianess gives you U+FEFF. Converting it using the wrong endianess gives you U+FFFE which is defined by unicode as a "non character" that should never appear in text.
By that definition everything you do with a computer is programming.
Because when you create content, you don't necessarily want to create, or host the system to manage that content.

By the same not, more and more projects are just using gh-pages... it's useful, out there, free (of cost to those publishing) and in general works.

In the end, there's a lot of options, I think seeing IPFS support baked into the browsers will see a new wave the likes that we saw in the late 90's of customized content, and then tooling that publishes to IPFS will take hold and some things may become more standardized.

I think there is a need to get to a DNS pointer that can take one from a name to an IPFS directory (similar to a CNAME) though that may need to be updated for each publish. In the end it can/will all be very interesting to say the least.
Fred Rodell Commencement Address (1962) [pdf]
I was vaguely thinking more of publishing and updating directly to IA through some kind of API, (rather than having them scrape everything - that may actually exist, I don't know), something you could even add as a button to a text editor. But that is pretty close.
https://youtu.be/Pq3exdcbU7U
*interviewer tries it on 2:24
My parents live somewhere relatively rural and I live in a major city. For a while I had a laptop hooked up to a Tentec tranceiver and a 40' vertical back at my folks' place. I was able to remote in and control and hear everything. If amateur radio were more popular I kind of wonder if timeshare on a system like that would be feasible. Sort of defeats the point of operating your own equipment though :P
It's like 45 second in: https://youtu.be/Pq3exdcbU7U
Doesn't "hours of storage" necessarily imply a rate of discharge? If you don't take any steam off it, doesn't it last more than 10 hours? It seems like they should just state the storage in terms of extractable energy stored.

And why sodium? It does not have a spectacular specific heat. Is it just convenient due to its high boiling point?
> I'm actually surprised WordPress hasn't ever moved over to it for ease of installation/deployment

For the same reasons Wordpress hasn't moved to Postgres or doesn't include feature X,Y or Z. Wordpress has to remain relatively stable. A change in the database means breaking Wordpress ecosystem, as many plugins add tables to the DB. There is very little abstraction when it comes to Wordpress API and its interaction with the DB. Wordpress doesn't ship with an ORM.
Is a ski helmet recreational? Not directly; but it makes a recreational activity safer, so it provides indirect recreational value.

Whether birth control pills are used for recreational purposes is a question of semantics; they have no direct recreational use, but make indirectly support recreational activities.
One advantage of screen over tmux I found is that it has much better mouse support.
The issue here appears to be a human misunderstanding of best practices. An investment gone awry, maybe due to insider malfeasance or incompetence. Bitcoin has most certainly had its fair share of those too. This is Ethereum's Mt.Gox moment.
Reflection in C++
Yep I've been using screen for many many years. It's one of those tools that entirely changed how I work. Still haven't had sufficient motivation to switch to tmux, since screen just works and I know all of its key bindings very well.

FWIW, I've found that CTLR-j is the best choice for the primary escape sequence. As an emacs user CTRL-a was unacceptable as was pretty much CTRL-<everything else>.
What are the limitations? I love SQLite, and have vaguely heard that it has issues with concurrency, but what, exactly? I use it on production for www.tithess.gr and it seems to be working beautifully, no concurrency problems whatsoever there.

What problems should I be expecting in a multi-access scenario? I've never had that question answered adequately.
More than you think. One of the selling points for why some organizations, especially financial or legal, advertise they are in specific countries is a strong, consistent enforcement of specific things like banking integrity, contract law, I.P. law, whatever. It's important enough to business sector that it's on the international ratings for what countries are best to do business in. Also, Switzerland makes a killing in the financial sector using this approach.

So, picking the best jurisdiction for something like this plus getting all parties to agree to settle disputes according to its laws would be a positive step for such organizations. Knocks out a whole category of risk. These decentralized schemes often pretend they won't need lawyers but they exist in real world for good reasons. Best to know what they can or can't do in at least all the common, criminal situations.
Thanks. Thinking, yes doing ...not yet. I like one-chip designs and generating hdmi data by software can be .. challenging (besides HDMI has many patents).
Apparently not to enough to stop using the name. Guess it has some value, after all.
For any database that isn't huge, a library embedded into your application is going to be faster than anything that has to communicate with a server over a socket connection. Though both execute SQL queries, SQLite is completely different than relational database servers and appropriate many places where running a full RDBMS is not. For example, you can't run MySQL or Postgres on the iPhone, but you can use SQLite.
The breadth and depth to which SQLite is tested[0] is both admirable and inspiring.

It's not just "internal" tests, like unit tests or things that can be run from client C programs, but tests of all kinds of hard-to-simulate external situations like out-of-memory and power failure situations.

[0]: https://www.sqlite.org/testing.html
While this is true, screen has not been getting some features that people see as important, like vertical splits.

(I mostly hear about this stuff because I still used screen and tons of people are like "why don't you tmux")
And the community themselves are the most ardent investigators of these regulations.
> In the end Scala's requirement to annotate input parameters is not a big deal, as this only enforces what Haskell/Ocaml/... consider to be best practice anyway.

It's a huge deal. I always write type signatures once I know what they are, but a lot of the time I get the compiler to infer them for me which saves significant headaches.
Stewart did read the modern literature.

He might have. He didn't quote any of it.
Yes I had an experience writing a baseball stats program on a Commodore 64 using BASIC. All of the data were in data statements and saved with the program on tape until we could afford a floppy drive and then store data in a serial file and load it in the Baseball stats program.

I too used Visual BASIC, when MS-Access 1.0 first came out middle of the 1990s, I had an interview at a tools making company and they asked me to make a record collection database in MS-Access and even if I never used it before I figured it out because everything was GUI. So I created tables and forms in less than an hour and had a data entry form as well.

Visual BASIC 3.0 and 4.0 they had a RDO object to connect to a database using ODBC drivers. Had an AS/400 and used Showcase ODBC to connect to the DB2 database on the IBM AS/400 for Windows PCs. Used RDO for MS-Access and SQL Server Databases. Then later on ADO replaced RDO.

Then in the Dotnet languages they have ADO.Net that does the same thing to connect to databases.

In my Linkedin profile, former managers and coworkers would endorse me for databases, because I was always fixing the database after someone else messed it up and when they needed a new one nobody knew how to make one, and so I made the databases for them. Converted from Excel and Access to SQL Server as well. Had a VB program that read the Excel or Access database and ran through the ADO database recordset to insert them into SQL Server in another table.

I originally got into computers to learn how to make video games, but found that solving business problems and doing business apps would be more profitable because the video game market had crashed in the 1980s.
Ethereum uses "gas" to quantify the computational resources a contract consumes. There is a slowly growing limit to the amount of gas a contract is allowed to consume in order to execute.

As for being hard to check beforehand, you're absolutely right. You can read about the consequence of this in one case on this reddit thread: https://www.reddit.com/r/ethereum/comments/4ghzhv/government...
The Fathers of the Web Urge Software Engineers to Reinvent the Web
NFD Media: How to find the best Mesothelioma law firm
Using raw bytes makes it possible to create corrupted strings. Slicing is not a safe operation. Python 3 doesn't have this issue.
Well, writing something in a programming language is the easy part, but it's not sufficient and not the main part of being a programmer.

If you can write in plain but exact English what exactly do you want the system to do and how to do it; and what you wrote actually solves the problem that you intended, then you did 90% of the programming work and have 90% of the required skills. Yes, you'd still need to code that in a particular programming language so that "the computer would understand", but doing that takes a tiny portion of the total work time and learning the skills to do that also is simple and fast compared to learning how to do the first part properly.

On the other hand, if what you described actually describes something slightly different from what you wanted (which is very likely) and doesn't describe the behavior in a bunch of things that you didn't think of (which is even more likely) then the skills in that computer language or the "design by the language architect" won't help. And fixing issues like that take up the majority of programmer-hours in any nontrivial software project.
I have used SQLite for similar use cases, but occasionally it's led to a corrupted db. I had a cron task writing to it once a day, but an issue with the scheduler led to 2 tasks one day with the latter one finishing before the former.

Of course I can add locking or something in my code, but I'd prefer to handle at a lower level — for example, have SQLite take the latest write without corrupting. I'm hoping someone has solved this problem with SQLite elegantly.
EU law professor weighs in on Brexit
You cannot have multiple writers to a SQLite database. Only a single file descriptor may be open with 'write' access. As long as you can get the performance you need out of a single writer, then you're good!
By creating automated tools we have changed the way of application development
this isn't a fair comparison. It fails to account for what happens after the files are downloaded, which is where overall js code size has an outsized effect.
SQLite is supposed to handle multiple concurrent writes by returning SQLITE_BUSY. I'm imagining hypothetical other causes for your corruption problem, like power loss at a bad moment.
I think there's one being built in Israel too?
Having to actually put this on your hand makes it much less convenient for short-burst typing than a touchscreen. You have to take it out, fit it, and be temporarily disabled by it.

Using this for typing over long durations isn't more convenient than a keyboard and the friction would probably become uncomfortable over time.

I think this will encounter the same problem most wearables have finding product-market fit. The bar is already incredibly high in terms of the speed and ease of use of consumer electronics. If you've added even 1 physical step that adds even a half-second to an action, people will always eventually default to the half-second faster way of doing something.

There's also the issue of personal consolidation. People will generally favor a single device that does 2 things over two devices that each do 1 thing, even if the more specialized devices perform better at their individual roles. This is why releasing the iPhone eventually cannibalized iPod sales. I don't see a wearable keyboard justifying pocket space for most people.

I actually struggle to find a use for this product even when I get very specific about the use case. If you're rock climbing, you still have to position the screen of the device you're typing on. This product just added to the number of hands I have to use. Even if the screen is mounted somewhere for you, what's the ideal use case? Texting while bicycling?
Yup. I can never get tmux configured in a way that lets me use the mouse through a remote session from osx at work and Ubuntu at home.
I'd love to see the code for this, probably a lot you can learn about low level JS from something like this.
We build mobile applications for Startups and Enterprises. The idea to start a technology company in India is not a new one, but to start a company that purely focus on automating technology is something we don't see everyday and yes it is kind of unique in it own way.

It all started when we were developing our first Android application and then be realized that lots of work that we do can be reused and after that we started to create our automated tools.

At Snaphy, our main focus is to speed the current development process and to reduce the cost of development by using our automated tools. Using this approach we have designed a Backend system which can be integrated with any application and will reduce the time and cost in maintenance.

Snaphy backend contains all the basic features that you will find in any backend system along with some mind blowing features which will change the way you see admin panel in old times. Our automated tools are building blocks all products that we create at Snaphy.

We are looking forward to creating some more tools and started getting our hands dirty with concept of Artifical Intelligence.
I never stop being impressed at how often people will jump to odd, unsupportable, conclusions like, "using MySQL will make this thing faster".

I've seen it so many times over the years regarding users and email configurations. I can't count the number of times I've dropped into someone's badly behaving mail configuration and found they had MySQL hosting the users, and explained it was for "performance" reasons. Somehow they didn't grasp that /etc/passwd fits entirely in memory, and the map files Postfix uses for various lookups and stuff are already a database (just one specifically designed for the task at hand) and also fit entirely in memory. Putting that MySQL layer in there is disastrous if performance matters; it is orders of magnitude slower for any case I've seen...still plenty fast for most cases, but it's ridiculous that this idea gets cargo-culted around that if you store your mail users in MySQL your mail server will be faster.

A little knowledge is a dangerous thing, is what I'm trying to say, and people who know MySQL is "fast" may not know enough to know that it's not the right tool for the job in a lot of cases...and is probably slower for many use cases. I'm pretty confident this is one of those cases. SQLite is wicked fast on small data sets, and being smaller means more of it will fit in memory; I can't think of any way MySQL could be a more performant choice for this workload.

Also, I don't even want to try to imagine shipping an installable desktop application for non-technical users that relies on MySQL!
There's a balance though because I learn a lot by DOING, I can only read/learn/think about something so much before it just gets fuzzy and I can't keep anymore in my head.
https://mobile.twitter.com/Hartator/status/74466202159817523...

Asked if removing the option to have the ovh modified version of Ubuntu will be enough. I always have random bugs when I was using it anyway. And it's pretty hard to debug.
Mozilla has something similar, at least when it comes to Firefox.

Looks like everyone took their pitchforks out too soon.
There are a handful of incidents every year that the bureau does take action on. It's hard to draw any numerical conclusions from, but it is interesting to read some of the enforcement letters

https://transition.fcc.gov/eb/AmateurActions/Welcome.html
Besides this discussion, if "begs the question" is good English or used correctly by me. I think to set state with the lowest GDP and "worst doing state" equal was wrong and incorrect.

Now I remember all the discussions I had if the GDP is actually a good indicator of the economy and welth of a nation, state, or territory.
Speaking of photography, I haven't seen much in terms of new services or opportunities for photographers made available through technology in the past few years. Where's all the innovation in this field? Is the medium dying out?

Instagram gave photographers a hugely popular new avenue to show their work, although it does shrink your 50mb asset to a crappy thumbnail. It's hard to stand out, very similarly to the App Store. 500px is pretty neat, but it's mostly an echo chamber for photographers, the public is elsewhere. Cameras are mostly the same over the years, just better and faster. Mirrorless is cool, but not necessarily game changing. Seems like a very static industry. We've all done the same HDR shots thousands of times from every conceivable angle of every conceivable object and person, it's getting stale.

I suspect that most photographers will have to move into video sooner or later, as that is a lot more engaging for the masses, and still photos will be like black and white photography, mostly relegated to high art and academia.

One avenue I can see happening down the line is that all of our assets and editing will eventually be in the cloud, a la Google Docs. Right now the only issue is the size and quantity of assets, which is orders of magnitude higher than text files, but we'll get there.