Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
ocharles
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
19 ms
·
151.
▲
by
ocharles
14y ago
Right tool, right job? I also don't see anything on that website saying "C++ is the right choice for any problem domain".
152.
▲
by
ocharles
14y ago
> WHY would you want to do validation of a "complex" field at the db level? Anything I build on top of this database now benefits from all of my consistency and integrity checks. While it won't prevent me from trying to put bad data in,
153.
▲
by
ocharles
14y ago
Your database should be the central storage of this data and it should do it's hardest to guarantee that everything is consistent. Consistency means referential integrity over foreign keys, but it also means that values of attributes are we
154.
▲
by
ocharles
14y ago
MusicBrainz would be really happy to help try and provide the information you want. You should open a ticket at our bug tracker and we'll see what can be done. I might be biased, but I don't think you'll find cleaner metadata information on
155.
▲
Announcing the Cover Art Archive
(blog.musicbrainz.org)
55 points
by
ocharles
14y ago
|
9 comments
156.
▲
by
ocharles
14y ago
It's a real shame that this rant has made it to the number one spot (as I of now). I don't mind rants, but there's nothing to really take away from this post. The author doesn't provide any motivation as to why any of these things are probl
157.
▲
by
ocharles
14y ago
Yea, I was trying to find some information on exactly how many servers are responsible for content generation. If this is about 100 machines then yes, 70k/s is pretty damn impressive. If it's 1000 machines, then I'm a little less impressed.
158.
▲
by
ocharles
14y ago
Any plans to support MusicBrainz? That would seem like the obvious choice :)
159.
▲
by
ocharles
14y ago
What's the data source for this?
160.
▲
by
ocharles
14y ago
Primary key on idCountry, no unique constraints on name/code/isoAlpha3, and 'default' blank values? It's certainly a start, but it's also a bit questionable.
161.
▲
by
ocharles
14y ago
The counter doesn't have to be private, but being able to view exactly what one person has starred should have a privacy control. We do this at MusicBrainz with 'subscriptions' (to be notified when something changes). We give a number of su
162.
▲
by
ocharles
14y ago
While I agree with you, please be careful - you're an extremely influencial member of the Haskell community. This post could come across as very smug, and is thus potentially damaging. I'm sure it wasn't your attention, but please - be care
163.
▲
by
ocharles
14y ago
This is a good example, but I'm not sure it's very real world. You wouldn't really use symbols in this case - you'd specifically introduce a Sanitized type and promote it to the kind level. But I'm picking holes, it's a good example of the
164.
▲
by
ocharles
14y ago
Type-level naturals let you express things like "map on a Vector of length n will produce a Vector of length n" and "given an element x and a vector xs of length n, cons x xs will produce a Vector of length (n + 1)". Other functions can ins
165.
▲
by
ocharles
14y ago
It has package signing. A quick Google search would have answered your question - http://linux.slashdot.org/story/12/01/17/1446248/package-sig... . Voila!
166.
▲
by
ocharles
14y ago
Great write up, I've been curious about it, but I'm not particularly bothered. I think what I'm going to end up doing is to basically tar ~/media, pipe it through GPG, and pipe it through some upload-to-glacier script. Maybe automate that o
167.
▲
by
ocharles
14y ago
That quote is just painful to read, littered with FUD and not a single bit of evidence to back it up. You should worry about the database because it's probably your canonical storage of data, which for most of us is the most important par
168.
▲
by
ocharles
14y ago
These seem to produce entirely different sets of results: For the bloom filter: (actual time=0.033..2.546 rows=430 loops=1) And for the join: (actual time=7.440..64.843 rows=9 loops=1) So the join returned 9 movies for person_id=160, while
169.
▲
by
ocharles
14y ago
A lot of treats in this release! Amongst the new big features (cascaded replication, index only scans) I'm really happy to see a row->json function (great for message queues), DROP INDEX CONCURRENTLY (more flexibility to play with index
170.
▲
by
ocharles
14y ago
Arguably, yes, because you haven't really broken your data down as much as you need to; but this is a fairly contentious issue - just see http://en.wikipedia.org/wiki/First_normal_form#Atomicity . If you are frequently needing to query ins
171.
▲
by
ocharles
14y ago
If you never need to query 'inside' the array, then I don't think that's a violation of 1NF at all. If you treat the entire array as an atomic value, then I would think that's still 1NF.
172.
▲
by
ocharles
14y ago
When I initially saw this posted here, I was irritated. The tone grates with me, and yes - I would prefer a much drier, concise explanation if I were to receive such a pull request for my projects. I kept this to myself though, and had a lo
173.
▲
by
ocharles
14y ago
Yea, I am currently implementing OAuth ( https://github.com/ocharles/snaplet-oauth2 ) and the specification is not entirely straight forward. There's a lot of edge-case type stuff that's important to get right.
174.
▲
by
ocharles
14y ago
As long as your clusters use the right locale/encoding settings, yes.
175.
▲
by
ocharles
14y ago
You know, I'm probably having fun because of both. I love the type system Haskell gives me for exploring a problem space without diving into a solution. I am enjoying working in a functional language because it forces me to work in really s
176.
▲
by
ocharles
14y ago
Amen, I've spent the last 3 years of my career working on an increasingly complicated Perl project and frankly, I've had enough. My pet projects now are all Haskell and I can't believe how fun it is. I spend most of my time these days fixin
177.
▲
by
ocharles
14y ago
This rings very true to me too, as our entire application is written in Perl. As much as I do like the language, the lack of just about any static guarantees mean we regress an awful lot. Yes, we have unit tests, but until we have 100% cove
178.
▲
by
ocharles
14y ago
> Also, stored procedures is a bad thing - business logic should be written in code, not in data and not in the database. Why? Your post generally makes a lot of criticisms, but fails to back up any of the points made.
179.
▲
by
ocharles
14y ago
Any monad is an applicative functor, and any applicative functor provides 'pure', which does the same as return (lifting a value). The argument of the name 'return' in a discussion on syntax doesn't quite seem appropriate to me - it's an AP
180.
▲
by
ocharles
15y ago
Well this has been good motivation for me to install NoScript
More ›