반응형

스티브잡스 아이패드 프레젠테이션 한글자막) Steve Jobs iPad Presentation

https://www.youtube.com/watch?v=oRYFKsnoHx4

반응형
반응형

 

-- ROW_NUMBER 함수를 사용할 때는 ORDER BY를 필수로 사용해야하는데, 의미없는 (SELECT 1)을 부여하여 ORDER BY 없이 조회된 결과의 순번을 부여한다.


SELECT ROW_NUMBER() OVER(ORDER BY sal DESC) AS rownum
     , ename
     , job
     , sal
  FROM emp
 WHERE sal > 2000

-- ORDER BY에 정렬 컬럼을 사용하면 정렬 후 순번이 부여된다.

SELECT ROW_NUMBER() OVER(ORDER BY sal DESC) AS rownum
     , ename
     , job
     , sal
  FROM emp
 WHERE sal > 2000

반응형
반응형

2024년 웹 개발 트렌드

https://thecodework.medium.com/web-development-trends-of-2024-0934aada1711

 

반응형
반응형

TOP 40 Free Flutter Templates 2023

https://cdmrkt.medium.com/top-40-free-flutter-templates-2023-4e282cdd076d

 

Are you an aspiring Flutter app developer? Or an already experienced developer looking for a good template to make your life easier? Then this article is for you both. 2022 has come and the new era of Flutter templates has arrived. Please welcome the new collection of the best free templates. Here you’ll find e-commerce app templates, banking apps, weather apps, and more.

1. Hungry

Do you know the recipe for an ideal app? At Code Market, we know that the perfect app starts with a good template. Because it keeps development time down and increases your chances of success. This is recipe app template that will definitely make you drool. It includes such screens as:

Welcome Page

Bookmarks Page

Delicious Today Page

Explore Page

Full Screen Image Page

Home Page

Newly Posted Page

Page Switcher

Profile Page

Recipe Detail Page

Search Page

And this is not the end. Number two in our menu is 3 Custom Modals. The author of this template tried his best and made this template incredibly cool. You won’t have to worry about the frontend. Just build your backend and bind it to this template. Boom — the application is ready.

Login Modal

Register Modal

Search Filter Modal

And for dessert, 13 custom widgets. Still hungry for other templates? I don’t think so.

2. Travel App UI Design

UI takes a major part of the demand among app templates. This time we suggest you take a look at this awesome free travel app template. The cozy design of this app sets up a pleasant vibe. Using this template in your work you won’t spend a lot of effort, because half of the work is already done for you.

This template is easy to customize. So you can use it not only as a travel app template, but also as a blog, store, whatever comes to your mind.

3. Flutter Wishes App UI Challenge

Ugh, how often have I wanted to save up to study Flutter development, but all the money goes to beer and chips? Countless times. But thanks to templates like these, you don’t just learn how to develop using free templates to practice, you can also make an entire app to save money for your dreams.

The cute pink design is easy to customize. Moreover, this template can be easily implemented in another application, diversifying the interface with extra features.

4. Flutter Food Ordering App UI Template

If building an app were as easy as ordering a pizza… but wait, it’s really that easy if you use ready-made templates to work with. In this set you will find awesome design, minimalistic images on the splash page and a lot of screens. This template will be great for a food delivery app. Write your backend and your application is ready. Because this template already includes:

Profile Page

Search Page

Home Page

Shopping cart Page

Offers Page

Restaurant Page

5. Flutter Bank UI

This is a banking application template with a small backend. In it you can see the balance on the card, the spending for today, a week, a month, or try to make a transaction. The minimum functions that a banking application needs and nothing unnecessary.

6. Shopping App Flutter Template

We’ve already noted that free templates can be a great way to learn how to program and build your own applications. So we suggest you take a look at this shoe store template. It has several screens. Also, such templates clearly show what you need to consider when you create an application. Feel free to customize this template. This will be a new challenge for beginner developers.

7. Flutter Weather App using API with darkmode support

Spring has sprung and I don’t know what’s better, download this template for the weather app or … might be or? Of course download this template, because it contains so many features and it just looks so good. This template includes:

Dark and Light Mode

Weather from API

Icons based on weather from API

Location is based on client IP

