HN user
hochmartinez
A novel therapy that replenishes cBIN1 protein in cardiac cells may hold the key to reversing heart failure’s relentless progression
Lots of things! It gives you sqlite superpowers. It makes you more productive and saves you lots if time. You can edit several databases at the same time. And editing them is far easier. For example, it generates and executes the sql code to add new columns for you. You can edit the data of several rows directly on a query response, as if It was a spreadsheet, just by clicking on a column value (or you can use a column value editor). Super handy. You can view and edit blobs. The sql editor has autocompletition and you can execute a statement just by having the cursor on this statement, so you can quickly test multiple independent queries in a single editor window. It shows the execution times, so you can easely compare the speed of several query strategies. You can view the query optimizer info by clicking a button. It supports several scripting lenguajes, and the list goes on and on. Check the features here: https://sqlitestudio.pl/features/
I've used both. Sqlitestudio is far more powerful, intuitive and easy to use. Fast and efficient. Flies even in old PCs. In Linux you won't find It in the repositories. You have to download and run a handy installer.
I've been using It for several years, in Windows and now in Linux. Fast, slick and very powerful. Flies on my humble Atom laptop. By far the best free sqlite manager. Thanks Paweł Salawa for this great piece of software!
"... Compared to full-precision Llama models, BitNet a4.8 reduces memory usage by a factor of 10 and achieves 4x speedup..."
Music also generated by AI... :-O
Nope... I'm using a tiny SBC, a Radxa Zero with a A53 Cpu, with Manjaro Linux, as a ultra low power daily driver and it is perfectly usable for light browsing, programming or productivity.
It boots Linux in 7 seconds and xfce desktop is pretty snappy.
Kernel is 6.1 and RAM is only 4GB.
Opens Lazarus almost instantly and FPC compiles ARM binaries super fast.
Amazing little machine...
"... Studies show that riding trains tends to be 20–30 times safer than driving, and riding buses is as much as 60 times as safe..."
'... when communicating with residents, preach abundance rather than restriction. “The first lesson I learned is never talk about the means, which is less cars,” Smet says. “I don’t say ‘I’m going to make this space car-free’; I say ‘I want to make this place one where parents can sit, watch the children play sports, have a drink, enjoying the clean air.’ Who can be against kids playing on a car-free square?...'
“It’s like quitting smoking. The beginning is hard, but after a time it gets easier — and you feel much better.”
In 2021, 1,428 white-sided dolphins were killed in a single day, in the Faroe Islands. A sad record.
Dolphins are intelligent, sentient animals with strong and complex family bonds.
This absurd, bloody and brutal tradition has to end.
You can sign a petition to stop this:
https://www.change.org/p/stop-the-hunt-of-dolphins-and-small...
For Meyer, his veganism also unlocked his discovery of a purpose. He claims that ending animal exploitation is his calling and that as an athlete, he represents an alternative viewpoint that can help achieve this.
“In a world where billions of animals are killed for food every year, and billions of marketing dollars are poured into campaigns linking the consumption of animal products to masculinity and improved athletic performance, my running provides a counter-narrative – that we can thrive and compete as plant-powered athletes,” he said.
"Cars are a very inefficient transportation technology for too many reasons to count. They take up huge amounts of space but get driven around mostly empty — the average private car in the U.S. carries only 1.6 people. A lot of the time, people drive distances that are short enough to easily walk or bike — 28 percent of car trips are a mile or less, according to the Governors Highway Safety Association."
Linux version, please!
I use a Lenovo with a Celeron processor, 4GB of RAM, and Manjaro (Arch) Linux as my main computer for coding and browsing.
Swapping the HDD for an SSD and installing Linux, transformed this machine. Now it's fast enough for normal tasks, even for light photo retouching. And it loads web pages without issues. Faster with each new release of Brave.
Brave's Chromium engine is optimized for Chromebooks, which usually have low power processors, so it runs fine on almost any computer, even with Core 2 Duo processors from 2008.
I also have a Macbook Air from 2014, and it is plenty fast. If you have enough RAM, almost everything loads instantly.
To free up RAM, you can use a tab suspender or enable the battery and memory saver mode in 'chrome://flags'. Each Chromium tab creates a new process and eats a lot of memory.
https://blog.google/products/chrome/new-chrome-features-to-s...
https://chrome.google.com/webstore/search/tab%20suspender
You can speed up Firefox or any Chromium based browser even more by storing the browser cache in a RAM disk. I use a small 128MB cache in the RAM disk and it works great. There is plenty of information on the web to set this.
There is a quite a lot of power hidden by bloat, in these old laptops.
... Use Lazarus and Free Pascal. The are compatible with Delphi and both free and open source.
Lazarus is a very powerful IDE that allows you to build your app for the console, GTK or QT you choose.
And Free Pascal is a blazingly fast compiler, that generates high performance native code for multiple cpus, including Intel and ARM cpus 32bit and 64 bit, and for multiple operating systems (Linux, Mac Os, windows, etc).
It's pretty amazing to see your code compiling and your binaries executing, in such different cpus and operating systems, almost effortlessly.
... Add Linux with a 6.1 kernel with MGLRU, enable ext4 fast_commit, stop unnecessary services.
Switch Chrome by Brave. Add a tab suspender. If you have 4GB or more, set the browser cache to RAM (a tmpfs directory).
You'll be surprised of how speedy and usable is your old Celeron computer.
And this CPU is very power efficient, so no heat and no fan. Silence.
My 2016 Lenovo laptop was almost unusable with windows 10 and its myriad of processes hogging the CPU.
Manjaro Linux brought this little laptop to life and now it's my daily driver, more than enough for my needs (browsing, coding).
Solving the riddle can reduce electric car battery consumption and make life tougher for currency speculators in the future. The discovery has just won the award for best research article and was honored at the field’s most prestigious conference in the United States.
... "We discovered an algorithm that solves the problem in virtually linear time, the fastest way possible. It is a fundamental algorithmic problem that has been studied since the 1950s and is taught around the world. This was one of the reasons that prompted us to solve it," explains Associate Professor Christian Wulff-Nilsen...
That's correct. SQLite has an impressive test suite that makes it very stable. That's why it's used in millions of Android devices or will be used in Cloudflare's edge with D1, for example.
We have the same problem with the library in the OS. And with the default compilation, SQLite usually works fine.
It depends on you use case but, for example, if your db is not super large you could dowload it and use it locally istead of having to connect to an app server for every query or transaction. You could synchronize in the background with the app server. The app speed and responsiveness would be way better.
Or maybe you could use a sqlite replication tool in the browser for near realtime changes in the master node db.
And for single user apps developped with tools like Electron having your db engine in the browser makes the app faster and life easier for the dev.
Node as app server and db backend for a single user app is inefficient, slow and resource hogging.
Using Sqlite you could get rid of node and therefore, reduce memory usage, speed up app loading and execution, have a single code base in the browser that makes debugging far easier, reduce code complexity and app size, reduce cpu cycles, energy usage and CO2 emissions, save precious life time, etc... :-)
sqlite3.wasm should be included in Chrome, Firefox, Safary, Brave, etc. And updated automatically.
Sqlite updates are solid and as far as I know, do not break your code.
Demos you can inspect...
min. 1:13:19: "... The biggest thing I've seen, that takes me absolutely to my core, is not so much how human like is Ai-Da but how robotic we are..."
Scary trend...