{
    "version": "https:\/\/jsonfeed.org\/version\/1",
    "title": "Математик среди биологов: заметки с тегом sql",
    "_rss_description": "Я немного умею складывать, но от вычитания у меня всегда кружится голова",
    "_rss_language": "ru",
    "_itunes_email": "",
    "_itunes_categories_xml": "",
    "_itunes_image": "",
    "_itunes_explicit": "",
    "home_page_url": "https:\/\/antonlyakh.ru\/blog\/tags\/sql\/",
    "feed_url": "https:\/\/antonlyakh.ru\/blog\/tags\/sql\/json\/",
    "icon": false,
    "author": {
        "name": "Антон Лях",
        "url": "https:\/\/antonlyakh.ru\/blog\/",
        "avatar": false
    },
    "items": [
        {
            "id": "526",
            "url": "https:\/\/antonlyakh.ru\/blog\/all\/vybrat-sluchany-zapisi-iz-bazy-dannyh-s-pomosch-sql\/",
            "title": "Как выбрать случаные записи из базы данных с помощь SQL?",
            "content_html": "<p>&mdash; Элементарно, Ватсон.<\/p>\n<pre class=\"e2-text-code\"><code class=\"\">SELECT * FROM table ORDER BY RANDOM() LIMIT num_records_to_select<\/code><\/pre><p>&mdash; <kbd>num_records_to_select<\/kbd> заменить на необходимое количество случайных записей.<br \/>\n&mdash; Шерлок, глубина ваших познаний не сравниться ни с какой энцикопедией.<br \/>\n&mdash; Бросьте, Ватсон, я просто много читаю.<\/p>\n",
            "date_published": "2025-07-04T10:50:59+03:00",
            "date_modified": "2025-07-05T13:49:58+03:00",
            "_date_published_rfc2822": "Fri, 04 Jul 2025 10:50:59 +0300",
            "_rss_guid_is_permalink": "false",
            "_rss_guid": "526",
            "_e2_data": {
                "is_favourite": false,
                "links_required": [
                    "system\/library\/highlight\/highlight.js",
                    "system\/library\/highlight\/highlight.css",
                    "system\/library\/highlight\/highlight.js",
                    "system\/library\/highlight\/highlight.css"
                ],
                "og_images": []
            }
        },
        {
            "id": "524",
            "url": "https:\/\/antonlyakh.ru\/blog\/all\/kratkoe-sravnenie-proizvoditelnosti-sqlite-i-duckdb\/",
            "title": "Краткое сравнение производительности SQLite и DuckDB",
            "content_html": "<p class=\"loud\">SQLite быстр с индексами, а DuckDB быстр без них<\/p>\n<p>DuckDB does not seem to work with indices as well as SQLite does but is blazingly fast when scanning large parts of the table.<\/p>\n<p>SQLite is great at using indices but takes its time when it has to look at the whole table.<\/p>\n<p><a href=\"https:\/\/www.lukas-barth.net\/blog\/sqlite-duckdb-benchmark\/\">Benchmarking DuckDB vs SQLite for Simple Queries <\/a><\/p>\n",
            "date_published": "2025-06-24T19:14:45+03:00",
            "date_modified": "2025-06-24T19:15:52+03:00",
            "_date_published_rfc2822": "Tue, 24 Jun 2025 19:14:45 +0300",
            "_rss_guid_is_permalink": "false",
            "_rss_guid": "524",
            "_e2_data": {
                "is_favourite": false,
                "links_required": [],
                "og_images": []
            }
        }
    ],
    "_e2_version": 3559,
    "_e2_ua_string": "E2 (v3559; Aegea)"
}