Scalable

Performance friendly

Today weather info

Forecast for today

3-day forecast

Dynamic temperature color change based on temperature

Null safety

8. Ecommerance Flutter UI

This is a great template for e-commerce. With it you can significantly reduce the time for frontend development. You can use this template to create Android and iOS apps on Flutter. The UI Kit includes all the resources you need to reuse components, it includes 20 screens, assets, icons and fonts. It is built using the latest version of Flutter with null safety support.

Moreover, it includes such features as:

Clean Code and a well structured project hierarchy

Responsive Design to any all device screen

Fully responsive UI

Best practices for UI & UX

Supports multiple Languages

Dark and light theme

Uses Animation Controllers

Easy to customize

So look at these screens. It’s easy to customize because everything is well-structured, which is a big perk for any template.

Login page with phone number confirmation

Product Page

Search page

Shopping cart

Personal information page

Favorites

Search filters page

and much more.

9. Grocery UI Template In Flutter For Android & iOS

Every person’s diet must include fruits, and every developer’s daily ration must include the grocery template. This template is User Friendly, easily customizable and includes multiple screens. This means that using this template will be helpful for your work time.

10. bwa_chat

Communication is the keystone to world domination. While using templates is key to a successful career as a developer. This chat is a great start to developing your own app. You can use it as a complete application or integrate it into another one.

11. Cryptospace

Modern design for a modern crypto wallet. Cryptocurrencies are evolving and soon will become another handy means of payment.

You can use this app template to develop a cryptocurrency wallet app or a modern banking app and more. Each user of your app will get their own wallet. The wallet is secure and every time the app is opened, authentication is required to access it. That’s why the template adds an authentication feature, which is done with a fingerprint, face authentication, or pin code. The template has the following functions: conversion of tokens with minimal commissions, replenishing the wallet, receiving or sending cryptocurrency, viewing the history of transactions. Your future app will also provide the ability to view the latest information about bitcoin and other cryptocurrencies.

12. Travel app

Traveling is always a pleasure, but doing it in comfort is even more enjoyable! There are many travel apps but they all have their disadvantages. Maybe you’ll make the perfect one? Who can tell? That’s why we offer you a travel app template. This template will save you time developing an entire app, and keep your energy, in order to make your app incredibly high quality.

13. Clima

If the clouds are over your head, it’s time to create a weather app. Let the sun always shine on you with the Clima template.

This is another handy and easy-to-use app template. You can add it to your app so your users can watch the weather. It’s suitable for apps with city events or as a standalone app.

14. Movies App

For fans of movies and TV series we have prepared this Movies App template. With this template, you’ll have your app done faster than you finished watching season two of Euphoria. Check out these great screenshots with minimalistic but cool User Friendly design. It will definitely save your work time and bring you joy if you use this template.

15. Best-Flutter-UI-Templates

The author of this template has collected three UI’s in one kit. It’s a great start for the developer. You can get three in one and create much more applications if you use parts of this template in your own job.

Also, pay close attention to the design and animation. It deserves your likes.

16. Shope — Free Flutter eCommerce Template

The e-commerce app is like a litmus test for app developers. Your portfolio should definitely include your e-commerce application, which will show the level of your coding skills. Are you just developing an e-commerce app? Well, let me help you save you time with front-end development. The author of this template made an effort and created 38 screens with a cool design, which can be quickly and easily customizable. Clean and structured code makes it stand out noticeably among other templates.

17. Fwitter — Twitter clone in flutter

All opinion leaders have Twitter feeds. But there is someone more powerful. Someone who could block a sitting president’s account if he wanted to. Become that person by developing your own Twitter app.

If you like this template, don’t forget to buy coffee for the author. He will need the coffee when he makes his copy of TikTok.

18. Flutter Smart Home UI

The history of the smart home began in 1961, when Joel and Ruth Spira created and patented a special device for continuously adjusting the light — a dimmer.

But did they know back in the 1960s that the entire house would be controlled by a single app on the phone? Moreover, the term “smart home” appeared already in 1984. They couldn’t have imagined it. However, I would like to show you a smart home control app template. Its pleasant design in itself sets you up for chilling.

