Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
aw3c2
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
49 ms
·
181.
▲
by
aw3c2
9y ago
If you want to just make sure that lots of content are accessible eventually that is neglible (and I am constrained by ISP anyways).
182.
▲
by
aw3c2
9y ago
It would be great to have a client that works well for seeding massive amounts of torrents (100,000+) on weak hardware (like a Raspberry). The main problem seems to be memory usage. How is the memory usage of this one? It says it is light-w
183.
▲
by
aw3c2
9y ago
Of course I use indexes. It's utterly silly not to do so. My point was that the submitted post did not make a convincing argument pro MapD when query times are that much slower than a trivial SQLite database.
184.
▲
by
aw3c2
9y ago
I second this, especially since I have been burned by single-purpose raspberry "distros" multiple times in the past in the audio sector. Maintaince is more work than people often realise.
185.
▲
by
aw3c2
9y ago
Yeah, I know. Maybe the post(s) should not talk about performance for those badly fitting examples then.
186.
▲
by
aw3c2
9y ago
The exact same query takes 60-70ms in SQLite for me. This is not a very good MapD advertisement... edit: Actually, I get this (uncached) in the sqlite3 CLI (the 60-70ms where via sqlitebrowser): Run Time: real 0.018 user 0.018164 sys
187.
▲
by
aw3c2
9y ago
I tried both Python 2.7.14 and Python 3.6.4. pandas==0.22.0 and xlrd==1.1.0. https://transfer.sh/2T4fw/hourly_loads.csv.gz is what I get. It looks like dates are stored not as dates but strings in the more recent sprea
188.
▲
by
aw3c2
9y ago
I meant to post some SQLite and Postgres numbers but the CSV that the code generates (on "wget http://www.pjm.com/pub/operations/hist-meter-load/{1993..201... ) is garbage: 2010-01-15 00:00:00,DPL,2
189.
▲
by
aw3c2
9y ago
I thought content was shared even if not pinned until it is garbage collected?
190.
▲
by
aw3c2
9y ago
What specifically are you looking for?
191.
▲
by
aw3c2
9y ago
There really has not been a long-term drop in the stock so that would have been (and still would be) very risky. You were smart not doing it.
192.
▲
by
aw3c2
9y ago
I was curious and searched if there was a project of that name already: https://github.com/OpenIus/lexdown
193.
▲
by
aw3c2
9y ago
Have you tried imposm? Your process sounds magnitudes too slow.
194.
▲
by
aw3c2
9y ago
Nice! Excuse my crankiness. :)
195.
▲
by
aw3c2
9y ago
It also means "fate" or "destiny" in a couple of teeny-tiny languages.
196.
▲
by
aw3c2
9y ago
Installing OSMAnd or Maps.me is not hard.
197.
▲
by
aw3c2
9y ago
> Wikipedia-like database Where can I download the freely-licensed data?
198.
▲
by
aw3c2
9y ago
Well, no comments there so it is pointless to link.
199.
▲
by
aw3c2
9y ago
Non-free and thus irrelevant.
200.
▲
by
aw3c2
9y ago
You need pyqt5 installed. Then just do "python filename.py".
201.
▲
by
aw3c2
9y ago
Or turn on the Signal Generator and play with the multipliers.
202.
▲
by
aw3c2
9y ago
There are many online services for hosted Jupyter Notebooks. mybinder, Google, Intel, Microsoft etc etc
203.
▲
by
aw3c2
9y ago
Announced just the other week: https://www.waze.com/carpool/
204.
▲
by
aw3c2
9y ago
Ah! That was confusing.
205.
▲
by
aw3c2
9y ago
She does.
206.
▲
by
aw3c2
9y ago
Judging from my experience with other well-polished PR pieces from universities, I would expect only the "oscillating above the finger tips" parts to be real time. The more advanced examples were only shown statically and thus wer
207.
▲
by
aw3c2
9y ago
Actually, they support IIIF which is a great way of sharing collections. http://iiif.io/ https://hrc.contentdm.oclc.org/digital/custom/iiif/ http://norman.hrc.utexas.edu/mirad
208.
▲
by
aw3c2
9y ago
wasd for movement versus f for picking up things is very hard to use.
209.
▲
by
aw3c2
9y ago
(2016)
210.
▲
by
aw3c2
9y ago
This one has a big popup shouting "SIGNING UP FOR TASK & PURPOSE IS SIGNING UP TO BE A PART OF OUR COMMUNITY" right in your face though. Screw that. Here are the direct links to the Youtube videos embedded in the "article
More ›