{"id":9794,"date":"2023-10-05T08:56:24","date_gmt":"2023-10-05T06:56:24","guid":{"rendered":"https:\/\/smartdatamodels.org\/?p=9794"},"modified":"2023-10-04T18:02:30","modified_gmt":"2023-10-04T16:02:30","slug":"vote-for-the-new-sql-service-just-two-questions","status":"publish","type":"post","link":"https:\/\/smartdatamodels.org\/index.php\/vote-for-the-new-sql-service-just-two-questions\/","title":{"rendered":"Vote for the new SQL service (Just two questions)"},"content":{"rendered":"<p>We are very close to launch a new service and we want to have your feedback on how to create this service.<\/p>\n<p>So we made a Survey and you can help us by submitting your preference.<\/p>\n\n<div class=\"wpcf7 no-js\" id=\"wpcf7-f9786-o1\" lang=\"en-US\" dir=\"ltr\" data-wpcf7-id=\"9786\">\n<div class=\"screen-reader-response\"><p role=\"status\" aria-live=\"polite\" aria-atomic=\"true\"><\/p> <ul><\/ul><\/div>\n<form action=\"\/index.php\/wp-json\/wp\/v2\/posts\/9794#wpcf7-f9786-o1\" method=\"post\" class=\"wpcf7-form init\" aria-label=\"Contact form\" novalidate=\"novalidate\" data-status=\"init\">\n<fieldset class=\"hidden-fields-container\"><input type=\"hidden\" name=\"_wpcf7\" value=\"9786\" \/><input type=\"hidden\" name=\"_wpcf7_version\" value=\"6.1.5\" \/><input type=\"hidden\" name=\"_wpcf7_locale\" value=\"en_US\" \/><input type=\"hidden\" name=\"_wpcf7_unit_tag\" value=\"wpcf7-f9786-o1\" \/><input type=\"hidden\" name=\"_wpcf7_container_post\" value=\"0\" \/><input type=\"hidden\" name=\"_wpcf7_posted_data_hash\" value=\"\" \/><input type=\"hidden\" name=\"_wpcf7cf_hidden_group_fields\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_hidden_groups\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_visible_groups\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_repeaters\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_steps\" value=\"{}\" \/><input type=\"hidden\" name=\"_wpcf7cf_options\" value=\"{&quot;form_id&quot;:9786,&quot;conditions&quot;:[],&quot;settings&quot;:{&quot;animation&quot;:&quot;yes&quot;,&quot;animation_intime&quot;:&quot;200&quot;,&quot;animation_outtime&quot;:&quot;200&quot;,&quot;conditions_ui&quot;:&quot;normal&quot;,&quot;notice_dismissed&quot;:&quot;true&quot;,&quot;notice_dismissed_rollback-cf7-5.9.4&quot;:true,&quot;notice_dismissed_rollback-cf7-5.9.5&quot;:true,&quot;notice_dismissed_rollback-cf7-6.1.4&quot;:true}}\" \/><input type=\"hidden\" name=\"redirect_nonce\" value=\"d9ef6bf180\" \/><input type=\"hidden\" name=\"wpcf7cfpdf_hidden_name\" value=\"document-pdf\" \/><input type=\"hidden\" name=\"wpcf7cfpdf_hidden_reference\" value=\"4ec48e8e\" \/><input type=\"hidden\" name=\"wpcf7cfpdf_hidden_date\" value=\"04222026\" \/><input type=\"hidden\" name=\"_wpcf7_recaptcha_response\" value=\"\" \/>\n<\/fieldset>\n<p>This is a survey about the type of service that we want to create for the users of the Smart Data Models that generates a PostgreSQL schema SQL script.\n<\/p>\n<p><label>1. Do you think the SQL schema generator could be useful for you? <\/label><br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"useful\"><span class=\"wpcf7-form-control wpcf7-radio\"><span class=\"wpcf7-list-item first\"><label><input type=\"radio\" name=\"useful\" value=\"Very useful\" \/><span class=\"wpcf7-list-item-label\">Very useful<\/span><\/label><\/span><span class=\"wpcf7-list-item\"><label><input type=\"radio\" name=\"useful\" value=\"Somehow useful\" \/><span class=\"wpcf7-list-item-label\">Somehow useful<\/span><\/label><\/span><span class=\"wpcf7-list-item\"><label><input type=\"radio\" name=\"useful\" value=\"Not useful\" \/><span class=\"wpcf7-list-item-label\">Not useful<\/span><\/label><\/span><span class=\"wpcf7-list-item last\"><label><input type=\"radio\" name=\"useful\" value=\"Useless\" \/><span class=\"wpcf7-list-item-label\">Useless<\/span><\/label><\/span><\/span><\/span>\n<\/p>\n<p><b> 2. We would like to propose the following ways to interact with the service, choose one of these approaches : <\/b><b><br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"sql-service-options\"><span class=\"wpcf7-form-control wpcf7-checkbox wpcf7-exclusive-checkbox\"><span class=\"wpcf7-list-item first\"><label><input type=\"checkbox\" name=\"sql-service-options\" value=\"&quot;Option 1: Provide as input the URL to the model.yaml file e.g https:\/\/raw.githubusercontent.com\/smart-data-models\/dataModel.Weather\/master\/WeatherForecast\/model.yaml&quot;\" \/><span class=\"wpcf7-list-item-label\">&quot;Option 1: Provide as input the URL to the model.yaml file e.g https:\/\/raw.githubusercontent.com\/smart-data-models\/dataModel.Weather\/master\/WeatherForecast\/model.yaml&quot;<\/span><\/label><\/span><span class=\"wpcf7-list-item\"><label><input type=\"checkbox\" name=\"sql-service-options\" value=\"&quot;Option 2: Upload the model.yaml file of your data model&quot;\" \/><span class=\"wpcf7-list-item-label\">&quot;Option 2: Upload the model.yaml file of your data model&quot;<\/span><\/label><\/span><span class=\"wpcf7-list-item last\"><label><input type=\"checkbox\" name=\"sql-service-options\" value=\"&quot;Option 3: Precise the data model subject and the data model name&quot;\" \/><span class=\"wpcf7-list-item-label\">&quot;Option 3: Precise the data model subject and the data model name&quot;<\/span><\/label><\/span><\/span><\/span><br \/>\n<label> 3. Propose other ways (optional)<br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"your-suggestion\"><textarea cols=\"40\" rows=\"10\" maxlength=\"2000\" class=\"wpcf7-form-control wpcf7-textarea\" aria-invalid=\"false\" name=\"your-suggestion\"><\/textarea><\/span> <\/label><br \/>\nIf you want us to discuss the suggestion fill your email here otherwise please leave it empty<br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"your-email\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-email wpcf7-text wpcf7-validates-as-email\" aria-invalid=\"false\" value=\"\" type=\"email\" name=\"your-email\" \/><\/span><br \/>\n<span class=\"wpcf7-form-control-wrap wpgdprc\"><span class=\"wpcf7-form-control wpcf7-wpgdprc wpcf7-validates-as-required\"><span class=\"wpcf7-list-item\"><input type=\"checkbox\" name=\"wpgdprc\" value=\"1\" aria-required=\"true\" aria-invalid=\"false\" \/><span class=\"wpcf7-list-item-label\">By using this form you agree with the storage and handling of your data by this website.<\/span><\/span><\/span>    <\/span><br \/>\n<input class=\"wpcf7-form-control wpcf7-submit has-spinner\" type=\"submit\" value=\"Submit\" \/><\/b>\n<\/p><p style=\"display: none !important;\" class=\"akismet-fields-container\" data-prefix=\"_wpcf7_ak_\"><label>&#916;<textarea name=\"_wpcf7_ak_hp_textarea\" cols=\"45\" rows=\"8\" maxlength=\"100\"><\/textarea><\/label><input type=\"hidden\" id=\"ak_js_1\" name=\"_wpcf7_ak_js\" value=\"59\"\/><script>document.getElementById( \"ak_js_1\" ).setAttribute( \"value\", ( new Date() ).getTime() );<\/script><\/p><div class=\"wpcf7-response-output\" aria-hidden=\"true\"><\/div>\n<\/form>\n<\/div>\n\n<p>Thank you!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We are very close to launch a new service and we want to have your feedback on how to create this service. So we made a Survey and you can help us by submitting your preference. Thank you! <a class=\"continue-reading-link\" href=\"https:\/\/smartdatamodels.org\/index.php\/vote-for-the-new-sql-service-just-two-questions\/\">More&#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[105,107,109,113,115,119,117,88,143,111,125,182,201],"tags":[],"class_list":["post-9794","post","type-post","status-publish","format-standard","hentry","category-cross-sector","category-smart-cities","category-smart-energy-domain","category-smart-environment","category-smart-manufacturing","category-smart-robotics","category-smart-water","category-smart-sensoring","category-smartaeronautics","category-smart-agrifood","category-smartdestinations","category-smarthealth","category-smartlogistics"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":10091,"url":"https:\/\/smartdatamodels.org\/index.php\/new-service-export-you-data-models-to-sql-schema\/","url_meta":{"origin":9794,"position":0},"title":"New service: Export you data models to SQL schema","author":"maestro","date":"30\/10\/2023","format":false,"excerpt":"We provide a service to Generate a PostgreSQL schema SQL script from the model.yaml representation of a Smart Data Model. You can access this service under this link following Tools > SQL service. You need to provide as input the standard GitHub link to the model.yaml file or the raw\u2026","rel":"","context":"In &quot;Smart Cities domain&quot;","block_context":{"text":"Smart Cities domain","link":"https:\/\/smartdatamodels.org\/index.php\/category\/smart-cities\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2023\/10\/Screen-Shot-2023-10-30-at-17.14.41-300x201.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":7921,"url":"https:\/\/smartdatamodels.org\/index.php\/sql-export-available-for-postgresql\/","url_meta":{"origin":9794,"position":1},"title":"SQL export available for Postgresql","author":"maestro","date":"21\/12\/2022","format":false,"excerpt":"There is a new file 'schema.sql' in all the directories of the data models. It is a SQL script for PostgreSQL. The script creates the structure of a relational table containing the attributes defined in the data model. It also creates the data types for those attributes with an enumeration\u2026","rel":"","context":"In &quot;Cross Sector&quot;","block_context":{"text":"Cross Sector","link":"https:\/\/smartdatamodels.org\/index.php\/category\/cross-sector\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10131,"url":"https:\/\/smartdatamodels.org\/index.php\/new-pysmartdatamodels-package-0-6-3-release\/","url_meta":{"origin":9794,"position":2},"title":"New pysmartdatamodels package 0.6.3 Release","author":"maestro","date":"02\/11\/2023","format":false,"excerpt":"We are thrilled to announce the latest update to pysmartdatamodels Python package, version 0.6.3, featuring a new function: generate_sql_schema()This addition enabling seamless generation of SQL schemas with just a few lines of code! Introducing\u00a0 generate_sql_schemqa() Function: With the new function, generate_sql_schemqa()\u00a0 pysmartdatamodels simplifies the process of creating SQL schemas for\u2026","rel":"","context":"In &quot;Smart Cities domain&quot;","block_context":{"text":"Smart Cities domain","link":"https:\/\/smartdatamodels.org\/index.php\/category\/smart-cities\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10005,"url":"https:\/\/smartdatamodels.org\/index.php\/new-sections-in-readme\/","url_meta":{"origin":9794,"position":3},"title":"New Sections in README","author":"maestro","date":"20\/10\/2023","format":false,"excerpt":"We have introduced several new sections in the README.md for all the smart data models that we've published These are: Links to CSV extensions of example payloads Links to SQL schema Services we designed to help self-contribution Such as in the data model WeatherForecast: Hope you find it useful and\u2026","rel":"","context":"In &quot;Cross Sector&quot;","block_context":{"text":"Cross Sector","link":"https:\/\/smartdatamodels.org\/index.php\/category\/cross-sector\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-18-at-18.32.18-1024x812.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-18-at-18.32.18-1024x812.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-18-at-18.32.18-1024x812.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2023\/10\/Screenshot-2023-10-18-at-18.32.18-1024x812.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":10263,"url":"https:\/\/smartdatamodels.org\/index.php\/metadata-of-the-catalogue-available\/","url_meta":{"origin":9794,"position":4},"title":"Metadata of the catalogue available","author":"maestro","date":"01\/02\/2024","format":false,"excerpt":"Now in the tools menu (currently the last option) you have a complete list of the most relevant links to the assets of the data models compile in the Smart Data Models initiative. You can check in the main menu -> Tools\u00a0 -> Metadata of the data models The information\u2026","rel":"","context":"In &quot;Cross Sector&quot;","block_context":{"text":"Cross Sector","link":"https:\/\/smartdatamodels.org\/index.php\/category\/cross-sector\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10291,"url":"https:\/\/smartdatamodels.org\/index.php\/new-version-of-pysmartdatamodels-package-0-6-4-with-adaptations-to-data-spaces\/","url_meta":{"origin":9794,"position":5},"title":"New version of pysmartdatamodels package 0.6.4 with adaptations to Data Spaces","author":"maestro","date":"26\/02\/2024","format":false,"excerpt":"There is a new version of the python package pysmartdatamodels to use it you have just to type pip install pysmartdatamodels in your system Besides the update in the list of data models it includes two new functions - look_for_data_model that allows approximate searches for a data model based on\u2026","rel":"","context":"In &quot;Cross Sector&quot;","block_context":{"text":"Cross Sector","link":"https:\/\/smartdatamodels.org\/index.php\/category\/cross-sector\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/smartdatamodels.org\/wp-content\/uploads\/2024\/02\/pysmartdatamodels_0.6.4.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/posts\/9794","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/comments?post=9794"}],"version-history":[{"count":1,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/posts\/9794\/revisions"}],"predecessor-version":[{"id":9795,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/posts\/9794\/revisions\/9795"}],"wp:attachment":[{"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/media?parent=9794"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/categories?post=9794"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/smartdatamodels.org\/index.php\/wp-json\/wp\/v2\/tags?post=9794"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}