With this template, you can control the air conditioner, lights and washing machine in your house without leaving your bed. Don’t you agree it’s handy? Moreover, it is even more convenient to work with this template, because it is perfectly made for all needs of developers.

19. Flutter Social App Concept

Is it Twitter? Is it Facebook? No, it’s your own social network. Using this template, you can easily set up your own communication app. 12 screens with a simple and easily customizable design will keep your work time short. Add different languages, a native VPN, and your app is ready.

20. Dashboard Reborn

Thinking of an original project, but don’t know exactly where to begin?

We advise you to take a closer look at this template. You can use it as a separate application, or add it as part of something bigger in your own project. This is a note-sharing application template. Ui is well detailed and equipped with animations. Nicely assembled code will make it easy to customize and modify it without any losses. Think about it.

21. Restaurant App UI KIT Flutter template app

I like to read reviews before going to a restaurant, or read the menu in advance. This is a very useful feature in modern reality, because you will definitely never make a mistake. This kit can be used to create applications faster to save your time. There is nothing unnecessary in this template, the code is completely clean. The template is easy to customize, you can change the objects as you require. Also, the template is created in a dark and light style, which has become the most relevant recently among all applications.

22. Swiggy Restaurant APP UI Kit template app

Another useful app that brings restaurants closer to consumers. When the Cavid-19 pandemic began, the titans of the delivery services stood up to protect psychological health and the national economy. So this Flutter template can also be your savior, with it you will save time, because you won’t have to create everything from scratch.

There are more than 20 screens in this set that you can easily customize as you want. A clean code and a detailed description will allow you to understand the structure of this template, even if you don’t have any knowledge in the field of coding.

23. Flutter Folio — mobile (ios, android), desktop (windows, macos, linux), web template app

This is not just a template, it is a template for getting experience in working with Flutter. If you are a beginner Flutter developer or designer, then this will be a great opportunity to try Flutter as a tool. This application works for all operating systems and it is very easy to install, so that any user can handle it. You can train yourself in creating a website, fill your hand, and then send the link to your friends or family.

24. Gif Finder Using GIPHY API template app

Gif is a bitmap format for graphic images. Gif finder is a convenient way to search for images. Sometimes ordinary emojis are not enough to express your emotions, and then GIFs come for help. This format for transmitting emotions, humor, or just cute pictures with cats has become so popular that now with this template, you can put the search for GIFs in your own messenger.

25. Flutter Travel App Concept

This template is appropriate for any operating system, therefore, using this template is as easy as booking a hotel room. But we remind you that to work with Flutter templates, you need some knowledge in the field of programming. In order to use this template properly, you need to have a good understanding of Dart.

26. Flutter Task Planner App Design

After long holidays or just some failures, it is always difficult to start active work. There are several motivational theories to beat procrastination, but I believe that the most effective solution is the user-friendly Task Planner App.

With this app, it’s possible to view, schedule and manage tasks as well as see projects that are being worked on. The nice color palette of this design perfectly copes with its task-it pleases the eye, but does not distract from the really important things.

Be careful, this is only a design. No backend.

27. Flutter eBook App

Useful reading (reading good books) expands a person’s horizons, enriches his inner world, makes him smarter and has a positive effect on memory. Reading books increases a person’s vocabulary, contributes to the development of clearer thinking, which allows you to formulate and express thoughts more lucidly. It also has a great effect on the sense of humor, which in the modern world is put on a par with the ability to communicate.

So, that’s why, applications for reading books are most relevant in today’s reading society. Apps like Apple Books, Amazon Kindle, or Bookmate have been on the market for a long time and show excellent results. This template is in no way less than the book giants.

Everything brilliant is quite simple. Like this template. There is nothing superfluous in the interface. Books are downloaded from public domain sources. Users of the app can read online or download books to use the app, for example, in flight. The app also has a dark mode to make it easier to read at night.

28. Flutter Tip Calculator App Source Code

If you often go to restaurants with friends, then you are probably tired of the frequent calculation of tips for a general check. It is for this case that the tip calculator template was developed. Very simple, fast, and most importantly convenient.

29. Flutter Foody bite

For gastronomic aesthetes, an application template for finding restaurants and cafes has been developed. Using the function of division into categories, you can easily find something that will suit your taste. Bon Appetit!

