alvil

11 ms·

31.
by alvil 9y ago
I usually use query similar to this one (in PHP/MySQL), it's much faster than traditional offset query. You can compare it for yourself using EXPLAIN. Sure not for 100M records, but for 1M or so :) $items = db("SELECT a,b
32.
by alvil 9y ago
With this approach you can't have page numbers on the front-end, just first, prev, next and maybe last. You can't jump to particular page. It is old technique and I like it, but if it would be usable it would be used by everyone b
33.
by alvil 9y ago
Pet: https://github.com/knqyf263/pet and Peco: https://github.com/peco/peco
34.
Min – A smarter web browser(minbrowser.github.io)
101 points by alvil 9y ago|72 comments
35.
by alvil 9y ago
Crippled Lua
36.
Google/xi-editor: A modern editor with a back end written in Rust(github.com)
2 points by alvil 9y ago|0 comments
37.
by alvil 9y ago
You can also use dot import ( . "fmt" ) .... // now call function without prefix Println("Read more docs")
38.
Vim.org is down(vim.org)
1 points by alvil 9y ago|0 comments
39.
C libraries package manager(github.com)
2 points by alvil 9y ago|0 comments
40.
Ask HN: What software stack and tools are you using for C programming on Linux?
2 points by alvil 9y ago|1 comments
41.
by alvil 9y ago
I like it using newLISP :) ;calculate primes in a range (define (primes from to) (local (plist) (for (i from to) (if (= 1 (length (factor i))) (push i plist -1))) plist)) (set 's
42.
by alvil 9y ago
Searching is still slow but otherwise Gitlab is excellent, I'm using it every day.
43.
Simple Sabotage Field Manual by U.S. Office of Strategic Services (1944)(gutenberg.org)
1 points by alvil 9y ago|0 comments
44.
by alvil 9y ago
I'm wondering if it is possible also with Signal (signal.org)
45.
by alvil 9y ago
Here are some comments from SQLite itself: https://www.reddit.com/r/PHP/comments/59na74/sqlite_as_the_o...
46.
by alvil 9y ago
+1 for this
47.
by alvil 9y ago
There is no such thing as permanently delete Facebook or Google account :)
48.
ClickHouse – open source distributed column-oriented DBMS(clickhouse.yandex)
1 points by alvil 9y ago|0 comments
49.
by alvil 9y ago
Only idiot can support cashless society creation.
50.
by alvil 9y ago
may I use color names as values? is black and white allowed?? is this correct politically?
51.
Arch Linux quick install(github.com)
1 points by alvil 9y ago|0 comments
52.
by alvil 10y ago
I'm in the same situation, I didn't use my account several years. Than I tried to login, and account is locked. I was asked to send my ID. I did it. Now I'm waiting fifth month to unlock it and nothing happens. They have my I
53.
Download ActiveGo – ActiveState(activestate.com)
3 points by alvil 10y ago|0 comments
54.
by alvil 10y ago
I can't believe you can look at that ugly colorscheme whole day working in even uglier language which rust really is.
55.
Stop Working for Free Time Is Running Out(thoughtcatalog.com)
1 points by alvil 10y ago|0 comments
56.
Closing down for a day(webmasters.googleblog.com)
1 points by alvil 10y ago|0 comments
57.
by alvil 10y ago
thanks for your suggestions KabuseCha :)
58.
by alvil 10y ago
Report tool I use is Google's official webmaster tool (420ms an average time in "crawl stats"). And here is the article on budget https://webmasters.googleblog.com/2017/01/what-crawl-budget-...
59.
by alvil 10y ago
There is also another problem on how much and how often is Googlebot indexing your site because your site speed is one of the factors of so called Google index budget. My users are in Germany so my VPS is also in Germany to be fast for loca
60.
Althttpd: Fast HTTP server as single C file handling static and CGI files(github.com)
2 points by alvil 10y ago|0 comments

More ›