The integration helps organizations significantly accelerate their Mean Time to Resolution (MTTR) by delivering turnkey remediations with automatic code generation. By leveraging Amazon Bedrock, Orca effectively operates as a security co-pilot,

Orca Security Announces Generative AI Integration With Amazon Bedrock

a principal at Deloitte who leads the firm’s Government and Public Services (GPS) Infrastructure and Capital Projects activities. Deloitte is a global management consultancy that provides technology, strategy and operations and human capital consulting ...

Governments installing digital safeguards that shield infrastructure from cyber criminals

NEW YORK, Oct. 31, 2023 /PRNewswire/ -- BreachLock, a global leader in Penetration Testing as a Service (PTaaS), penetration testing services, and EASM, is honored to be mentioned again by Gartner Research in its 2023 'Gartner® Emerging Tech Impact Radar: Security' report for two of the technologies that are advancing exposure management programs.

BreachLock Mentioned in New 'Gartner® Emerging Tech Impact Radar: Security' Report for Exposure Management

Schumer's AI insight forums are meant to keep the momentum going and inform legislation. Schumer and the colleagues he's tapped to keep work bipartisan — Sens. Todd Young, Mike Rounds and Martin Heinrich — went to meet with Biden at the White House on Tuesday to discuss the path forward for an AI bill.

Inside Schumer's workforce and high-impact AI forums

The personnel agency is also gearing up to recruit AI workers into the government as part of a talent surge called for in the recent AI executive order.

OPM head previews coming cyber and IT hiring flexibilities

I’ve been working with computers for ages, starting with a multi-year stint in purchasing for a major IBM reseller in New York City before eventually landing at PCMag (back when it was still in print as PC Magazine). I spent more than 14 years on staff ...

TP-Link Archer BE800 BE19000 Tri-Band Wi-Fi 7 Router Review

Having pretty much rewritten the bang for your buck rulebook in the UK this year with its incredible value mini LED C845K/C841K range, TCL is now out to take the fight to the cheaper end of the TV market too with two new wallet-friendly 4K HDR series.

TCL Launches Two New Ultra-Affordable 4K UK TV Ranges

Oklahoma lawmakers are struggling to regulate the artificial intelligence industry even as interest in the technology and its availability continues to grow.

Oklahoma lawmakers struggle to tackle artificial intelligence regulations

Hello, and welcome to the Future of FLYING newsletter, our weekly look at the biggest stories in emerging aviation technology.

Is China the Top Dog in eVTOL?

U.S. District Judge M. Casey Rodgers, in Pensacola, Florida, ordered claimants in 3M's $6 billion combat earplug settlement to beware of a fraudster who has accessed Social Security numbers and other personal information online.

'This Is A Scam': Judge Issues Warning to 3M Earplug Settlement Class Members

Custom software development consulting company

Archer Software