30. FlutterFurnitureAppUI

There is such a science as ergonomics — this is the science of convenience, about the organization of the working space for a comfortable and effective work of the employee, based on the physical and psychological characteristics of the human body. In today’s world of freelancing and distance learning, ergonomics is becoming a part of everyone’s life. After all, it is very important that your workspace meets all the requirements of this science.

Therefore, not only the furniture should be comfortable, but also the application for its purchase. This template is made extremely comfortable. With a little knowledge of the Dart language, you can easily customize this template and make a quality product for your consumer.

31. FlutterGrocery-ShoppingAppUI

Grocery stores have long migrated to the web. Instead of hauling heavy bags home, it’s much easier to order a delivery. And also just don’t create the app yourself from scratch, but use a template. Moreover, the author of this template reports that only a couple of fingers are needed for successful use.

32. Flutter login kit

Sometimes one finished piece of work can make life much easier. So I recommend you take a closer look at this login template. In a ready-made application, the login is the first thing the user sees, so you can’t make a mistake here. Trust the professionals and ready-made solutions to your problems!

33. FLUTTER TODO APP

This application is perfect for everyone who does not sit on the neck of their parents, and earns honest work. The built-in calendar lets you schedule events, set reminders, and make you more efficient day-to-day. If you are concerned about the issue of procrastination in the world, and you want to create your own convenient application for tracking tasks, then this is your choice!

34. FLUTTER NEWS MOBILE APP

News doesn’t stay fresh for long.That is why you need an app that will keep the whole world in the center of events. Whether it’s sports news, politics, or just a forecast of an impending storm. In today’s world, it is important to be one step ahead. And with this template, you will be one step ahead of your competitors! After all, while they are developing their app, your app is already working for you!

35. Flutter-movies-app

What movie should I watch tonight? It’s not on Netflix, and it’s not on HBO. So everything will be in your own streaming service!

36. E-commerce-Complete-Flutter-UI

Probably everyone has ever thought of creating their own brand or clothing store, so that they no longer spend hours looking for the perfect pair of trousers in the shopping center. But not many people succeeded. But if you are one of those lucky ones, then you probably need a stylish and user-friendly e-commerce app. I strongly recommend that you use this template to start active sales as soon as possible!

37. Flutter_ecommerce_app

Another awesome, free and very beautiful template for an ecommerce app. Bright colors are perfectly complemented by a white background, on which any thing will look even more attractive.

38. E-commerce-App-UI-Flutter

Everyone can sell products, but not everyone can do it nicely! This template is made quite original. Here everything is taken into account so as to show the product at the right angle. The main feature of this template is that the background of each product favorably emphasizes the color and texture of the product itself.

39. Flutter firebase shopping app

This is the most versatile template for e-commerce. With this template, you can sell anything from club T-shirts to car parts. The concise design does not distract with flashy colors or pictures from the products, so that the customer can easily navigate in the app. This template is for those who know what they need!

40. Flutter-Blog-App

Green in psychology today means growth, development, prosperity, stability, new beginnings. Therefore, it is perfectly suitable for the design of a blog application. Learn new things, live long and prosper.

41. Watermaniac — Flutter template

As I said, this article will be updated with new templates. And here are a couple of new products especially for you.

This template consists of Dart, as we are all made of water. And with this template, you will not forget to drink the right amount of water while you are developing your applications. If you, like me, care about the health of everyone around you and you want to be a useful person for society, then feel free to download and launch your water counting application!

42. Analog Clock Light & Dark Theme

Time flies so fast that you can’t keep track of it. But this template will help you make this process more stylish! Check it out!

반응형
반응형

https://www.etnews.com/20231219000152

 

[스페셜리포트] 디지털 시장 혁신 저해 우려에도 플랫폼 규제 강행, 업계 '망연자실'

“미국 구글로 검색하고, 마이크로소프트(MS)의 생성형 인공지능(AI)과 상담하고, 중국 알리익스프레스로 필요한 물건을 구매하는게 일상이 되도록 만들겠다는 정부가 정말 우리나라 정부가 맞

www.etnews.com

