kozlovsky

10 ms·

31.
by kozlovsky 12y ago
Well, Russia just wrote off $32 billions of Cuba debt[1]. I'm not telling that this is the same thing, but still... [1]: http://www.bloomberg.com/news/2014-07-11/russia-writes-off-9...
32.
EuroPython 2014: How Pony ORM translates Python generators to SQL queries(youtube.com)
1 points by kozlovsky 12y ago|0 comments
33.
Give PonyORM a chance(jakeaustwick.me)
51 points by kozlovsky 12y ago|63 comments
34.
Always Hungry? Here’s Why(nytimes.com)
153 points by kozlovsky 12y ago|131 comments
35.
by kozlovsky 13y ago
This post has a good explanation and some advises: http://danieltenner.com/post/32895447025/0017-how-to-nap-htm...
36.
by kozlovsky 13y ago
Yesterday my Intel SSD 320 failed horrible and kills all data on my RAID system. I still do not understand how it happened. I was sure my storage system is very safe. My system was configured as a mirror RAID with two 1TB HDDs. The RAID was
37.
by kozlovsky 13y ago
The basic scenario where lost update is possible looks this way: session_1: BEGIN session_1: SELECT data from T1 where pk = 123 session_2: BEGIN session_2: SELECT data from T1 where pk = 123 session_2: UPDATE T1 set d
38.
by kozlovsky 13y ago
It depends on isolation level. Default isolation level in MySQL is REPEATABLE READ and not SERIALIZABLE. Without locks, lost updates are sometimes possible.
39.
by kozlovsky 13y ago
Without locks lost updates are possible because default isolation level is not SERIALIZABLE
40.
by kozlovsky 13y ago
MVCC in InnoDB and PostgreSQL are totally different. It is PostgreSQL and Oracle MVCC who have very similar, although not identical isolation behaviour (albeit very different implementation), but InnoDB MVCC stands apart from them. At the b
41.
by kozlovsky 13y ago
Actually, it is not always necessary to write a lot of boilerplate code when using a SQL database. For example, with Pony ORM the same SQL query could be written as following: select(p.name for p in pokemon if "Hydro P
42.
by kozlovsky 13y ago
I cannot understand why Delicious team doesn't implemented collaborative filtering [1]. I think this is the main benefit that the user can get from a social bookmarking site - the ability to see the "bookmarks of others that are s
43.
Math Experts Split the Check(mathwithbaddrawings.com)
4 points by kozlovsky 13y ago|0 comments
44.
by kozlovsky 13y ago
No, it is the other way, Python is translated to SQL, not vice versa ;) According to SQL standard, aggregate functions must skip NULL values. The problem is with queries which return no rows. In this case, intuitive expected result of SUM a
45.
by kozlovsky 13y ago
I have not used Peewee, but at first sight the most visible difference is the query syntax - Peewee uses method chaining, whereas Pony ORM decompiles Python AST. I think that many queries can look simpler in Pony than in Pewee. For example,
46.
by kozlovsky 13y ago
Well, it doesn't seems that "rough" to me, because content of GROUP BY and HAVING sections is determined automatically and there is no need to manually join tables
47.
by kozlovsky 13y ago
One of the goals of Pony ORM is to reduce the necessity of using the specific syntax. For example, in Pony ORM you can write: (o for o in Order if o.date_shipped.year == 2012) instead of something like: .filter(extract("year"
48.
by kozlovsky 13y ago
SQL Alchemy is fundamentally based on a relational model and translates queries to SQL. Pony ORM is based on an entity-relationship model, which is logically independent from SQL. Currently Pony translates queries to SQL only, but in the fu
49.
by kozlovsky 13y ago
Hi, I answered about “pure Python” obsession in a separate comment ;) > you're still littering Python with SQL keywords like order_by(), desc(), select(), and commit() Well, I see them not as “SQL keywords” but as logical concepts >
50.
by kozlovsky 13y ago
Hi, I'm Alexander Kozlovsky, one of Pony ORM authors. I'll try to answer some questions > why such an obsession with "pure" Python? With this statement we are trying to say Pony is not just to offer some syntax sugar. The end goal of Po
51.
by kozlovsky 14y ago
"You need permission to access this item"
52.
by kozlovsky 14y ago
...and grab you towel
53.
by kozlovsky 14y ago
No, just more evidence female's life is unenviable in Albania
54.
by kozlovsky 14y ago
you can renew it beforehand with discount for one more year ;)
55.
by kozlovsky 14y ago
To ggualberto - be aware you account are dead, so most HN users didn't see you comments
56.
Russian startup Dream Industries is raided on by its investors(dreamindustriesunderattack.tumblr.com)
2 points by kozlovsky 14y ago|0 comments
57.
by kozlovsky 14y ago
Personally I do not like to release early, but the reason for this, I think, lies not in fear to get negative feedback, but rather in: 1. desire to delay the appearance of the problems caused by maintaining backwards compatibility 2. unwill
58.
Programmer types: Scientists, Engineers and Teachers(softwaremaniacs.org)
2 points by kozlovsky 14y ago|0 comments
59.
Humanoid robot is being trained to work on the International Space Station(sciencespacerobots.com)
1 points by kozlovsky 14y ago|0 comments
60.
by kozlovsky 14y ago
Just keep in mind: widespread adoption of this license can lead to race conditions, when two concurrent authors of simultaneously used products happen to be in the same group

More ›