Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
lneves
searching Neon…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
9 ms
·
1.
▲
by
lneves
6mo ago
Back in the day, there was this thing called the "Yellow Pages"! :-)
2.
▲
Why I stopped wearing a bike helmet
(cyclingtips.com)
3 points
by
lneves
8y ago
|
1 comments
3.
▲
SQL Server 2017 Release Candidate 2 (RC2) is now available
(blogs.technet.microsoft.com)
2 points
by
lneves
9y ago
|
0 comments
4.
▲
by
lneves
10y ago
Release notes: https://wiki.documentfoundation.org/ReleaseNotes/5.3
5.
▲
LibreOffice 5.3 is now available
(libreoffice.org)
3 points
by
lneves
10y ago
|
1 comments
6.
▲
PostgreSQL Scalability: Towards Millions TPS
(akorotkov.github.io)
521 points
by
lneves
10y ago
|
210 comments
7.
▲
by
lneves
12y ago
There is MonetDB: https://www.monetdb.org/ I use it with great success.
8.
▲
by
lneves
13y ago
You can also add Duda.IO to the list: http://duda.io/
9.
▲
by
lneves
13y ago
Can you give us some detail on what are those command-line switches?
10.
▲
by
lneves
13y ago
See the docs for: citext: http://www.postgresql.org/docs/9.2/static/citext.html unaccent: http://www.postgresql.org/docs/9.2/static/unaccent.html I think you can make it work.
11.
▲
by
lneves
13y ago
I've been using postgres for a few years now, I also use MSSQL, MonetDB and MySQL. Some of the things I miss most frequently are: - Easy table partitioning. - Support for "phrase search" in fts. - MERGE/UPSERT support. - Columnar storage (a
12.
▲
by
lneves
14y ago
find . -type d edit: for the same output as your command you can use: dir -l
13.
▲
by
lneves
16y ago
I do not think that this is equivalent, it looks like querying complex JSON objects and not "simple" arrays. From the "Array Element by Position" example: db.blogposts.find( { "comments.0.by" : "Abe" } ) PostgreSQL doesn't have JSON
14.
▲
by
lneves
16y ago
Yes I've looked at them. I use them every day. The example you posted its difficult to parse because it deals with multidimensional arrays and also populating one in the inner query. The simple, and much more common case of one dimension ar
15.
▲
by
lneves
16y ago
<quote>simply because a row can't contain sub-arrays or hashes</quote> This is not true at all. At least in PostgreSQL you can have arrays and hashes: http://www.postgresql.org/docs/current/static/arrays.html http://www.p
16.
▲
by
lneves
16y ago
I would be interested to know if sports like cycling also have some kind of the negative health impact caused by the long periods of "sitting down".
17.
▲
by
lneves
17y ago
I want to see it get out :-)
18.
▲
by
lneves
17y ago
So the brain is, in a way, executing before the data is available (energy in this case). You can absorb drugs on your mouth: http://silversol.110mb.com/use/sublin.htm I would think that carbs are also readily absorbed in some quantity w
19.
▲
by
lneves
17y ago
If your objects have a wide variety of attributes, either you need lots of columns with many of them empty, or you need some sort of attribute table with object-key-value triples. Both are bad relational design, but the structure is inhere
20.
▲
by
lneves
18y ago
An easy way do it would be to extract the term vectors from the query and then find related documents computing the cosine similarity measure.
21.
▲
by
lneves
18y ago
No way JVM starts in under a second: it's more like 2 full seconds on his hardware. My machine has lower hardware specs than what the article mentions. This is what i get. $ java -version java version "1.6.0_10" Java(TM) SE Runtime Enviro
22.
▲
by
lneves
18y ago
Did you read the linked presentation? http://www.commandprompt.com/files/mysql_learn.pdf
23.
▲
by
lneves
19y ago
This reminds me of the following Penny Arcade cartoon: http://www.penny-arcade.com/images/2002/20020712l.gif
24.
▲
by
lneves
19y ago
If you haven't seen it yet, check this presentation about partitioning with PostgreSQL: http://images.omniti.net/omniti.com/talks/partitions-public....
25.
▲
by
lneves
19y ago
> When using pgAdmin3, I am forced to expand Servers->Local Server->Databases-><the desired database>->Schema->Public->Tables Yes, that is annoying, but at least the 1.8.1 version of pgAdmin opens in the
26.
▲
PostgreSQL 8.3 Released
(postgresql.org)
34 points
by
lneves
19y ago
|
20 comments