“미국 구글로 검색하고, 마이크로소프트(MS)의 생성형 인공지능(AI)과 상담하고, 중국 알리익스프레스로 필요한 물건을 구매하는게 일상이 되도록 만들겠다는 정부가 정말 우리나라 정부가 맞습니까. '공정함'에만 매몰돼 해외 기업에 국내 시장 빗장 열어주는 '호구'가 되는 것을 자처하겠다는 정도입니다. 이는 정부가 내년 총선을 앞두고 소상공인 표심을 얻기 위해 미래 디지털 경제와 플랫폼 기업을 버리는 행위입니다.”

공정거래위원회가 19일 추진을 발표한 '플랫폼 공정경쟁 촉진법'에 대한 플랫폼 업계 관계자들의 공통된 반응이다. 플랫폼 업계는 공정위의 새로운 규제 발표에 당혹스러움을 감추지 못했다.

 

◇국내 플랫폼 기업에 '제초제', 혁신기업 성장 막는 '악법' 될 것

플랫폼 업계 관계자들은 이구동성으로 공정위의 플랫폼 공정경쟁 촉진법이 기업의 성장을 막는 제초제이고 혁신기업의 성장과 투자와의 연결고리를 끊는 악법이 될 것이라고 우려했다.

익명을 요청한 한 플랫폼 기업 관계자는 “정부의 자율규제 방침 속에서 나온 사약과 같은 과도한 사전규제라서 당혹스럽다”라며 “설명회 등 업계 의견수렴 절차도 거치지 않고 너무 갑작스럽게 공정위가 안을 만들어서 나온거라 많은 문제가 발생할 것으로 보인다”라고 말했다.

이 관계자는 “우리나라 플랫폼 기업은 이제 글로벌 기업과 경쟁하고 있는 상황이고, 유튜브가 우리나라를 장악한 것은 유튜브 대적할 플랫폼이 없었기 때문”이라며 “몇 안되는 플랫폼 기업이 글로벌 시장에서 경쟁을 펼치고 있는데 이들을 지배적 플랫폼으로 규정해 옥죄겠다는 것은 이해할 수 없는 방침”이라고 말했다.

또 다른 플랫폼 기업 관계자는 “플랫폼 비즈니스가 절대 악이 아닌데 마치 악인 것처럼 몰고가는 정부의 행태가 납득이 되지 않는다”라며 “자국 플랫폼 기업을 키우며 플랫폼 제국주의 형태를 보이고 있는 글로벌 시장은 보지 않고 선거 표심에만 매몰돼 합리적인 판단을 내리지 못하는거 같아 안타깝다”라고 말했다.

이 관계자는 “가장 큰 문제는 정부가 스타트업과 소상공인을 배려해 공정한 경쟁을 위해 규제를 만든다지만, 정작 스타트업이 유니콘이되고 대형 사업자가 될 수 있도록 투자 받고 성장하는 길을 가로막는 법이 될 것이라는 점”이라고 꼬집었다.

◇무한 경쟁 플랫폼 시장에 국내 기업 역차별 우려

국내 플랫폼 시장은 글로벌 플랫폼 기업들과 무한 경쟁 상황에 놓여있다. 공정위가 추진하는 법안은 몇 개의 국내 플랫폼 기업을 타깃으로 한 것으로 보이며, 해외 빅테크와의 치열한 경쟁 속에서 국내 산업 경쟁력 악화를 초래할 것으로 예상된다.

국내 시장은 구글(검색엔진), 넷플릭스(OTT), 메타·인스타그램(SNS), 알리익스프레스(쇼핑) 등 해외기업들의 시장점유율 확대는 물론 일부 산업에서는 이미 시장을 잠식당하고 있는 상황이다. 국내 산업 보호를 위한 지원정책이 마련돼야 할 때에 오히려 과도한 규제 도입으로 국가 경쟁력 자체가 위협을 받을 수 있다.

해외 사업자와 국내 사업자 간 규제 형평성에 대한 고민이 없다면, 공정위가 추진하는 법안은 자국 플랫폼에만 과한 규제를 적용할 우려가 클 것으로 전망된다. 특히 이미 해외 빅테크들의 디지털 활동이 활성화된 시장에서 우리나라 기업의 성장에 캡을 씌우게 되는 등 산업 악영향이 걱정된다.