The use of mobile apps is increasing, and the demand for app development is contributing to its growth. For example, of e-commerce sales will take place on a mobile device. And, this high demand is not only related to e-commerce. Statista estimated that by the end of 2021, 73% Mobile app demand is also growing because of a very competitive marketplace. Consequently, mobile app development is in its major growth stage, and there needs to be a better way to build apps faster and more efficiently. In mobile app development, the main challenge for developers is whether the app should be built for native or cross-platform frameworks. The best way to solve this dilemma is to actually test both of them using the Kotlin Multiplatform approach. Teams can easily synchronize and deliver apps for different platforms simultaneously with this method. What is Kotlin Multiplatform? Kotlin is a multiplatform language for building mobile apps so developers can write code that can be used on multiple devices including Android, iOS, and the web. Kotlin Multiplatform is a new approach for development teams to build a single user flow for several operating systems or devices. Applying Kotlin Multiplatform can reduce time and costs by 30% or more. The app market is increasing, and users are becoming more demanding regarding the quality of apps. Startups are always struggling to launch their product on time and on budget, and building an application for Android, iOS and the web can triple expenses and time. Kotlin Multiplatform offers the opportunity to create a universal code that works on all of these platforms. Let’s discuss how the works, and what the challenges of using it are. Kotlin Multiplatform approach What are the key problems in synchronization? Even though Kotlin Multiplatform reduces the time it takes to develop an app, it’s still challenging to develop an app using multi-team app development. Building multiplatform apps means you need a team where developers have different experiences, and different platforms shouldn’t interact in the process of building the final product. Here are some of the main challenges: Different experience needed The main problem of using Kotlin Multiplatform is that you need to use different approaches to solve one problem. It is necessary to gather a team with diverse expertise. Different devices offer users different experiences, and several teams of developers can come up with different ways of solving the product requirements. Communication within the teams Another challenge is to gather a team where developers have different skills and expertise. While creating multiplatform approaches with the help of different teams, communication is a big challenge. For example, two different teams can create an application for different operating systems, and the customer may change the development requirements for one team, and leave them as-is for the other. This can lead to conflicting results. Each platform has specific challenges When you are building multiplatform apps, each of the operating systems has specific requirements especially, for the user interface, as it is necessary to match the design of the devices for a specific operating system. When developing each platform you need to use specific languages, frameworks, and libraries for each platform. The challenge is to build the same app, with a similar design while taking into account different frameworks, etc. Advantages and disadvantages of cross-platform solutions As far as possible cross-platform application development, there are only a few solutions like React Native, Flutter, and Kotlin. In recent years, Kotlin has become very popular because Google announced support for the language on Android as well as Spring Boot 2 that is offered by Kotlin support. Kotlin is running in JavaScript, native, and iOS applications. So, Kotlin helps to share the code between them. Development is carried out in the Kotlin language in IntelliJ IDEA or Android Studio, which is a big advantage when compiling the resulting code in native languages for each platform (i.e.OBJ-C, JS and JVM). The build system is Gradle. It supports groovy syntax and Kotlin script (kts). Kotlin MPP has the concept of the target platforms. In these blocks, the operating systems we need are configured in the native code and compiled in Kotlin. Source sets, as the name suggests, provides the source code for the platforms that are stored here. Advantages of using such an approach include: Saving time and money. When you use Kotlin Multiplatform for mobile and web development, you are going to save around 30% of the time needed for development. This means you will cut expenses by 30%. Compared to Java, Kotlin can cut 40% of the code, so you save money as long as you don’t need to pay for more developers. Native-like solution. The code in Kotlin is similar to Swift as well as being 100% interactive with Java. Fewer bugs. Thanks to Kotlin, you will get the most accurate code, and while some bugs emerge, it’s very easy to find and fix them before runtime. Team productivity. Your team will be working on the same task so this can help keep tasks efficient. Disadvantages are: Kotlin is very useful if you want to reduce cost and time. But it’s costlier and more time-consuming when it comes to learning Kotlin. The transition to Kotlin can be challenging for your team as they need to spend time learning it. Some limitations of using it. One of these limitations is multithreading. It is based on Coroutines technology which isn’t supported in Swift. Lack of experts in the market. Kotlin requires very high expertise in different areas, and it’s much easier to find a Java or Swift developer than those who work with Kotlin. The main problem is that you can’t easily replace Kotlin developers since the technology isn’t as widely used as native programming languages. How Kotlin Multiplatform can come in handy According to TechCrunch, just two years ago at the I / O 2017 conference, support for Kotlin in its IDE, Android Studio. This came as a surprise, given that Java remained the language of choice for developing Android applications for a long time. Google announced Over the past two years, the popularity of Kotlin has increased. More than 50% of professional Android developers use the language to develop their apps, according to Google. It looks like Google is increasing its support for Kotlin. “The next big step that we’re making is that we’re going Kotlin-first,” , an engineer on the Android UI Toolkit development team at Google. “We understand that not everybody is on Kotlin right now, but we believe that you should get there,” Haase said. “There may be valid reasons for you to still be using the C++ and Java programming languages and that’s totally fine. These are not going away.” said Chet Haase While sharing the same code between platforms, you can create a common module that depends on the Kotlin library. In case we need to access platform-specific APIs, like DOM in JavaScript or File APIs in Java, the best solution is platform-specific declarations. It means that in our shared module, we use a keyword to declare the implementation of a different method separately on each platform. Wrapping Up Kotlin Multiplatform development is a great choice for saving time and budget. This is a good approach where you can use common code for the different operating systems of the apps that will be used on different devices. The main benefits of using Kotlin Multiplatform are the ease of sharing one code for multiple platforms, reduced costs and time by around 30%, and there is no need to hire extra staff to implement Kotlin, which significantly reduces time as there is no need to build Android, iOS and web apps with different codes. The main pitfall is that it’s hard to find highly-qualified professionals who can deliver high-quality Kotlin Multiplatform apps, but as the technology develops so will the specialists.

How to Sync Mobile Development Teams with Kotlin Multiplatform

