{"id":2432,"date":"2015-07-13T01:50:26","date_gmt":"2015-07-13T01:50:26","guid":{"rendered":"http:\/\/www.garysieling.com\/blog\/?p=2432"},"modified":"2015-07-13T01:50:26","modified_gmt":"2015-07-13T01:50:26","slug":"rethinkdb-limit-rows","status":"publish","type":"post","link":"https:\/\/www.garysieling.com\/blog\/rethinkdb-limit-rows\/","title":{"rendered":"RethinkDB LIMIT rows query in python"},"content":{"rendered":"<p>Connect to the database:<\/p>\n<pre lang=\"python\">\nimport rethinkdb as r\nr.connect(\"127.0.0.1\", 28015).repl()\ndb = r.db(\"search\")\n<\/pre>\n<p>Filter using match:<\/p>\n<pre lang=\"python\">\n[x for x in table.limit(10).run()]\n<\/pre>\n<p>This will return an array of rows, limited to the number of rows requested.<\/p>\n<p>Note that unlike SQL, the column headers are case sensitive. It appears that the regular expression must match the entire string.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Connect to the database: import rethinkdb as r r.connect(&#8220;127.0.0.1&#8221;, 28015).repl() db = r.db(&#8220;search&#8221;) Filter using match: [x for x in table.limit(10).run()] This will return an array of rows, limited to the number of rows requested. Note that unlike SQL, the column headers are case sensitive. It appears that the regular expression must match the entire &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.garysieling.com\/blog\/rethinkdb-limit-rows\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;RethinkDB LIMIT rows query in python&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[4],"tags":[157,160,447,462,466],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"Connect to the database: import rethinkdb as r r.connect(&quot;127.0.0.1&quot;, 28015).repl() db = r.db(&quot;search&quot;) Filter using match: [x for x in table.limit(10).run()] This will return an array of rows, limited to the number of rows requested. Note that unlike SQL, the column headers are case sensitive. It appears that the regular expression must match the entire\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"gary\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.garysieling.com\/blog\/rethinkdb-limit-rows\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Gary Sieling - Software Engineer\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"RethinkDB LIMIT rows query in python - Gary Sieling\" \/>\n\t\t<meta property=\"og:description\" content=\"Connect to the database: import rethinkdb as r r.connect(&quot;127.0.0.1&quot;, 28015).repl() db = r.db(&quot;search&quot;) Filter using match: [x for x in table.limit(10).run()] This will return an array of rows, limited to the number of rows requested. Note that unlike SQL, the column headers are case sensitive. It appears that the regular expression must match the entire\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.garysieling.com\/blog\/rethinkdb-limit-rows\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2015-07-13T01:50:26+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2015-07-13T01:50:26+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"RethinkDB LIMIT rows query in python - Gary Sieling\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Connect to the database: import rethinkdb as r r.connect(&quot;127.0.0.1&quot;, 28015).repl() db = r.db(&quot;search&quot;) Filter using match: [x for x in table.limit(10).run()] This will return an array of rows, limited to the number of rows requested. Note that unlike SQL, the column headers are case sensitive. It appears that the regular expression must match the entire\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/rethinkdb-limit-rows\\\/#blogposting\",\"name\":\"RethinkDB LIMIT rows query in python - Gary Sieling\",\"headline\":\"RethinkDB LIMIT rows query in python\",\"author\":{\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/author\\\/gary\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/#organization\"},\"datePublished\":\"2015-07-13T01:50:26+00:00\",\"dateModified\":\"2015-07-13T01:50:26+00:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/rethinkdb-limit-rows\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/rethinkdb-limit-rows\\\/#webpage\"},\"articleSection\":\"Code Examples, database, databases, python, reql, rethinkdb\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/rethinkdb-limit-rows\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.garysieling.com\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/category\\\/code-examples\\\/#listItem\",\"name\":\"Code Examples\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/category\\\/code-examples\\\/#listItem\",\"position\":2,\"name\":\"Code Examples\",\"item\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/category\\\/code-examples\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/rethinkdb-limit-rows\\\/#listItem\",\"name\":\"RethinkDB LIMIT rows query in python\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/rethinkdb-limit-rows\\\/#listItem\",\"position\":3,\"name\":\"RethinkDB LIMIT rows query in python\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/category\\\/code-examples\\\/#listItem\",\"name\":\"Code Examples\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/#organization\",\"name\":\"Gary Sieling\",\"description\":\"Software Engineer\",\"url\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/author\\\/gary\\\/#author\",\"url\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/author\\\/gary\\\/\",\"name\":\"gary\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/rethinkdb-limit-rows\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0be925276d848ffe98a6a9dc8cf33e67?s=96&d=identicon&r=g\",\"width\":96,\"height\":96,\"caption\":\"gary\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/rethinkdb-limit-rows\\\/#webpage\",\"url\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/rethinkdb-limit-rows\\\/\",\"name\":\"RethinkDB LIMIT rows query in python - Gary Sieling\",\"description\":\"Connect to the database: import rethinkdb as r r.connect(\\\"127.0.0.1\\\", 28015).repl() db = r.db(\\\"search\\\") Filter using match: [x for x in table.limit(10).run()] This will return an array of rows, limited to the number of rows requested. Note that unlike SQL, the column headers are case sensitive. It appears that the regular expression must match the entire\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/rethinkdb-limit-rows\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/author\\\/gary\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/author\\\/gary\\\/#author\"},\"datePublished\":\"2015-07-13T01:50:26+00:00\",\"dateModified\":\"2015-07-13T01:50:26+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/\",\"name\":\"Gary Sieling\",\"description\":\"Software Engineer\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.garysieling.com\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"RethinkDB LIMIT rows query in python - Gary Sieling","description":"Connect to the database: import rethinkdb as r r.connect(\"127.0.0.1\", 28015).repl() db = r.db(\"search\") Filter using match: [x for x in table.limit(10).run()] This will return an array of rows, limited to the number of rows requested. Note that unlike SQL, the column headers are case sensitive. It appears that the regular expression must match the entire","canonical_url":"https:\/\/www.garysieling.com\/blog\/rethinkdb-limit-rows\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/www.garysieling.com\/blog\/rethinkdb-limit-rows\/#blogposting","name":"RethinkDB LIMIT rows query in python - Gary Sieling","headline":"RethinkDB LIMIT rows query in python","author":{"@id":"https:\/\/www.garysieling.com\/blog\/author\/gary\/#author"},"publisher":{"@id":"https:\/\/www.garysieling.com\/blog\/#organization"},"datePublished":"2015-07-13T01:50:26+00:00","dateModified":"2015-07-13T01:50:26+00:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/www.garysieling.com\/blog\/rethinkdb-limit-rows\/#webpage"},"isPartOf":{"@id":"https:\/\/www.garysieling.com\/blog\/rethinkdb-limit-rows\/#webpage"},"articleSection":"Code Examples, database, databases, python, reql, rethinkdb"},{"@type":"BreadcrumbList","@id":"https:\/\/www.garysieling.com\/blog\/rethinkdb-limit-rows\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.garysieling.com\/blog#listItem","position":1,"name":"Home","item":"https:\/\/www.garysieling.com\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/www.garysieling.com\/blog\/category\/code-examples\/#listItem","name":"Code Examples"}},{"@type":"ListItem","@id":"https:\/\/www.garysieling.com\/blog\/category\/code-examples\/#listItem","position":2,"name":"Code Examples","item":"https:\/\/www.garysieling.com\/blog\/category\/code-examples\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.garysieling.com\/blog\/rethinkdb-limit-rows\/#listItem","name":"RethinkDB LIMIT rows query in python"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.garysieling.com\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.garysieling.com\/blog\/rethinkdb-limit-rows\/#listItem","position":3,"name":"RethinkDB LIMIT rows query in python","previousItem":{"@type":"ListItem","@id":"https:\/\/www.garysieling.com\/blog\/category\/code-examples\/#listItem","name":"Code Examples"}}]},{"@type":"Organization","@id":"https:\/\/www.garysieling.com\/blog\/#organization","name":"Gary Sieling","description":"Software Engineer","url":"https:\/\/www.garysieling.com\/blog\/"},{"@type":"Person","@id":"https:\/\/www.garysieling.com\/blog\/author\/gary\/#author","url":"https:\/\/www.garysieling.com\/blog\/author\/gary\/","name":"gary","image":{"@type":"ImageObject","@id":"https:\/\/www.garysieling.com\/blog\/rethinkdb-limit-rows\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/0be925276d848ffe98a6a9dc8cf33e67?s=96&d=identicon&r=g","width":96,"height":96,"caption":"gary"}},{"@type":"WebPage","@id":"https:\/\/www.garysieling.com\/blog\/rethinkdb-limit-rows\/#webpage","url":"https:\/\/www.garysieling.com\/blog\/rethinkdb-limit-rows\/","name":"RethinkDB LIMIT rows query in python - Gary Sieling","description":"Connect to the database: import rethinkdb as r r.connect(\"127.0.0.1\", 28015).repl() db = r.db(\"search\") Filter using match: [x for x in table.limit(10).run()] This will return an array of rows, limited to the number of rows requested. Note that unlike SQL, the column headers are case sensitive. It appears that the regular expression must match the entire","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/www.garysieling.com\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/www.garysieling.com\/blog\/rethinkdb-limit-rows\/#breadcrumblist"},"author":{"@id":"https:\/\/www.garysieling.com\/blog\/author\/gary\/#author"},"creator":{"@id":"https:\/\/www.garysieling.com\/blog\/author\/gary\/#author"},"datePublished":"2015-07-13T01:50:26+00:00","dateModified":"2015-07-13T01:50:26+00:00"},{"@type":"WebSite","@id":"https:\/\/www.garysieling.com\/blog\/#website","url":"https:\/\/www.garysieling.com\/blog\/","name":"Gary Sieling","description":"Software Engineer","inLanguage":"en-US","publisher":{"@id":"https:\/\/www.garysieling.com\/blog\/#organization"}}]},"og:locale":"en_US","og:site_name":"Gary Sieling - Software Engineer","og:type":"article","og:title":"RethinkDB LIMIT rows query in python - Gary Sieling","og:description":"Connect to the database: import rethinkdb as r r.connect(&quot;127.0.0.1&quot;, 28015).repl() db = r.db(&quot;search&quot;) Filter using match: [x for x in table.limit(10).run()] This will return an array of rows, limited to the number of rows requested. Note that unlike SQL, the column headers are case sensitive. It appears that the regular expression must match the entire","og:url":"https:\/\/www.garysieling.com\/blog\/rethinkdb-limit-rows\/","article:published_time":"2015-07-13T01:50:26+00:00","article:modified_time":"2015-07-13T01:50:26+00:00","twitter:card":"summary_large_image","twitter:title":"RethinkDB LIMIT rows query in python - Gary Sieling","twitter:description":"Connect to the database: import rethinkdb as r r.connect(&quot;127.0.0.1&quot;, 28015).repl() db = r.db(&quot;search&quot;) Filter using match: [x for x in table.limit(10).run()] This will return an array of rows, limited to the number of rows requested. Note that unlike SQL, the column headers are case sensitive. It appears that the regular expression must match the entire"},"aioseo_meta_data":{"post_id":"2432","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"created":"2023-02-04 16:27:34","updated":"2026-07-06 01:12:49","ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.garysieling.com\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.garysieling.com\/blog\/category\/code-examples\/\" title=\"Code Examples\">Code Examples<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tRethinkDB LIMIT rows query in python\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.garysieling.com\/blog"},{"label":"Code Examples","link":"https:\/\/www.garysieling.com\/blog\/category\/code-examples\/"},{"label":"RethinkDB LIMIT rows query in python","link":"https:\/\/www.garysieling.com\/blog\/rethinkdb-limit-rows\/"}],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/posts\/2432"}],"collection":[{"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/comments?post=2432"}],"version-history":[{"count":0,"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/posts\/2432\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/media?parent=2432"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/categories?post=2432"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/tags?post=2432"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}