과거 사례를 비춰볼 때 정부의 플랫폼 기업 규제는 항상 국내 기업들에게만 엄격하고 해외 기업들은 규제하지 못하고 질질 끌려가는 모습을 보여왔다. 이번 플랫폼 공정경쟁 촉진법 역시 만들어지면 국내 플랫폼 기업이 새로운 혁신 사업을 추진할 때마다 걸림돌이 되고, 그 사이 국내 규제를 무시하는 해외 기업들이 세를 넓히도록 하는 역할을 할 것으로 보인다.

새로운 법이 입증 책임을 사업자에게 돌리는 것 외에 현행 공정거래법 등 기존 법령과 차이가 있다고 보기 어렵다는 것도 문제로 지적된다. 국내 플랫폼기업이 시장 지배력을 남용하거나 불공정 거래하는 경우 기존 공정거래법으로 충분히 제재 가능하다.

업계는 국내 거래금액이 200조원이 넘는 온라인 커머스 시장은 사실상 완전경쟁 상태로 특정한 온라인 플랫폼이 지배력을 남용할 수 있는 상황이 아니라는 주장이다. 단순히 매출액과 이용자 수 규모 등으로 사업자를 사전 지정하는 형태로 규제를 도입하겠다는 것은 경쟁제한성 판단 등을 전제로 하는 현 공정거래법과도 다른 방향이다.

◇미국·중국 자국 플랫폼 우대, 유럽·일본은 플랫폼 규제

미국과 중국 등 빅테크를 보유한 국가에서는 플랫폼 기반 AI 분야 경쟁력이 국력이라는 판단하에 자국 플랫폼 규제를 없애고 진흥책을 펼치고 있다. 올해 미국 의회에 발의된 빅테크 규제 법안 6개 중 5개가 폐기됐다. 빅테크에 대한 강도 높은 규제가 예상됐으나, 틱톡·핀둬둬 등 미국 내 중국 플랫폼의 선전으로 인해 AI 기술 패권에 대한 위기감 생성되며 자국 빅테크 기업 보호로 선회하고 중국 기업을 압박하고 있다.

중국은 자국 플랫폼 기업 지원책을 고심하고 있다. 최근 '플랫폼 기업의 발전 및 고용, 국제 경쟁력 확보 추진'을 선언 등 미국 기업과 AI 기술 경쟁에서 뒤지지 않기 위해 자국 기업 키우기에 열중하고 있다. 중국 내 챗GPT 형태의 AI를 개발 중인 기업은 바이두·알리바바 등 12개에 달하며, 틱톡 등을 통해 공격적으로 수집한 학습데이터를 기반으로 미국과 격차를 좁히고 있다.

유럽은 미·중 빅테크에 대한 포괄적 사전규제를 위한 디지털시장법(DMA)을 시행했다. DMA는 시가 총액, 유럽경제지역 내 매출 규모, EU 내 월간 사용자 수 등 여러 기준 중 일정 요건을 충족하는 플랫폼 기업을 '게이트키퍼'로 지정해 규제한다.

대표적인 적용 대상은 구글·애플·아마존·페이스북·틱톡 등이다. 일본 역시 애플 앱스토어 및 구글 검색 서비스에 대한 규제 방안을 논의하고 있다. 지난 2021년 빅테크에 거래 조건 등 정보 공개 의무화를 한 '디지털 플랫폼 거래 투명화법'에 이은 제2의 글로벌 빅테크 규제다.

플랫폼 기업에 대한 규제를 만든 국가들의 공통점은 자국 플랫폼 기업이 존재하지 않는다는 점이다. 전문가들은 유럽에서 DMA법을 제정한 배경을 '브리쉘 이펙트'라고 해석한다. 자국 플랫폼 기업이 없기 때문에 규제를 통해 미국과 중국 빅테크를 견제하기 위한 방식을 채택했다는 것이다. 이런 상황에서 토종 플랫폼 기업을 보유한 우리나라가 DMA법을 벤치마킹해 규제를 신설한다는 것은 앞뒤가 맞지 않는 선택이다.

반응형
반응형

