Categories
Development

Design patterns for hierarchical data storage and effective processing

The hierarchical data storage problem is a non-trivial task in relational database context. For example, your online shop has goods of different categories and subcategories creating tree spans for 5 levels. How should they be stored in a database?

Luckily, there are several approaches (design patterns) that will help the developer to design database structure without both odd tables and code. As a result, the site will work faster and any changes, even on database layer, won’t cause troubles. We will study these approaches below.

Categories
Legal

US court stated scraping, even when against TOS, is legal

Last month a legal case took place in a US court where four professors plus a media organization sued the US Government. The District Court for the District of Columbia conclusion stated that moderate scraping, even when against ToS, is legal.

A district court in Washington, D.C. has ruled that using automated tools to access publicly available information on the open web is not a computer crime — even when a website bans automated access in its terms of service (document). The court ruled that the notoriously vague and outdated Computer Fraud and Abuse Act (CFAA) — a 1986 statute meant to target malicious computer break-ins — does not make it a crime to access information in a manner that the website doesn’t like if you are otherwise entitled to access that same information.

Before we put down all the legal statement fine details, we better give you a conclusion derived from the law case.
If you do not read all the legal statement fine points, jump right to the conclusion.

Categories
Legal

US court stated scraping, even when against TOS, is legal

court_smallLast month a legal case took place in a US court where four professors plus a media organization sued the US Government. The District Court for the District of Columbia conclusion stated that moderate scraping, even when against ToS, is legal.