TekMol

79 ms·

961.
by TekMol 4y ago
Do not use `cp` to back up SQLite databases. It is not transactionally safe. What if you disable the journal like this: PRAGMA journal_mode=OFF; Can cp be used to backup the DB then? And do you still have to send "COMMIT&
962.
Ask HN: Why is UST still traded at about 20 cent per UST?
1 points by TekMol 4y ago|0 comments
963.
by TekMol 4y ago
crypto bros are finally getting a punch to the mouth Finally? Bitcoin has been losing 50% of its value 4 times during the last 10 years. It even lost 80% of its value multiple times.
964.
by TekMol 4y ago
It only looks like it is crashing when you look at it on a linear scale. Because a linear scale makes the same swings (percentage wise) look larger during times when the price is higher. When you look at the Bitcoin chart over the last 10 y
965.
by TekMol 4y ago
How is it possible that a website is so slow like AirBnBs? Everything I do on the site makes me wait. Even when I click on the calendar, it opens the widget and then slowlay paints the day numbers one by one.
966.
Juno community sends $36M of tokens into nirvana via a copy and paste mistake(coindesk.com)
5 points by TekMol 4y ago|0 comments
967.
by TekMol 4y ago
Can cryptography change the state of affairs in this regard? The whole problem is reputation management here. From eBay's perspective, they did not have strong enough signals that you are an honest person. With cryptography, you could
968.
by TekMol 4y ago
Imagine we are in the 60s again. When TCP/IP was just invented. Your statement is like saying the internet is cables between machines so they can morse code each other. Another way to look at the internet is to see all the applications
969.
by TekMol 4y ago
I think it is the combination of 2 points: 1: It is hard to grasp. And the majority of tech people have a hard time coping with the fact that there is something they can't grasp while some others do. We tech people think of us as smart
970.
by TekMol 4y ago
Aren't all those SEO optimized pages "blog posts"? How would a search engine separate the "bad" blogs from the "good" ones?
971.
My Fiverr Due Diligence
2 points by TekMol 4y ago|0 comments
972.
by TekMol 4y ago
But does it make a difference if I have to look up how to do these things on Tasker vs how to do these things on Debian? "Did my job run correctly?" can mean so many things. I have to define what that means for my specific use cas
973.
by TekMol 4y ago
What security outside the app? Do you think the OS maintainers deliver you an OS full of holes that you have to fix?
974.
by TekMol 4y ago
I'm trying to understand your service. You write: It's really easy to spin up a web app in production. ... However, it is incredibly difficult to run anything longer than a web request. I can rent a $5&#x
975.
by TekMol 4y ago
You don't have to do any of those security wise. On a plain Debian installation, do "apt install php", throw your files into /var/www/html/ and your application is up and running in a secure fashion.
976.
by TekMol 4y ago
OS level security? What does a service like Heroku even offer in this regard? You can turn on autoupdates or run "apt update && apt upgrade" regularely. If an OS level exploit slips through that, you will probably be affec
977.
by TekMol 4y ago
Why not just use a $10/month bare bones virtual machine? I just use plain Debian, copy my stuff over via rsync and everything works fine. The machine gets something like 10k users on a normal day. In the past, it occasionally handled 3
978.
Is Visa taking 2% out of all my transactions?
15 points by TekMol 5y ago|48 comments
979.
by TekMol 5y ago
Thats the point. I prefer to go without ACID compliance, becasause it is such a performance hog. How often do you experience "errors" that corrupt your database files? How much performance downgrade would you be willing to take to
980.
by TekMol 5y ago
Yes, it makes things faster. But not to the level of performance you can get out of a completely transactionless setup. At least according to my experiments with MyISAM tables vs InnoDB. I never got InnoDB tables to perform as well as MyISA
981.
by TekMol 5y ago
Batching multiple queries into a single transactions of course greatly increases performance compared to have one transaction per query. But it does not give you the performance you get if there are no transactions in the first place.
982.
by TekMol 5y ago
"Backup or restore while a transaction is active" Is it possible to turn off transactions alltogether in SQLite? So they function like a MyIsam table in MySql or a Aria table in MariaDB? I have crunched many billions of queries ov
983.
by TekMol 5y ago
That is not the type of log level security we are discussing. "Security" here means that a piece of data that was written to the log stays there unaltered. "Theft" is on a much higher abstraction level. A "Bitcoin t
984.
by TekMol 5y ago
You can only create "tamper proofness" aka security with social coordination. Your bankaccount is somewhat secure due to layers and layers of agreements and interdependencies of people. Bitcoin works the same way, but in a much mo
985.
by TekMol 5y ago
The value of blockchains seem so obvious to me, that I wonder if OP can be genuine. ask_111: How can having a public log that is extremely tamper resistant not have value? Let's look at a concrete example: Bitcoin. You can write someth
986.
Ask HN: Is there something as good / better as IRC for programming questions?
27 points by TekMol 5y ago|23 comments
987.
Ask HN: Can you restrict Google Colab drive access to a single folder?
1 points by TekMol 5y ago|0 comments
988.
by TekMol 5y ago
Articles should also be read carefully. This was not related to the contract behaving in unexpected ways.
989.
by TekMol 5y ago
I would prefer micropayments over an aggregator. Pay $0.05 to read an article.
990.
by TekMol 5y ago
Thanks for the info! "A long time" is very relative. I sometimes meet coders who have been coding for 3 years and call it a long time. But for me, "a long time" means 20+ years. So I am still curious :) The "NULLs&q

More ›