投稿時間:2023-03-21 22:24:38 RSSフィード2023-03-21 22:00 分まとめ(27件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
Google	Official Google Blog	5 things I learned after running 100 miles with the Google Pixel Watch	https://blog.google/products/pixel/pixel-watch-fitbit-running-review/	marathon	2023-03-21 14:00:00
Ruby	Rubyタグが付けられた新着投稿 - Qiita	Crystal言語でインクリメンタルコンパイルが難しい理由	https://qiita.com/kojix2/items/883433f3f89f178deb1f	crystal	2023-03-21 21:09:50
AWS	AWSタグが付けられた新着投稿 - Qiita	AWS EC2 GPUインスタンスでStable Diffusionを使う	https://qiita.com/nijigen_plot/items/27f8e987dda6aea5836d	awsecgpu	2023-03-21 21:42:32
Docker	dockerタグが付けられた新着投稿 - Qiita	AzureAppServiceにおけるDBパスワードの管理（Docker+Go）	https://qiita.com/kaikusakari/items/ded41def3a53beae00cd	appservice	2023-03-21 21:48:31
golang	Goタグが付けられた新着投稿 - Qiita	AzureAppServiceにおけるDBパスワードの管理（Docker+Go）	https://qiita.com/kaikusakari/items/ded41def3a53beae00cd	appservice	2023-03-21 21:48:31
golang	Goタグが付けられた新着投稿 - Qiita	ChatGPTで開発効率アップ！askiを使ったCLIコードレビュー＆バグ特定	https://qiita.com/kznrluk/items/6d5ecd22c1b19d3e1d56	chatgpt	2023-03-21 21:11:23
Azure	Azureタグが付けられた新着投稿 - Qiita	AzureAppServiceにおけるDBパスワードの管理（Docker+Go）	https://qiita.com/kaikusakari/items/ded41def3a53beae00cd	appservice	2023-03-21 21:48:31
海外TECH	MakeUseOf	The Best Electric Smokers	https://www.makeuseof.com/best-electric-smokers/	electric	2023-03-21 12:30:16
海外TECH	MakeUseOf	iPhone Hotspot Not Working? How to Fix iPhone Tethering	https://www.makeuseof.com/tag/tethering-ios-fix-iphone-personal-hotspot-issues/	learn	2023-03-21 12:30:16
海外TECH	MakeUseOf	The Best Samsung Galaxy S23 Deals: Save $50 With No Strings Attached	https://www.makeuseof.com/samsung-galaxy-s23-deals/	attachedthe	2023-03-21 12:06:44
海外TECH	MakeUseOf	New to Instagram? 9 Top Tips for Newbies	https://www.makeuseof.com/tag/new-to-instagram-top-tips-for-newbies/	instagram	2023-03-21 12:05:16
海外TECH	DEV Community	Creating a SQL generator app with ChatGPT, PostgreSQL, and ToolJet	https://dev.to/tooljet/creating-a-sql-generator-app-with-chatgpt-postgresql-and-tooljet-e2k	Creating a SQL generator app with ChatGPT PostgreSQL and ToolJetIn this tutorial you ll learn how to build a SQL Generator application using ChatGPT ToolJet and PostgreSQL Users can state the kind of data they want to retrieve from the database in plain English sentences then ChatGPT converts them to the appropriate SQL syntax required to fetch the data from the database We ll be using ToolJet for the application interface What is ToolJet ToolJet is an open source low code framework that enables us to build full stack web applications within a few minutes With ToolJet you can create standalone fully functional full stack applications or embed applications into other websites ToolJet allows you to build applications that use relational and non relational databases REST APIs and cloud storage like Google Cloud Storage  AWS S and Minio It is an excellent development tool helping individuals developers and businesses create and ship products faster Before we continueI would be super happy if you could give us a star And let me also know in the comments section ️ What is ChatGPT ChatGPT is the most talked about technology at the moment It is an AI language model trained by OpenAI to answer questions provide information and engage in human language conversations with users ChatGPT performs tasks such as writing debugging and explaining code snippets With its latest language model GPT ChatGPT can accept images as prompts and provides answers based on the given prompt or commands In this article we ll use ChatGPT to generate SQL query syntax from plain English words Before we begin let s set up the application s database Setting up an ElephantSQL PostgreSQL databaseElephantSQL enables us to create a PostgreSQL database on the cloud instead of your local machine Follow the steps below to create a PostgreSQL database Create an ElephantSQL account here Add a new database instance No credit card or billing information is required Once you ve created the database instance your database information is displayed Congratulations You ve successfully created the database needed for this application Next let s design the application interface and connect the database to the application Designing the application interface with ToolJetHere you ll learn how to create a ToolJet account and design a fully functional application with ToolJet If you are new to ToolJet create an account Create a Workspace and a new app called SQL Generator Design a user interface similar to the image below ToolJet enables you to create applications interfaces by dragging and dropping various UI components From the image above I added the following the Table component with columns name and age the Text component that serves as a form label the TextInput component that accepts the SQL query in plain English a read only Text Input component that displays the generated SQL query andtwo Buttons One for generating the SQL query from ChatGPT and the other for executing the query on the PostgreSQL database How to communicate with ChatGPT in ToolJetHere you ll learn how to communicate with ChatGPT via Rest API in ToolJet ToolJet allows us to communicate with external resources or create custom functions via a panel known as Query Panel In ToolJet any function that communicates with either of the following database API cloud storage and runs a JavaScript or Python code is called a Query Setting up an OpenAI accountLog in or create an OpenAI account here Click Personal on the navigation bar and select View API keys from the menu bar to create a new secret key Generate a new API key and copy it somewhere on your computer We ll use it in the upcoming section Communicating with the ChatGPT API in ToolJetOn your Query Panel select REST API and create a POST request to the ChatGPT endpoint As shown in the image above I added the following to the Query Headers variables Content Type application jsonAuthorization Bearer lt YOUR CHATGPT API KEY gt Enable Transformations and copy the code below into the code editor to retrieve the exact response needed from the request const choices data choices return choices message content Click Body enable Raw JSON and copy the code below into the code editor it contains parameters sent along with the POST request model gpt turbo messages role user content Write the SQL query for this operation components textarea value I need only the SQL query No explanations please The code snippet above uses the GPT Turbo model provided by OpenAI and the content variable contains the prompt sent to the ChatGPT API ToolJet allows users to access the attributes and values of each component Hence the components textarea value represents the value plain English command provided by the user PS Yours may not be textarea if so change it to the component s name for the user s input Finally click the Save button So far we ve configured the ChatGPT query Next let s execute the query when a user clicks the Generate SQL Command button From the image above I added an on Click event to the button and the ChatGPT query runs when a user clicks the button It takes the user s input and sends a request for its equivalent SQL syntax when a user clicks the button To display the result update the default value of the read only Text Input component by setting it to queries chatgptQuery data Congratulations You ve been able to communicate with ChatGPT Next let s learn how to connect and communicate with the PostgreSQL database created earlier How to communicate with a PostgreSQL database in ToolJetHere you ll learn how to communicate with a PostgreSQL database in ToolJet First let me walk you through connecting a PostgreSQL database to ToolJet Connecting a PostgreSQL database to ToolJetClick Add a Datasource from the Query Panel on ToolJet select PostgreSQL from the list of databases and provide the required information as shown below From the image above the host is the same as the server name on ElephantSQL excluding the brackets The username and database name are the same and copy and paste the password into its field Scroll down the page and click Test Connection If the connection is verified we can start making queries to the database Communicating the PostgreSQL database in ToolJetHere you ll learn how to send the SQL queries generated by ChatGPT to the PostgreSQL database and view the queried data within the Table component on the user interface Before we begin let s add some data to the database Click on the PostgreSQL query select SQL mode and run the code snippet below to create a new table containing the data below CREATE TABLE People NAME varchar AGE int INSERT INTO People name age VALUES David INSERT INTO People name age VALUES Tabby INSERT INTO People name age VALUES Teja INSERT INTO People name age VALUES Julius INSERT INTO People name age VALUES Kedrick SELECT FROM people You can view the data on ElephantSQL once it has been uploaded Next let s receive the SQL command from the ChatGPT and display the data within the Table component on the user interface Update the SQL editor to contain the query retrieved from ChatGPT and save it Add an on Click event that runs the database query to the Execute button Lastly update the Table component to display the data retrieved from the database Congratulations You ve completed the application for this tutorial Click the Release button and the share icon to host and make the application public Here is the desktop version of the application You can also import this application into your ToolJet workspace by downloading its JSON file ConclusionSo far you have learnt how to add a PostgreSQL database to ToolJetcommunicate with ChatGPT via REST API in ToolJet anddesign applications in a few minutes with ToolJet ToolJet is both an excellent development tool and open source meaning its code is readily available for everyone to modify and improve It has a large community of developers and talented contributors constantly maintaining and improving the software As a user you can be sure of getting the best performance when you use ToolJet Are you interested in contributing to ToolJet Feel free to check out our GitHub repo to contribute and raise issues about ToolJet Thank you for reading	2023-03-21 12:17:27
Apple	AppleInsider - Frontpage News	Apple TV+ beats rivals to 'Maybe Next Time' movie	https://appleinsider.com/articles/23/03/21/apple-tv-beats-rivals-to-maybe-next-time-movie?utm_medium=rss	Apple TV beats rivals to x Maybe Next Time x movieA film of Cesca Major s latest novel made by Reese Witherspoon s production company will stream on Apple TV after the firm outbid competitors Source AdWeekThere are no details of how much Apple TV paid for the project nor even of which other streamers may have been bidding But it is now the latest Apple collaboration with actor producer Reese Witherspoon as Deadline reports the rights were acquired in competition Read more	2023-03-21 12:53:05
Apple	AppleInsider - Frontpage News	Foxconn paying more & getting less than expected with new India plant	https://appleinsider.com/articles/23/03/21/foxconn-paying-more-getting-less-than-expected-with-new-india-plant?utm_medium=rss	Foxconn paying more amp getting less than expected with new India plantFoxconn s previously announced new factory in Bengaluru India has now cleared local government approval ーthough at greater cost and with fewer jobs The Karnataka government approved Foxconn s application at its State High Level Clearance Committee SHLCC on Monday This is the same plan that Foxconn previously announced as representing a million investment in the region with up to new jobs being created Committee reports seen by the Times of India however say that the investment is more than expected at billion rupees or around million It then says that the job opportunities are fewer with the plant expected to create new roles Read more	2023-03-21 12:00:42
Cisco	Cisco Blog	Hybrid Work in the New Atlanta Office	https://feedpress.me/link/23532/16033460/hybrid-work-atl-office	Hybrid Work in the New Atlanta OfficeThe new Cisco Atlanta office shows how Hybrid Work can and should be done This is a great example for financial services clients to model as they engage employees in return to office	2023-03-21 12:00:46
Cisco	Cisco Blog	Answering the Call To Give Back to My Community With Cisco’s Support	https://feedpress.me/link/23532/16033461/answering-the-call-to-give-back-to-my-community-with-ciscos-support	Answering the Call To Give Back to My Community With Cisco s SupportAppDynamics Sales Specialist Jason M makes a difference as a volunteer firefighter in his community Read his story to see how he s making even more impact through his team s support and Cisco s giving back programs	2023-03-21 12:00:39
海外TECH	CodeProject Latest Articles	Avalonia for VB	https://www.codeproject.com/Articles/5357284/Avalonia-for-VB	control	2023-03-21 12:38:00
海外科学	NYT > Science	Earth to Hit Critical Global Warming Threshold by Early 2030s	https://www.nytimes.com/2023/03/20/climate/global-warming-ipcc-earth.html	Earth to Hit Critical Global Warming Threshold by Early sA new report says it is still possible to hold global warming to relatively safe levels but doing so will require global cooperation billions of dollars and big changes	2023-03-21 12:20:41
海外ニュース	Japan Times latest articles	South Korea restores intelligence-sharing pact with Japan	https://www.japantimes.co.jp/news/2023/03/21/national/gsomia-south-korea-japan-restored/	tokyo	2023-03-21 21:21:31
ニュース	BBC News - Home	Ofsted: Head teacher's family blames death on school inspection pressure	https://www.bbc.co.uk/news/uk-england-berkshire-65021154?at_medium=RSS&at_campaign=KARANGA	intolerable	2023-03-21 12:45:18
ニュース	BBC News - Home	Brexit-backing Tory MPs spilt on Rishi Sunak's Northern Ireland deal	https://www.bbc.co.uk/news/uk-politics-65024165?at_medium=RSS&at_campaign=KARANGA	brake	2023-03-21 12:29:36
ニュース	BBC News - Home	Ukraine says Russian missiles destroyed in Crimea	https://www.bbc.co.uk/news/world-europe-65021987?at_medium=RSS&at_campaign=KARANGA	deploy	2023-03-21 12:10:36
ニュース	BBC News - Home	Six Nations 2023: 'A tournament that promised so much - and delivered'	https://www.bbc.co.uk/sport/rugby-union/65026290?at_medium=RSS&at_campaign=KARANGA	Six Nations x A tournament that promised so much and delivered x Over the course of six dramatic weeks the enduring appeal of the Six Nations was there in abundance writes BBC rugby correspondent Chris Jones	2023-03-21 12:02:31
ニュース	BBC News - Home	Manchester United sale: Revised bids for club due on Wednesday evening	https://www.bbc.co.uk/sport/football/65024583?at_medium=RSS&at_campaign=KARANGA	Manchester United sale Revised bids for club due on Wednesday eveningProspective owners of Manchester United are told they have until GMT on Wednesday to submit second revised bids for the club as the takeover saga accelerates	2023-03-21 12:22:07
ニュース	BBC News - Home	Maddie Hinch: GB's Olympic champion goalkeeper retires after 'fairytale' career	https://www.bbc.co.uk/sport/hockey/65023813?at_medium=RSS&at_campaign=KARANGA	Maddie Hinch GB x s Olympic champion goalkeeper retires after x fairytale x careerMaddie Hinch says she was not prepared for the weight of the gold medal after leading Great Britain to their first women s Olympic hockey title in	2023-03-21 12:26:38
ニュース	BBC News - Home	Met Police: Women and children failed by 'boys' club', review finds	https://www.bbc.co.uk/news/uk-65015479?at_medium=RSS&at_campaign=KARANGA	baroness	2023-03-21 12:26:28
ニュース	BBC News - Home	Met 'rotten' 30 years after Stephen Lawrence murder	https://www.bbc.co.uk/news/uk-65025563?at_medium=RSS&at_campaign=KARANGA	mother	2023-03-21 12:49:01