이처럼 코슬라벤처스의 투자는 창업자를 최우선으로 두고, 그들이 직접 만들어가는 베팅에 투자합니다. 미래를 예측하는 가장 좋은 방법은 직접 그 미래를 만드는 것이다라는 말. 기억하시나요? 코슬라벤처스의 투자가 그런 전략을 취합니다. 실패 가능성이 90% 라고 하더라도 100배의 수익을 거둘 확률이 10% 라도 있으면 투자하는 것이 코슬라벤처스의 투자스타일입니다.

 

비노드 코슬라는 최근 자신의 X 계정을 통해서 아래와 같은 미래 예측을 내놓았는데요. 이 중 상당부분이 코슬라벤처스가 투자한 스타트업이 만들어가려고 하는 미래에서 나온 예측입니다.

 

  1. AI가 교사, 의사, 변호사 대체
  2. 코딩을 못해도 프로그래머가 된다
  3. 이족보행 로봇이 100만대 생긴다
  4. 도시의 차량이 자율주행차로 바뀐다
  5. 음악과 엔터의 초개인화
  6. AI 에이전트로 인터넷에 접속한다
  7. 새로운 원자재가 더 많이 발견된다
  8. 화력 발전소(탄소배출)가 사라진다
  9. 뉴욕-런던 90분 초음속 비행기
  10.  동물 단백질이 사라진다
  11.  탄소배출 문제가 해결된다
 
어떠세요? 미라클레터를 많이 읽으셨다면 그렇게 새로워보이는 전망은 아닐 것 같은데요. 자세한 건 그의 X 계정에서 읽어보시길 추천해 드립니다. 

 

https://stibee.com/api/v1.0/emails/share/2X1YUi___E8nABk00YTnZv11W-j6BnI

반응형
반응형

GitHub Arctic Code Vault

https://www.youtube.com/watch?v=fzI9FNjXQ0o&t=1s 

 

The GitHub Arctic Code Vault is a data repository preserved in the Arctic World Archive (AWA), a very-long-term archival facility 250 meters deep in the permafrost of an Arctic mountain. The archive is located in a decommissioned coal mine in the Svalbard archipelago, closer to the North Pole than the Arctic Circle. GitHub will capture a snapshot of every active public repository on 02/02/2020 and preserve that data in the Arctic Code Vault. For more information on the GitHub Arctic Code Vault, and the other archival projects GitHub is working on, visit https://archiveprogram.github.com/

반응형
반응형

 

 

 

1. 테이블의 생성과 동시에 데이터까지 모두 복사하는 방법

 

SELECT * INTO [생성할 테이블명 ] FROM [원본 테이블명]

기본적으로 테이블과 동시에 데이터까지 복사하는 방법이다.  

 

2. 테이블을 생성할 때 원하는 컬럼만 복사하는 방법

 

SELECT [원하는 컬럼명] INTO [생성할 테이블명 ] FROM [원본 테이블명]

내가 원하는 컬럼만 복사하여 테이블을 만들때 간단하게 해결이 가능하다. 

 

3. 테이블을 생성할 때 테이블 구조만 복사하는 방법

 

SELECT * INTO [생성할 테이블명 ] FROM [원본 테이블명] WHERE  1=2

테이블을 복사할 때 테이블에서 테이터는 없이 테이블 구조만 복사할 때는 'WHERE  1=2'와 같은 쿼리를 실해시키면 테이블의 구조만 복사할 수 있다.

 

4. 테이블은 이미 있고 데이터만 복사하는 방법

 

INSERT INTO [ 데이터를 넣을 테이블명 ] SELECT * FROM [원본 테이블명]

테이블은 이미 있고 그 테이블에 데이터만 복사하고 싶을 경우에는 위와 같은 방법으로 데이터를 넣을 수 있다. 

 

5. 이를 응용해보면 아주 유용하게 사용할 수 있다.

 

INSET INTO [데이터를 넣을 테이블명](컬럼1, 컬럼2) SELECT 복사할 컬럼1, 복사할 컬럼2 FROM [원본 테이블명] GROUP BY 컬럼1

출처: https://dongpal.tistory.com/10 [dongpal's story:티스토리]

반응형

+ Recent posts