Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
taffer
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
16 ms
·
211.
▲
by
taffer
6y ago
> A lot of ISA design is about avoiding patents and other traps. Aren't patents limited to 20 years? Can't you just ignore all inventions that are < 20 years old to be safe from patents? Then you'd still be 10 years ahe
212.
▲
by
taffer
6y ago
Threads are fine as long as they do not share mutable data structures. For example, multithreaded application servers are a rather painless experience.
213.
▲
by
taffer
6y ago
As far as I know SOA is a concept and DCOM and CORBA are implementations of this concept. Microservices are a more lightweight variant of SOA, but basically the same idea.
214.
▲
by
taffer
6y ago
Let's assume there is a business requirement that an order belongs to a customer. By definition, this is business logic. If you implement this requirement by creating a foreign key constraint, then you have added business logic to the
215.
▲
by
taffer
6y ago
What does "business logic" mean to you? According to the Wikipedia definition [1], I find it very difficult to imagine SQL that does not contain business logic. [1] "business logic or domain logic is the part of the program
216.
▲
by
taffer
6y ago
Again, this has nothing to do with technology. Why do we assume that you only have to follow software engineering principles when writing Java, but not when writing SQL?
217.
▲
by
taffer
6y ago
Not having consistent rules about what code belongs where is a people problem, not a technology problem. In order to write maintainable software, you always need proper code classification, regardless if you use stored procedures or not.
218.
▲
by
taffer
6y ago
It is a common misconception that more data processing in SQL puts a higher load on the database. A typical database spends 96% of its CPU time on logging, locking, latching and marshalling [1][2] rather than processing SQL. By sending less
219.
▲
A History and Evaluation of System R (1981) [pdf]
(people.eecs.berkeley.edu)
1 points
by
taffer
6y ago
|
0 comments
220.
▲
by
taffer
6y ago
Isn't kdb column oriented and optimized for analytics? This is not what you want for transactional workloads that are usually row-oriented.
221.
▲
by
taffer
6y ago
> The comparison is between the actual stock prices against the constant discount rate of subsequent real dividends. The EMH states that the market incorporates all currently available information, but future dividends are known only in
222.
▲
by
taffer
6y ago
> I believe he shows in that book it's not a very good approximation But what does that mean? What is a good predictor of future returns and what is not? If markets are not, what is? > the market wildly overshoots and undershoots
223.
▲
by
taffer
6y ago
I haven't read the book, but do you know where the expected returns (the straight line you mention) come from?
224.
▲
by
taffer
6y ago
What does 'irrational in important ways' even mean? What Shiller has shown is simply that the idea of a perfectly effecient market is self-contradictory. Efficiency is just a very good approximation in practice.
225.
▲
by
taffer
6y ago
> It will save vast amount of time and money. And it will prevent much animal suffering.
226.
▲
by
taffer
6y ago
You don't need sugar in the sauce if you use high quality tomatoes that have a balanced sweetness / acidity.
227.
▲
by
taffer
6y ago
In the long term, real estate and stocks have done much better than gold and in the short term fiat money is more useful.
228.
▲
by
taffer
6y ago
> I don't see how JOIN is like flatMap This is explained in the blog post I linked, including an example.
229.
▲
by
taffer
6y ago
In which language is it obvious not to put money into a float? In which language is it obvious if I want a synchronizedSortedMap or an arrayList? There are simply things you have to learn to use a technology. If you want to write Java, you
230.
▲
by
taffer
6y ago
> The basic concepts are simple, but the implementation details quickly become very complex True, but those kinds of questions come up in every language: Should I use an array or a dictionary? Should people have references to projects or
231.
▲
by
taffer
6y ago
SQL and functional programming constructs are actually quite similar: SELECT -> map FROM -> stream JOIN -> flatMap WHERE -> filter GROUP BY -> collect ORDER BY -> sorted https://blog.jooq.org/2015/08&#
232.
▲
by
taffer
6y ago
When you look at SQL from a logical/set-based perspective, it is by no means unintuitive. Basically, all you do is join all the tables you need and then filter out everything you don't need and maybe do an aggregation here and the
233.
▲
by
taffer
6y ago
I would argue that a Postgrest API is conceptually closer to GraphQL than to SQL.
234.
▲
by
taffer
6y ago
This also means that you have to stick to the lowest common denominator between all databases.
235.
▲
by
taffer
6y ago
Can't you use transactions to set up and tear down fixtures? That should be a lot faster than spinning up a new database every time.
236.
▲
by
taffer
6y ago
This depends on the RDBMS. Oracle for example has incremental materialized view updates.
237.
▲
by
taffer
6y ago
The countries where rail transport is competitive with air transport (France, Japan) have high-speed rail that is separate from regional lines.
238.
▲
by
taffer
6y ago
If I just want to find the nearest point in a small country using the <-> operator, do I need any extension at all?
239.
▲
by
taffer
6y ago
Also [The relational model] provides a basis for a high level data language which will yield maximal independence between programs on the one hand and machine representation and organization of data on the other. A further advantage of t
240.
▲
by
taffer
7y ago
The article is about desktop browsers.
More ›