{"id":12045,"date":"2021-12-11T17:31:42","date_gmt":"2021-12-11T16:31:42","guid":{"rendered":"https:\/\/flaven.fr\/?post_type=bf_videos_manager&#038;p=12045"},"modified":"2021-12-12T10:10:13","modified_gmt":"2021-12-12T09:10:13","slug":"part-2-python-screaming-frog-seo-automate-poc-creating-database-in-sqlite-with-streamlit-and-sqlalchemy","status":"publish","type":"bf_videos_manager","link":"https:\/\/flaven.fr\/videos\/part-2-python-screaming-frog-seo-automate-poc-creating-database-in-sqlite-with-streamlit-and-sqlalchemy\/","title":{"rendered":"Part 2 Python, Screaming Frog, SEO, Automate, POC :: Creating Database in SQLite with Streamlit and SQLAlchemy"},"content":{"rendered":"<p>Part 2 Python, Screaming Frog, SEO, Automate, POC :: Creating Database in SQLite with Streamlit and SQLAlchemy<\/p>\n<p><b>QUICK DESCRIPTION<\/b><br \/>\nA personal tooling. A &#8220;tool&#8221; industrialized and automatized to: chain actions between them in order to improve productivity and facilitate decision-making, delegate tedious work to machines in order to give me more free time.<br \/>\nSo, the output is a Streamlit Dashboard, Screaming Frog SEO Spider for large time saves and fast audits then manage the output (csv reports), save it into a SQLite database and analyse it with creating graphics.<\/p>\n<ul>\n<li><b>Streamlit<\/b>: Streamlit turns data scripts into shareable web apps in minutes. All in Python. All for free. No front\u2011end experience required. More on <a href=\"https:\/\/streamlit.io\/\" target=\"_blank\" rel=\"noopener\">https:\/\/streamlit.io\/<\/a><\/li>\n<li><b>SQLite<\/b>: Streamlit turns data scripts into shareable web apps in minutes. All in Python. All for free. No front\u2011end experience required. More on <a href=\"https:\/\/sqlite.org\" target=\"_blank\" rel=\"noopener\">https:\/\/sqlite.org<\/a><\/li>\n<li><b>SQLAlchemy<\/b>: Streamlit turns data scripts into shareable web apps in minutes. All in Python. All for free. No front\u2011end experience required. More on <a href=\"https:\/\/www.sqlalchemy.org\/\" target=\"_blank\" rel=\"noopener\">https:\/\/www.sqlalchemy.org\/<\/a><\/li>\n<li><b>The Screaming Frog SEO<\/b>: Streamlit turns data scripts into shareable web apps in minutes. All in Python. All for free. No front\u2011end experience required. More on <a href=\"https:\/\/www.screamingfrog.co.uk\/seo-spider\/\" target=\"_blank\" rel=\"noopener\">https:\/\/www.screamingfrog.co.uk\/seo-spider\/<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Part 2 Python, Screaming Frog, SEO, Automate, POC :: Creating Database in SQLite with Streamlit and SQLAlchemy QUICK DESCRIPTION A personal tooling. A &#8220;tool&#8221; industrialized&hellip; <\/p>\n<p class=\"text-center\"><a href=\"https:\/\/flaven.fr\/videos\/part-2-python-screaming-frog-seo-automate-poc-creating-database-in-sqlite-with-streamlit-and-sqlalchemy\/\" class=\"more-link\">Continue reading &rarr; <span class=\"screen-reader-text\">Part 2 Python, Screaming Frog, SEO, Automate, POC :: Creating Database in SQLite with Streamlit and SQLAlchemy<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":11707,"comment_status":"open","ping_status":"closed","template":"","bf_videos_manager_tag":[2707,2685,2719,2771,2711,2674,2754,2845,2805,2683,2813,2846,2672,2848,2812,2806,2749],"bf_videos_manager_cat":[2678,2721,2679,2680,2728],"class_list":["post-12045","bf_videos_manager","type-bf_videos_manager","status-publish","has-post-thumbnail","hentry","bf_videos_manager_tag-agile","bf_videos_manager_tag-anaconda","bf_videos_manager_tag-automation","bf_videos_manager_tag-automatization","bf_videos_manager_tag-bulk","bf_videos_manager_tag-database","bf_videos_manager_tag-learning-by-doing","bf_videos_manager_tag-mac","bf_videos_manager_tag-numpy","bf_videos_manager_tag-p-o","bf_videos_manager_tag-panda","bf_videos_manager_tag-poc","bf_videos_manager_tag-python","bf_videos_manager_tag-sqlalchemy","bf_videos_manager_tag-sqlite","bf_videos_manager_tag-streamlit","bf_videos_manager_tag-workflow","bf_videos_manager_cat-python","bf_videos_manager_cat-training","bf_videos_manager_cat-tutorials","bf_videos_manager_cat-videos","bf_videos_manager_cat-workflow"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/flaven.fr\/happy-api\/wp\/v2\/bf_videos_manager\/12045","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/flaven.fr\/happy-api\/wp\/v2\/bf_videos_manager"}],"about":[{"href":"https:\/\/flaven.fr\/happy-api\/wp\/v2\/types\/bf_videos_manager"}],"author":[{"embeddable":true,"href":"https:\/\/flaven.fr\/happy-api\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/flaven.fr\/happy-api\/wp\/v2\/comments?post=12045"}],"version-history":[{"count":1,"href":"https:\/\/flaven.fr\/happy-api\/wp\/v2\/bf_videos_manager\/12045\/revisions"}],"predecessor-version":[{"id":12046,"href":"https:\/\/flaven.fr\/happy-api\/wp\/v2\/bf_videos_manager\/12045\/revisions\/12046"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/flaven.fr\/happy-api\/wp\/v2\/media\/11707"}],"wp:attachment":[{"href":"https:\/\/flaven.fr\/happy-api\/wp\/v2\/media?parent=12045"}],"wp:term":[{"taxonomy":"bf_videos_manager_tag","embeddable":true,"href":"https:\/\/flaven.fr\/happy-api\/wp\/v2\/bf_videos_manager_tag?post=12045"},{"taxonomy":"bf_videos_manager_cat","embeddable":true,"href":"https:\/\/flaven.fr\/happy-api\/wp\/v2\/bf_videos_manager_cat?post=12045"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}