Lean production is not a new concept. It comes from the manufacturing industry and was polished by Toyota in the seventies. However, Lean manufacturing principles turned out to be so practical and universal that they can be used to create innovations in other industries as well. In the Information Technology (IT) sphere, they are frequently used with the Six Sigma Principles, and in this article, we will explain what each principle means for Lean software development. 7 Lean Principles and How to Use Them in Software Development Lean manufacturing and Lean software development are based on the seven pillars. All these principles were developed according to the idea that everything that doesn’t add value to the customer should be avoided or removed. Here is how the principles work in IT. 1. Eliminate Waste Waste elimination is a classic manufacturing problem. But what is t waste? In order to answer this question, it is necessary to return to the key idea that everything that doesn’t add value is waste. It can be: lean software developmen It is not wise to create a specific function until it is claimed. This approach also underlies minimum viable product (MVP) development and subsequent testing of each new feature. Unnecessary coding: This is a case where a task is waiting for somebody to perform it. In other words, this is non-value added time and is time the customer doesn’t want to pay for. Wait-time: When the programmer finishes a piece of code but hasn’t transferred it to the tester, for example. Agile software development partially solves this issue. Delays in task transferring: 2. Build Quality In This principle focuses on the being created and suggests that it is necessary to: quality of the product when the skills of one team member complement the skills of another. Use pair programming . However, this does not always automatically produce quality improvement. Sometimes manual work is a more reasonable solution. Automate routine tasks context switches, knowledge gaps and lack of focus. Reduce downtime, when the code is written according to certain criteria. This eliminates the need for bug fixing, and hence, the waiting time mentioned above. Use a test-driven approach 3. Create Knowledge According to this principle, the development team is encouraged to create and share knowledge in a convenient format. For example, it can be knowledge sharing sessions, document writing or even storytelling. The main thing is to transfer valuable insights from one team member to others to make sure that the same mistake will not be repeated, provoke waste, spoil the quality and/or badly affect the delivery speed using the 7 Lean principles. 4. Defer Commitment It is very easy to confuse this principle with an attempt to transfer responsibility to someone else. However,  the essence of this principle is different. This principle suggests that we do not need to make any final and far-reaching decisions until we have comprehensive and sufficient data. But it is necessary to keep your eyes open and be prepared for change. According to this approach, the team must constantly collect new information, as well as take business requirements into account, which can change at any time. Does this principle remind you of something else? Yes, this is one of the main ideas of Agile development. 5. Deliver Fast This principle also has a pitfall for IT and is closely interconnected with other principles as well. The Lean system does not mean continuous work for a high-tech solution. Deliver fast does not mean deliver at all costs. The basis of this principle is speed multiplied by simplicity. In this case, we again return to the MVP approach, when it is necessary to quickly develop a simple, but high-quality solution, test the feedback at the same speed and then move on to the development of new functions if the market requests them. In this context, the speed of market launch becomes key, and the market need is a reference to the first principle. Do not create a feature until you are asked for it. 6. Respect People This is a basic, but rather universal principle which also determines the success of a team. Human relationships cannot be excluded from the process even with remote work, . The Lean methodology suggests adhering to the rules of effective communication, healthy debate and conflict, and professional ethics when hiring, onboarding and firing employees. 7. Optimize the Whole Instead of Single Parts To understand this principle, it is necessary to imagine each of the work processes as a value stream. This flow can go in the right direction and carry value, or it can create a vicious circle. Here is an example of a vicious circle: When developers are forced to write code too quickly, they make more mistakes. More bugs mean more work for testers. More work for testers means more issues found and more mistakes for the developers to fix under the pressure of time. This is an example of the misuse of the Deliver Fast principle. In order to optimize the whole, it is necessary to optimize each process individually. In order to optimize a single process, you need to understand what the stumbling block is. In our example, the blocker of the stream value is the priority of speed over quality (when it is necessary to keep a balance), or a violation of the second principle when there is no test-driven approach.

How to Apply Lean Production Principles in Software Development

Top Players in the Hyperconverged Infrastructure Software Market for 2022

Top Custom Software Development Companies

