akane

8 ms·

31.
by akane 10y ago
Update: Hey ak4g, the latest version of pgslice uses this approach. We're seeing roughly 20% less load on inserts with it (in the short time it's been in production). Thanks for the suggestion!
32.
by akane 10y ago
That's correct. It allows us to manage the database size over time for tables where we can archive data after a specific period.
33.
by akane 10y ago
Is this the latest work? https://www.postgresql.org/message-id/ad16e2f5-fc7c-cc2d-333...
34.
by akane 10y ago
We didn't really find anything that fit our needs. We wanted a tool that was simple to use with the ability to do time-based partitioning of existing production tables without downtime.
35.
by akane 10y ago
We currently use Amazon RDS, which doesn't support custom extensions, so pg_partman wasn’t an option for us. I haven't used pg_partman myself, but it looks to have different features. I think an external tool is a bit friendlier f
36.
by akane 10y ago
We've been using the tool for around 5 months, but the same approach/triggers for over a year. I wasn't aware the IF/ELSIF trigger approach had potential advantages over EXECUTE, but will definitely look into it.
37.
by akane 10y ago
Yes, we do at Instacart.
38.
Show HN: Database insights made easy(github.com)
1 points by akane 12y ago|1 comments
39.
by akane 12y ago
Assuming the Julia implementation is correct, you could write tests based on output from that.
40.
Show HN: Email analytics for Rails(github.com)
1 points by akane 12y ago|0 comments
41.
by akane 13y ago
Currently, a visit record is created as soon as a user lands on a page with the Javascript, but I'm curious to see other ways people want to it.
42.
by akane 13y ago
Unless you have hundreds of unique visitors per second, this shouldn't be a problem.
43.
Show HN: Visit tracking for Rails(ankane.github.io)
51 points by akane 13y ago|16 comments
44.
Show HN: Searchjoy, search analytics made easy(ankane.github.io)
3 points by akane 13y ago|0 comments
45.
Show HN: Set Product Data Free(datakick.org)
2 points by akane 13y ago|0 comments
46.
by akane 13y ago
It's been on Github for a bit, but this is the first big release.
47.
by akane 13y ago
Training searches from conversions (self-improving searches) is kinda interesting. Elasticsearch is an amazing product but it can be hard to configure, especially for beginners. Edit: spelling
48.
by akane 13y ago
We looked into PostgreSQL search for a bit, but didn't see a way to train search results from past conversions. Does anyone know if this is possible?
49.
by akane 13y ago
That's exactly why we open-sourced Searchkick :)
50.
by akane 13y ago
We're indexing around 100k documents. What line are you referring to, and what's bad about it?
51.
Show HN: Search Made Easy(ankane.github.io)
5 points by akane 13y ago|0 comments
52.
by akane 13y ago
Awesome, added this to the todo list.
53.
by akane 13y ago
I would suggest denormalizing only after you find a performance bottleneck. As they say, "premature optimization is the root of all evil".
54.
by akane 13y ago
Good suggestion!
55.
by akane 13y ago
Just a pull request away :)
56.
by akane 13y ago
You can always `curl`, then `cat | sh` if you don't trust me :)
57.
by akane 13y ago
For those concerned about a SQL dependency, it might be useful to create projects in different languages that package these functions. These methods were extracted from https://github.com/ankane/groupdate , which you c
58.
by akane 13y ago
Thanks for the feedback. Working correctly with time zones in the database can be tricky. DATE_TRUNC('day', $1 AT TIME ZONE $2) AT TIME ZONE $2; or CONVERT_TZ(DATE_FORMAT(CONVERT_TZ(ts, '+00:00', time_zone), '%Y-%m
59.
by akane 13y ago
curl | sh is a very transparent installer. Here's the source. https://raw.github.com/ankane/groupdate.sql/master/mysql.sql Also, you don't have to use the root user - I'll make that more clear
60.
Show HN: Better SQL group by date(ankane.github.io)
60 points by akane 13y ago|44 comments

More ›