Larian Studios is perhaps the only company with a vast RPG history that still produces genuinely old-school RPGs. Behind this name are fantastic worlds, hours-long gameplay experiences, classic game design, and, of course, humor. The company has distinct canons and rules that give its games a recognizable touch. But at the same time, these also create limitations. Today, we'll discuss Baldur's Gate 3, Larian Studios' most popular project. It introduced the general public to something new - something long known to genre enthusiasts. game The founder of the studio, Swen Vincke, loves board games and has always aimed to transform that passion into a computer game format. This became the foundation for every game design element in the studio's projects. The direction for realizing their ideas was set by a game called Ultima VII. A direction that, according to Vincke, was never continued by anyone else. We're talking about a huge open world, many interactive items and their combinations, various ways to approach a single situation, and thrilling world exploration. These are the very pillars on which Larian Studios' game design stands. From a , the development of every gameplay situation in their games is built on a "+1" model. This means that developers simulate every possible outcome for a gameplay situation and then add... one more on top. This is not only about the progression of the main plot but about interactions with the world. Every barrel in Baldur's Gate 3 can be broken, exploded, or moved. Barrels can block a building entrance or be stacked into a staircase or tower to elevate an archer. One can even put something or someone inside a barrel and carry it around. And that's just the barrel, only one of the many interactive objects in the game. game design perspective Due to this interactivity, players encounter countless unexpected events and twists in their gameplay. Some passage options are always hidden from the player. Access to them might depend, for instance, on a skill to talk to animals or the dead, a random encounter, completing a companion's quest, or performing a specific action. Every chat or minor in-game event can spawn many new scenarios based on the "+1" idea. This makes the game world grow immensely, making even small areas and starting quests feel incredibly expansive. The desire to make the entire environment interactive has been with the studio since its earliest projects. But for me, the Divinity Original Sin series remains the most exemplary and innovative. Its ideas are what Baldur's Gate 3 primarily continues. In Original Sin, players could perform some utterly insane actions. The idea of interaction with "unremarkable" objects was executed brilliantly there. This world here is divided into several components: the regular world inhabited by various humanoids, the world of animals, the world of objects, and the world of living objects. Here, you could mediate disputes between a dog and a cat, accept an intriguing quest from a chicken, argue with a chest, and wear buckets on your head. In this world, objects aren't insignificant, as in most games. Any unliving object in the game might be more important than an NPC. The animals possess a set of qualities, emotions, and motivations that rival those of humans. For instance, in Baldur's Gate 3, there's the story of the "dark urge," obsessed with a desire for blood, paralleled by an emotionally similar dramatic tale of the "Strange Ox." The popular scene from Baldur's Gate 3 trailer, where one has intercourse with a druid in bear form, might be shocking and innovative for the general audience but certainly not for the studio. Compare this with the possibility in Original Sin for elves to peek into the past by eating a corpse. This feature is also continued in Baldur's Gate 3, where players can activate brains and converse with their former owners by inserting them into a skull. The idea of high interactivity brings the element many of us love in games – randomness. In some places, the stakes of this randomness are high, and you wish to encounter it as rarely as possible, like in From Software games. When rolling, the planks beneath you break, and you plunge to death, losing souls. But these random moments are nice in other cases, such as in Baldur's Gate. Both types entertain the player and make their journey emotionally rich. In the discussion on randomness, I'd like to highlight another crucial mechanic in Baldur's Gate 3 – turn-based battles. I won't go into deep details; they're complex and worth a separate discussion. But I'll mention the role of surfaces and how they interact in battles, which makes combat amazing for me. You can set oil, explode barrels to create fire zones, electrify water with lightning, or use gravity to push enemies off the map. This is just a glimpse of the possible interactions. These can be advantageous or dangerous - you might harm teammates or face cunning enemies who use the same tactics. The game's AI is smart, often outthinking the player. So, if an enemy immediately pushes your top character off a ledge, it's intentional, not random. Surfaces play into the primary element of combat – strategic mechanics, but they often emerge from randomness and accompany it until the end. Each player's battle is a unique combination of characters and their builds, abilities, strategies, and the player's reactions to surprises. Developers craft confrontations such that every fight has a vexing element for the player. An archer perched atop a staircase, a necromancer summoning skeletons each turn, or an approaching massive troll. Players strategize to neutralize these threats by prioritizing them and assessing the situation. They are given many opportunities and allowed to combine them as they please. This is why the battles are turn-based. Players have time to ponder the situation, fantasize, and decide. In the first act, you always feel you're given a platform to shine, showcase your intellect, and find an intriguing solution. In the first act, you get to know the game's classes and characters, form your team, and discover how they work together. Every battle becomes an opportunity to try out new skills and strategies. This new game installment nails this aspect, making it feel like you're in . The magic amplifies when you play cooperatively. Imagine exploring a cave while your friend tackles city quests and then meeting to exchange stories at a tavern. Larian Studios has outdone itself, creating a cooperative experience that stands out among games. Their previous titles hinted at this brilliance. It's hard to put into words, but this is what top-notch multiplayer feels like a game where players can engage in rich dialogues, approach quests differently, and even follow their secret goals. a real DnD session A genuinely unique aspect of Baldur's Gate 3 is the DnD mechanic tied to dice rolls. In real life, DnD lets participants role-play any character and do almost anything, guided only by their moral compass and imagined character traits. Lifting restrictions on variability was the developers' most significant challenge when porting this mechanic into the game. They achieved this with minor plot influences from a plethora of small actions. The success of almost every action depends on a dice roll. If the result surpasses a certain value, the action succeeds, and vice versa. It's sometimes hard to resist reloading the game to achieve the desired roll. The most "correct" approach is to accept what happens, like in real DnD, and enjoy a unique storyline with successes and failures that shape your path. Thanks to thousands of these small checks, Baldur's Gate 3 allows each player a unique playthrough. If you play honestly, you can be certain that the likelihood of someone having a playthrough similar to yours has never been so low. Such a scale is impressive. However, it leads to an exponential increase in complexity. The more content and gameplay situations in the game, the more tangled the system becomes, making its realization harder. Hence, the peak number of bugs is concentrated in the third act. And here, I move to the critique. Firstly, all the mentioned mechanics were excellently implemented in Original Sin 2, the studio's previous game. While Baldur's Gate 3 handles them with care, it doesn't bring anything new to the table. Secondly, the vast world and its reliance on constant interactivity mean that after a perfect first act, there's always a second one with less variety. Items might be unique, but they function similarly to the first act's items; enemies become less surprising, and by this point, a character's abilities allow the player to establish a repetitive battle pattern. The game becomes duller. It still entertains with its narrative and nuances, but holistically, the player starts to feel burned out. Statistics show that most players drop off during the second act. Typically, only about 30% make it to its end. By the third act, the situation gets even gloomier. It's usually riddled with even more bugs. Characters, leveled up to god-like statuses, can easily make up to five attacks each turn and land critical hits every time. Gameplay variations start to narrow, and choices that appear different often lead to the same results. The game drags on as the story wraps up its loose ends, leaving the ending a bit diluted. Speaking of the narrative, it's always secondary in the studio's games. Baldur's Gate 3 is no exception. The spotlight is always on gameplay. And while this is good for gameplay, it's not cool for storytelling. The narrative is filled with funny jokes and cool side quests; the companions' stories and the dark urge's plot are enjoyable. But the main plot leans on clichés and templates from two decades ago, now feeling more like post-irony than a well-thought-out script. The mere 12 general endings don't intrigue and blatantly overlook most of the player’s choices. There's no satisfaction from the finale. The pleasure is hidden in the process. Only that process isn't all smooth, either. In Baldur's Gate 3 and all previous Larian games, I start to feel bored by the third act. I don't understand why they always structure the game using the same pattern every time, limiting themselves to the same path. Each new game so closely follows the template of its predecessor that it loses its uniqueness, feeling like an endless update. The glorious Act I, among other things, is conditioned by close interaction with the audience. It was in early access for years, and the developers received tons of feedback during that time. As a result, the game's beginning turned out to be as staggering as possible. Naturally, maintaining that initial benchmark becomes very challenging with such expansive world dimensions focusing on interactive interactions. There's always a shortage of time somewhere, and compromises must be made. My playthrough took 80 hours, but my overall impressions were mixed. I spent most of that time on the first half of the game, where, in my opinion, the most exciting discoveries and beautiful solutions are. I trudged through the second half forcibly, kept taking breaks, and finished two other games before I wrapped up Baldur's Gate. The six-year development of the franchise, born in the 90s, culminated in a significant and well-deserved success for the studio. The increased attention brought hordes of new fans to Larian Studios, discussing a genre they were unfamiliar with just yesterday as if it were a 21st-century revelation. Someone could tell that Baldur's Gate 3 is the best game in history. While the game is one of the year's standout releases and opens up a new genre for many players, an extra year or two in alpha development could have made it even better.

Digging Into The Game Design of Baldur's Gate 3. 

ChatGPT was released in June 2020 and it is developed by OpenAI. It has led to revolutionary developments in many areas. One of these areas is the creation of database queries.The database queries can be generated from plain text via . It helps you with databases that you have little knowledge about. ChatGPT Artificial intelligence, which has progressively integrated into our daily lives, has gained significant momentum with the rise of ChatGPT. Before moving into the project, let’s briefly explore ChatGPT. To fully comprehend the capabilities of ChatGPT, it is essential to have a solid grasp of its underlying architecture. ChatGPT has been developed based on the architecture. So let’s take a look at transformers first. GPT For direct access to the project, click . here Transformers utilize seq2seq frameworks, enabling the conversion of one sequence into another. The sequences have defined ordering. As an illustration, sentences can be viewed as a succession of words. The Transformers can also be used to solve NLP such as text translation. We need a lot of labeled data for training this architecture. This would be difficult for transformers to learn. We can use transfer learning to solve this problem. Transformers consist of two components (Fig 1): an encoder and a decoder, both adept at acquiring a proficient language representation. This proficiency allows us to construct language models from each component. By stacking the encoders, we obtain a idirectional ncoder epresentation of ransformers, commonly known as . Similarly, by stacking the decoder units, we can achieve enerative re- raining that is GPT. In the our case we are focusing on GPT. Let’s think about transfer learning in the context of GPT. When we train a model from scratch, it typically demands a substantial amount of data as the parameters are initially set randomly. However, imagine a scenario where the parameters fortuitously align with the values we require. In such cases, we don’t necessitate an extensive dataset to attain our desired outcome. As will be understood, BERT and GPT are used in transfer learning concept. B E R T BERT G P T The GPT training is thus divided into two parts. We have pre-training part where we train the GPT architecture to understand what language is and then fine tuning part where we use transfer learning to further train the GPT architecture to perform well on specific language tasks GPT has a structure that takes random word sequences as input and predicts the next most suitable word. Sample prediction can be seen at Fig 2. Language modeling is selected as an ideal foundation for understanding the fundamental aspects of language and can be readily fine-tuned. It is commonly known as a self-supervised task since the sentences themselves serve as both input and output labels. Let’s move on to ChatGPT. As it can be seen in Fig 3., the entire ChatGPT process can be divided into three major steps. In the first step, GPT model is used that has been pre-trained on understanding language itself. The next step involves fine-tuning the model to effectively process user prompts and generate appropriate responses based on those prompts. To facilitate this process, labeled data is obtained by engaging labelers who not only provide prompts but also specify the desired response for each prompt. This allows for engaging in supervised fine-tuning of the GPT model, as there are both input prompts and corresponding output responses. In the next step, the supervised fine-tuned model is used that it was obtained from first step. A single prompt is passed through the model, and multiple responses are generated. The labeler then evaluates and ranks the quality of these responses. Each generated response is assigned a corresponding reward, which is utilized to train another GPT model known as the rewards model. Being a model itself, the rewards model functions by taking an initial prompt and one of the responses as input and generating a reward as output. This reward quantifies the quality or goodness of the response. In the third step, an unseen prompt will be taken and passed through a replica of the supervised fine-tuned model. This will generate a response, which will then be evaluated using a rewards model to determine its rank or quality. The rank obtained will be used to further refine our already fine-tuned model. This is achieved by incorporating the rank into the loss function of the PPO model, allowing updates to the model’s parameters through backpropagation. What’s particularly fascinating is that this process not only helps the model exhibit non-toxic behavior but also enables it to generate factual responses. This is because the reward itself was generated based on the quality of the response. ChatSQL Now let’s make a project with ChatGPT using python. LangChain framework is used for this project. Our objective is to retrieve information from our database using plain text. In our work, we utilized MySQL as the target database. Nevertheless, this approach can also be used to generate queries on other databases. The sample database is shown below. ( All codes can be found here https://github.com/ademakdogan/ChatSQL ) +-----+--------------------------------------------------------+------------------------+-------------------+--------+------------------+
| ID  | Title                                                  | Author                 | Genre             | Height | Publisher        |
+-----+--------------------------------------------------------+------------------------+-------------------+--------+------------------+
|   1 | Fundamentals of Wavelets                               | Goswami, Jaideva       | signal_processing |    228 | Wiley            |
|   2 | Data Smart                                             | Foreman, John          | data_science      |    235 | Wiley            |
|   3 | God Created the Integers                               | Hawking, Stephen       | mathematics       |    197 | Penguin          |
|   4 | Superfreakonomics                                      | Dubner, Stephen        | economics         |    179 | HarperCollins    |
|   5 | Orientalism                                            | Said, Edward           | history           |    197 | Penguin          |
|   6 | Nature of Statistical Learning Theory, The             | Vapnik, Vladimir       | data_science      |    230 | Springer         |
|   7 | Integration of the Indian States                       | Menon, V P             | history           |    217 | Orient Blackswan |
|   8 | Drunkard's Walk, The                                   | Mlodinow, Leonard      | science           |    197 | Penguin          |
|   9 | Image Processing & Mathematical Morphology             | Shih, Frank            | signal_processing |    241 | CRC              |
|  10 | How to Think Like Sherlock Holmes                      | Konnikova, Maria       | psychology        |    240 | Penguin          |
|  11 | Data Scientists at Work                                | Sebastian Gutierrez    | data_science      |    230 | Apress           |
|  12 | Slaughterhouse Five                                    | Vonnegut, Kurt         | fiction           |    198 | Random House     |
|  13 | Birth of a Theorem                                     | Villani, Cedric        | mathematics       |    234 | Bodley Head      |
|  14 | Structure & Interpretation of Computer Programs        | Sussman, Gerald        | computer_science  |    240 | MIT Press        |
|  15 | Age of Wrath, The                                      | Eraly, Abraham         | history           |    238 | Penguin          |
|  16 | Trial, The                                             | Kafka, Frank           | fiction           |    198 | Random House     |
|  17 | Statistical Decision Theory'                           | Pratt, John            | data_science      |    236 | MIT Press        |
|  18 | Data Mining Handbook                                   | Nisbet, Robert         | data_science      |    242 | Apress           |
|  19 | New Machiavelli, The                                   | Wells, H. G.           | fiction           |    180 | Penguin          |
|  20 | Physics & Philosophy                                   | Heisenberg, Werner     | science           |    197 | Penguin          |
|  21 | Making Software                                        | Oram, Andy             | computer_science  |    232 | O'Reilly         |
|  .  | .......                                                | .......                | ....              |    ... | ....             |
|  .  | .......                                                | .......                | ....              |    ... | ....             | The ChatSQL consists of two main parts. First of all, mysql queries are generated from the given plain text via ChatGPT. These generated queries are executed. In the second step, the results returned in the database are evaluated. At this stage, the results can either be presented directly to the user or sent back to ChatGPT for further analysis and interpretation. So you can chat about your database with ChatGPT. Suppose the user wants “Show me the book type fiction which they height bigger than 175 and smaller than 178. The author shouldn’t be ‘Doyle, Arthur Conan’.”. So the following command can be used in this case. python3 chatsql.py -p 'Show me the book type fiction which they height bigger than 175 and smaller than 178. The author shouldn't be 'Doyle, Arthur Conan'. ' As a result, the following information is obtained. CHATGPT QUERY------------------:
SELECT * FROM bt WHERE Genre = 'Fiction' AND Height > 175 AND Height < 178 AND Author != 'Doyle, Arthur Conan'
RAW RESULT------------------:
[(32, 'Pillars of the Earth, The', 'Follett, Ken', 'fiction', 176, 'Random House'), (37, 'Veteran, The', 'Forsyth, Frederick', 'fiction', 177, 'Transworld'), (38, 'False Impressions', 'Archer, Jeffery', 'fiction', 177, 'Pan'), (72, 'Prisoner of Birth, A', 'Archer, Jeffery', 'fiction', 176, 'Pan'), (87, 'City of Joy, The', 'Lapierre, Dominique', 'fiction', 177, 'vikas'), (128, 'Rosy is My Relative', 'Durrell, Gerald', 'fiction', 176, 'nan')]
PROCESSED RESULT------------------ :
The books 'Pillars of the Earth, The' by Ken Follett, 'Veteran, The' by Frederick Forsyth, 'False Impressions' by Jeffery Archer, 'Prisoner of Birth, A' by Jeffery Archer, 'City of Joy, The' by Dominique Lapierre, and 'Rosy is My Relative' by Gerald Durrell are all fiction books with 176 or 177 pages published by Random House, Transworld, Pan, Vikas, and Nan, respectively. If your database columns are named appropriately, chatgpt will understand these names and respond queries accordingly. However, there may be instances where the column names in the database are not meaningful or ChatGPT may not fully figure out their context. Hence, in order to ensure the system functions correctly, It is necessary to provide ChatGPT with prior information about the database. Info.json file can be used to adding information. +-----+--------------------------------------------------------+------------------------+-------------------+------+------------------+
| ID  | aa                                                     | bb                     | cc                | dd   | ee               |
+-----+--------------------------------------------------------+------------------------+-------------------+------+------------------+
|   1 | Fundamentals of Wavelets                               | Goswami, Jaideva       | signal_processing |  228 | Wiley            |
|   2 | Data Smart                                             | Foreman, John          | data_science      |  235 | Wiley            |
|   3 | God Created the Integers                               | Hawking, Stephen       | mathematics       |  197 | Penguin          |
|   4 | Superfreakonomics                                      | Dubner, Stephen        | economics         |  179 | HarperCollins    |
|   5 | Orientalism                                            | Said, Edward           | history           |  197 | Penguin          |
|  .  | .......                                                | .......                | ....              |    ... | ....           |
|  .  | .......                                                | .......                | ....              |    ... | ....           | As an example, let’s have a badly named database as below. In this case, the required information about the database is inputted into the info.json file. {“bt”: “Table Name”, “aa”: “Title of the book”, “bb”: “Author of the book”, “cc”: “Type of book”, “dd”: “Height of the book”, “ee”: “Book Publisher”} and then use the same command: python3 chatsql.py -p 'Show me the book type fiction which they height bigger than 175 and smaller than 178. The author shouldn't be 'Doyle, Arthur Conan'. ' Even if the column names in the database are poorly selected, chatgpt generates the correct query because we provide the correct information {'query': "SELECT aa, bb, cc, dd FROM bt WHERE cc = 'fiction' AND dd > 175 AND dd < 178 AND bb != 'Doyle, Arthur Conan'", 'raw_result': "[('Pillars of the Earth, The', 'Follett, Ken', 'fiction', 176), ('Veteran, The', 'Forsyth, Frederick', 'fiction', 177), ('False Impressions', 'Archer, Jeffery', 'fiction', 177), ('Prisoner of Birth, A', 'Archer, Jeffery', 'fiction', 176), ('City of Joy, The', 'Lapierre, Dominique', 'fiction', 177), ('Rosy is My Relative', 'Durrell, Gerald', 'fiction', 176)]", 'processed_result': '\nThe books "Pillars of the Earth, The" by Ken Follett, "Veteran, The" by Frederick Forsyth, "False Impressions" by Jeffery Archer, "Prisoner of Birth, A" by Jeffery Archer, "City of Joy, The" by Dominique Lapierre and "Rosy is My Relative" by Gerald Durrell are all fiction and have page lengths of 176 or 177.'} The next project could be on generating queries (mongo, sql) from prompts with free models (Llama). Project Repo : https://github.com/ademakdogan/ChatSQL Github : https://github.com/ademakdogan Linkedin : https://www.linkedin.com/in/adem-akdoğan-948334177/ References [1] Brown, T. B., Mann, B., Ryder, N., Subbiah, M., Kaplan, J., Dhariwal, P. and Amodei, D. (2020). Language models are few-shot learners. arXiv preprint arXiv:2005.14165. [2] Radford, A., Wu, J., Child, R., Luan, D., Amodei, D., Sutskever, I. (2019). Language models are unsupervised multitask learners. OpenAI Blog. [3] Vaswani, A., Shazeer, N., Parmar, N., Uszkoreit, J., Jones, L., Gomez, A. N. and Polosukhin, I. (2017). Attention is all you need. In Advances in neural information processing systems (pp. 5998–6008). [4] Devlin, J., Chang, M. W., Lee, K., & Toutanova, K. (2019). BERT: Pre-training of deep bidirectional transformers for language understanding. In Proceedings of the 2019 Conference of the North American Chapter of the Association for Computational Linguistics: Human Language Technologies (Vol. 1, pp. 4171–4186). [5] Lewis, M., Liu, Y., Goyal, N., Ghazvininejad, M., Mohamed, A., Levy, O., & Zettlemoyer, L. (2019). BART: Denoising sequence-to-sequence pre-training for natural language generation, translation, and comprehension. arXiv preprint arXiv:1910.13461. [6] Raffel, C., Shazeer, N., Roberts, A., Lee, K., Narang, S., Matena, M., … & Liu, P. J. (2019). Exploring the limits of transfer learning with a unified text-to-text transformer. arXiv preprint arXiv:1910.10683. [7] Vaswani, A., & et al. (2017). Transformer-XL: Attentive language models beyond a fixed-length context. arXiv preprint arXiv:1901.02860.

ChatSQL: Enabling ChatGPT to Generate SQL Queries from Plain Text

চ্যাটএসকিউএল: প্লেইন টেক্সট থেকে এসকিউএল কোয়েরি তৈরি করতে ChatGPT সক্ষম করা

ChatSQL: ChatGPT aktivieren, um SQL-Abfragen aus reinem Text zu generieren

ChatSQL: habilitar ChatGPT para generar consultas SQL a partir de texto sin formato

ChatSQL – Activation de ChatGPT pour générer des requêtes SQL à partir de texte brut

ChatSQL: प्लेन टेक्स्ट से SQL क्वेरी जनरेट करने के लिए ChatGPT को सक्षम करना

ChatSQL: ChatGPT を有効にしてプレーン テキストから SQL クエリを生成する

ChatSQL: ChatGPT를 활성화하여 일반 텍스트에서 SQL 쿼리 생성

ChatSQL : habilitando o ChatGPT para gerar consultas SQL a partir de texto simples

ChatSQL: ChatGPT'nin Düz Metinden SQL Sorguları Oluşturmasını Etkinleştirme

ChatSQL: Bật ChatGPT để tạo truy vấn SQL từ văn bản thuần túy

ChatSQL：启用 ChatGPT 从纯文本生成 SQL 查询

On Machines That Play: The History of AI and Games

Sobre máquinas que juegan: la historia de la IA y los juegos

Sur des machines qui jouent : l'histoire de l'IA et des jeux

ऑन मशीन्स दैट प्ले: द हिस्ट्री ऑफ एआई एंड गेम्स

遊ぶ機械について: AI とゲームの歴史

Em máquinas que jogam: a história da IA e dos jogos

Trên máy chơi: Lịch sử của AI và trò chơi

在会玩的机器上：人工智能和游戏的历史

Just around 2012 is when I received a lesson of a lifetime, to appreciate culture differences and how very deep they can get. It’s not that I haven’t been exposed to cultures outside of mine till that point. I have lived in Texas as a child, I have been positioned in Korea when working for a major Semiconductor manufacturer, and I have traveled the world both for business and with my family for pleasure. But in 2012 I was a project manager leading business and delivery activities for a major multinational bank, right at the heart of the famous Canary Wharf district in London. In a grey winter early morning, accompanied by a typical London drizzle, I stepped out of my hotel room and rode the tube to the bank headquarters. Stepped inside the building, while wearing a full suite and tie, and took the lift thirty floors up almost nearing the end of the thirty four stories tower. I was a vendor supplying software solutions to the bank, and at that morning I had a most important semi-sales meeting with the client, a meeting I had prepared and worked for many weeks earlier. To understand the embarrassment and lesson I had received that day, there is a need to understand a short piece of British history first. During the French and English wars during the 14th and 15th centuries, the English archers were what the French soldiers feared the most. Any English archer that was caught by the French military and that has been captivated, had their Index and middle fingers cut off to prevent them from being able to get back to battlefield ever again in case of prisoner exchange occurred. This led to English soldiers taunting their French enemy by raising their two fingers in the V-shaped ‘Two-Fingered Salute’, meaning “You haven’t cut off my fingers !”. Time certainly passed since then, and while the entire world lifts a middle finger at an annoying person expressing a rude Fuck Off sign, the British raise a V-shaped sign till today to express the same feeling towards a bugging counterpart. I prepared everything about that business travel, but one thing: the culture difference and nuances I need to know about the British. Back to 2012, 30th floor in a headquarters building, of one of the world’s largest banks. I approach a conference room reserved for me, room number two, five minutes before my meeting is planned to commence, to organize myself. But then I realize it does not have a white board or projector, which I needed. So I walk a few meters to each side of the corridor to find a different available room, when I come across an igloo shaped meeting room perfect for my needs. White board, projector and nice fancy furniture. Only weird thing with that room was the entire walls were glass made and totally transparent. But I figured that would be better than what I had reserved, so better off start with what I have. My clients started approaching one by one, and I had directed them all into our new board room to start our meeting. The first couple of minutes start off well and I’m in the muse, when a gentleman dressed up in a full typical bank manager striped suite stands outside the room, we can’t hear him but we sure can see him, and he points out right at me letting me know that was his room. Because I knew I had another one booked for me, I figured it would be no big deal if I direct him over to my reserved room, room number two. So I point back at him, for what I mean as “You”, and I give him a nice big V-shape salute with my right hand two fingers, for what I mean as “room number two”. The gentleman seemed a bit surprised and upset altogether and for a few seconds did not move or react. I wasn’t sure if he got the point or not, all I know is that folks in the room with me began laughing which embarrassed the gentleman and this entire situation. They had explained to me that the person waiting outside is one of the most senior people in the bank and if I was sure I knew what I was doing. So I comfortably told them that it is no big deal, I have a reserved room and I’m certain that he wouldn’t mind taking another conference room just few offices aside. The gentleman pointed back at me again. This time his face expression was a bit more serious and determined. He again made some hand movements which I perfectly understood that he needs the room and it is booked for him. I made the conclusion he did not understand me the first time, but this time I’m going to leave no place for doubts. So I looked straight into his eyeballs, pointed right at him with a long reach of my hand, and for the second time gave him the big two-fingered salute. The gentleman jumped in anger, and wasn’t very gentle anymore. The crowd in the room with me couldn’t stop laughing although they desperately tried to. The gentleman approached the board room door, opened it up and said: “Young man, this is my room, and you are requested to leave the room, or the building for all I care!” I gently told him at that point, that I understand that and I’m more than happy to move to a different one, only I have tried to suggest that he takes my room, meeting room number two, and if he doesn’t mind checking it out so we can remain where we are. This true story ended well that day. But the point of the story is that I have learned a culture lesson for life, right at the moment when I was sure I’m as smart as one can get when it comes to multi-cultures and interacting with people from other places. I had prepared myself for that meeting weeks before. I had prepared the people I wanted to meet, chased them by mail, made sure of availability, even provoked their interest with what I had to talk to them about. I prepared all my material, my presentation, my agenda, the way I will open the meeting and close it. I prepared everything about that business travel, but one thing: The culture difference and nuances I need to know about the British. Since that day I had traveled the world quite frequently, business and pleasure, from the far east to the far west, but there is something I never forget to do when preparing myself for travel: Learn about my destination people and culture.

ARCHER SOFTWARE

archer-soft.com

51-200 employees

Since 2000

COMPANY RANKING

ARCHER SOFTWARE

EVERGREEN INDEX #1227

Representing this company? Click here to claim and customize this page!

Archer Software WIKI

Apply to get your Tech Company News Page live on HackerNoon.com today!

ARCHER SOFTWARE

archer-soft.com

51-200 employees

Since 2000

COMPANY RANKING

ARCHER SOFTWARE

EVERGREEN INDEX #1227

RELATED COMPANIESRANK

STORIES ABOUT ARCHER SOFTWARE

Representing this company? Click here to claim and customize this page!

Archer Software WIKI

Apply to get your Tech Company News Page live on HackerNoon.com today!