Get the most recent info and news about InfoPrice on HackerNoon, where 10k+ technologists publish stories for 4M+ monthly readers.

Plataforma completa de pricing, do monitoramento da concorrência à precificação inteligente. 

InfoPrice

infoprice

In 2021, hosted the first-ever awards!! HackerNoon Startup of the Year The goal of this campaign was to give recognition to the hardworking startups who pulled through the pandemic -- growing and thriving (despite all of the challenges). More than 44,000 startups were nominated all across the globe! They were selected from over 4,553 cities, with a total number of * cough * “4 billion” votes. Insane, right? To see who is a winner in each respective city, visit and pick a city. The name at the top of the list is the winner. (Awards, with compromised reviews, are under review.) startups.hackernoon.com The will announce the winners per region in their respective cities. Startups Winners Announcement Series Apparently, South America startups did incredibly well in that regard. With so many, until now, uncrowned jewels, it’s time we present to you... * drumroll* 🥳 The South America Startups of the Year Winners! Santiago, Chile Chile is known for being the most stable country to do business in Latin America, ranking 13th in The Economist’s Business Environment Index. Moreover, according to the Global Innovation Index, Chile ranks first in Latin America for innovation and is recognised as Chilean Silicon Valley with Santiago being the central city. The winner is…. QCObjects It is the 1st world class open-source framework made in Latin-America. São Paulo, Brazil And the winner of Brazil’s vibrant financial center is... Innvo Digital Their mission is to create the best ecosystem for a technology professional to work and undertake while sharing it with our customers and society. São Carlos The absolute leader of Sao Carlos seems to be: Predify Predify is an online software for optimizing pricing proccess and improving profits with AI and Big Data Analytics. Belo Horizonte, Brazil With a more than noble goal, Belo Horizone’s winner is: CM Tecnologia CM Tecnologia is an online scheduling system for healthcare providers in Brazil. Porto Alegre, Brazil With the focus on data protection, Porto Alegre, Brazil’s winner is…. Privacy Tools Privacy compliance platform, based on AI/Blockchain, which helps global companies to keep compliant with the data protection requirements. Brasil, Brazil With the focus on EdTech, Brasil is bringing us: Awari Awari is a YC-W21 company focusing on education for the Tech Industry. The company is growing at a fast pace and has gathered experts from all leading tech companies into a full education experience to prepare the next cohort of tech talent. Quito The capital of Ecuador, and also the closest capital to the actual equator, as the winner brings us: Agrodemanda The most comprehensive agricultural directory in Ecuador. Rio De Janeiro, Brazil Rio de Janeiro has more than 300 startups and is ranked 3rd in Brazil in terms of startup ecosystem development. The city is famous for the startups in the spheres of education, energy & environment and foodtech. Their winner is…. Bybrand Bybrand is the simplest way to save time and avoid frustration when managing your employee's email signatures. Buenos Aires, Argentina Buenos Aires, Argentina is not only the cosmopolitan capital with a vibrant history. It’s also Latin America’s most important port. Which makes their winner actually a very logical choice. Please meet: Liftit Liftit is the leading technology platform to automate and execute last-mile truck deliveries across Latin America. Curitiba, Brazil With a more noble mission and sustainability in mind, Curitiba, Brazil, as the winner brings us... Discrepante is the marketplace for a more human and sustainable economy Discrepante.com Florianópolis, Brazil Would you really be surprised one of the Brazil’s winners is related to football training? We neither. Please meet... Fútbol Fit Club Football FitClub® is a fitness training firm that gives fitness training to improve like a professional football player. Medellín, Colombia And the first Colombian Startup Winner is is a data intelligence solution powered by a high quality team. Meet... LogComex Market intelligence for international trade in Latin America Montevideo, Uruguay The host of inaugural FIFA world cup of 1930 comes through when it comes to innovation even in 2021. I’d like to introduce you to: Drop Technologies First electronic hand antiperspirant device Lima, Peru Lima, Peru, has in 2021 delivered some amazing results when it comes to blockchain technology. Their winner is very well deserved: RSK Labs RSK is the first open-source smart contract platform São Carlos Do Pinhal Well this is a unique case. The absolute unanimous winner of São Carlos Do Pinhal is: brain4care brain4care solution enables monitoring intracranial compliance noninvasively anywhere Blumenau, Brazil We’re sensing a theme here. Another stellar EdTech winner is coming from Blumenau, Brazil. Please meet... Uniasselvi Uniasselvi is a Brazilian distance-learning company that offers more than 60 undergraduate and postgraduate courses, in person and distance. Bogotá, Colombia Startups of Bogotá, Colombia definitely showed they’re not to be underestimated. With a very noble mission, let me introduce you to: Risü Risü is an online platform that links online consumption to donation to social institutions. Campina, Brazil If there’s one typo of business we’d single out as taking the biggest hit out of the pandemic, it would have to be small businesses. Thankfully, the winner of Campina, Brazil, operates with small businesses in mind Superlógica Tecnologias Ltda. Superlogica is a management system company created for small service businesses. Cerqueira César, Brazil Swooping half the points from the entire City, this year’s winners of Cerqueira César are InfoPrice INFOPRICE is a business intelligence company focused on physical retail pricing. Governador Valadares, Brazil The same can be said for the winners here. Let’s hear it for: Grupo KPG Saas, Payment, Manufacture, Pharmaceutical, E-commerce, Marketplace, Logistics Caxias Do Sul Known for wine making and Italian cultural influence, Caxias Do Sul brings as an interesting winner. Studio 360 Studio 360 is a proptech focused on easing the purchase experience for real state companies, brokers, and costumers. Sorocaba From Sorocaba, we have an interesting concept coming. Looking forward to seeing it further develop. Let’s meet: Quinto Quinto is a social network that represents the collective opinion of society—to help democracy evolve through technology Viña Del Mar To be a venue-oriented business and survive through the pandemic definitely deserves some recognition. In the name of that, let’s meet: SonicPollen SonicPollen, based in Chile, is a web-based booking platform that connects bands with venues and organizers. Lages Learn more about high-growth startups in Lages, South America. and the winner is…. Qualiall Qualiall develops technologies for training in operational processes such as work security, equipment maintenance, and more. Córdoba, Argentina Another gem from Argentina brings us unique agricultural solutions. Please meet: Kilimo Kilimo is a Big Data solution for water management in agriculture. São José Dos Campos, Brazil Another great agricultural solution comes this time from Brasil. Meet São José Dos Campos Startup winner: TerraMagna TerraMagna is a fintech company that focuses on risk mitigation for agribusinesses. São Leopoldo, Brazil Event-oriented businesses that have survived in the previous years should definitely bottle their perseverance and start selling it. One of those is definitely this winner: Wedy Wedy offers a one-stop-social marketplace for weddings. Pelotas, Brazil Medical scheduling platforms are definitely something we need to see more of. So glad Pelotos winner comes from this particular niche. Fácil Consulta Fácil Consulta is a booking platform that allows people to schedule an appointment with a Specialist Physician in their area. Santa Maria Could you believe how versatile the startups of South America are when we are only now coming across a game development studio? Let’s meet them Imgnation Studios Imgnation Studios is a game development studio that focuses on virtual reality. Asunción, Paraguay A FinTech solution coming from Paraguay. Meet Asunción Startup of the Year winner Vision Banco Vision Banco is a solid and growing financial institution serving the financial needs of the micro, small and medium enterprises. Caracas Venezualan food delivery app that seemed to have your heart. Meet Caracas Startup of the Year winner Yummy Inc. First Food Delivery App in Venezuela Recife A suitable combo between gaming and education, Recife Startup of the Year winner brings revolutionary solutions. Let’s meet them. Joy Street Joy Street offers develops video games focused on educational needs. Rosario, Argentina The winner of Rosario Startup of the Year award for 2021 is... Gbot Gbot is an autonomous robot that controls weeds without using agrochemicals. We also collect data in fields and generate precision maps. Vila Olímpia, Brazil The winner of Vila Olímpia Startup of the Year award for 2021 is... Seekr Seekr operates in the Information Technology sector, providing tools for managing and monitoring of brands. Barueri The winner of Barueri Startup of the Year award for 2021 is.... Glic Brazilian mhealth (web/app) platform for diabetes management Brasília The winner of Brasília Startup of the Year award for 2021 is... Ticies Ticies is a social network that helps people plan where to go with their friends, relatives and acquaintances, in all cities of the world. Juiz De Fora The winner of Juiz De Fora Startup of the Year award for 2021 is... Qranio Qranio is a gamified mobile learning platform for enterprises that rewards learning and stimulates users to engage with educational content. La Paz The winner of La Paz Startup of the Year award for 2021 is... Jukumari Advice 360 photo based market place for responsible tour operators Temuco The winner of Temuco Startup of the Year award for 2021 is... GoFeels GoFeels is the first independent hospitality network in the world. We promote collaborative work among hotels around the world. Vitacura The winner of Vitacura Startup of the Year award for 2021 is... MeatMe MeatMe delivers meats and accessories to have a culinary experience. Barranquilla The winner of Barranquilla Startup of the Year award for 2021 is... Mandaos Mandaos is a digital platform that connects companies and people with a network of independent messengers Ceará The winner of Ceará Startup of the Year award for 2021 is... Caroá Caroá is a cooperative that sells 34 varieties of vegetables, organic fruits, and vegetables. Chapecó The winner of Chapecó Startup of the Year award for 2021 is... HortiAgro HortiAgro is a seed and fertilizer market. Chile Chico The winner of Chile Chico Startup of the Year award for 2021 is... Gleengo Gleengo connects children with their favorite toys, through a tiny device and an application based on text-to-voice. Goiânia The winner of Goiânia Startup of the Year award for 2021 is... Auvo Auvo is an external teams management software. Itá The winner of Itá Startup of the Year award for 2021 is... TISSUELAB Tissuelab is a research and development center focused on biotechnology, and systems for reconstructive musculoskeletal surgery. Jardim Paulista The winner of Jardim Paulista Startup of the Year award for 2021 is... DiviCom DiviCom is a digital video networking company that designs, integrates, and markets complete systems. João Pessoa The winner of João Pessoa Startup of the Year award for 2021 is... YupiPlay YupiPlay develops and offers an educational gaming platform. La Reina The winner of La Reina Startup of the Year award for 2021 is... INTI-TECH INTI-TECH is the fastest growing renewable energy in Chile and the world's leading unconventional source. Leme The winner of Leme Startup of the Year award for 2021 is... EcoStart EcoStart focuses on manufacturing sustainable electric bicycles, fans, and accessories. Loja The winner of Loja Startup of the Year award for 2021 is... Enerwi Corporation Keeping people connected and secured through wireless charging novel solutions Manizales The winner of Manizales Startup of the Year award for 2021 is... Porter Metrics Porter Metrics has developed an automated solution for generating social media reports in minutes. Nova Lima The winner of Nova Lima Startup of the Year award for 2021 is... Biomimetic Solutions Biomimetic Solutions is an innovative tissue engineering company. Paraná The winner of Paraná Startup of the Year award for 2021 is... Laura Laura is a provider of artificial intelligence and predictive analytics platform for hospitala and clinics to prevent damage & reduce costs. Salvador The winner of Salvador Startup of the Year award for 2021 is... Sanar Sanar is a platform that focuses on being the doctor's guide and support, offering specialized content that helps in their development. Santa Catarina The winner of Santa Catarina Startup of the Year award for 2021 is... DrPOCKET Sunchales The winner of Sunchales Startup of the Year award for 2021 is... Eolo Pharma Eolo Pharma focuses on developing drugs targeting the molecular and cellular basis of inflammation-related diseases Valparaiso The winner of Valparaiso Startup of the Year award for 2021 is... Invitta Invitta transforms plastic waste into a high-performance construction material for manufacturing sustainable urban furniture. Vila Velha The winner of Vila Velha Startup of the Year award for 2021 is... OneGrid OneGrid is a developer of hardware and software solutions focused on energy management. Indaiatuba The winner of Indaiatuba Startup of the Year award for 2021 is... DWUL Energy Renewable Energy Campinas, Brazil The winner of Campinas Startup of the Year award for 2021 is... Ativy Ativy is an IT company specialized in cloud computing, data centers, IT outsourcing, service desk, and IT management. Las Condes, Chile The winner of Las Condes Startup of the Year award for 2021 is... # MuvPass Subscription services that allows it's users unlimited access to fitness classes in the best gyms and studios in Latin America. Pinheiros, Brazil The winner of Pinheiros Startup of the Year award for 2021 is... GuiaBolso GuiaBolso is a personal finance platform that empowers people to take control of financial well-being. Rio, Brazil The winner of Rio Startup of the Year award for 2021 is... EmCasa EmCasa is a vertically-integrated platform that helps customers buy and sell a home in Latin America, starting in Brazil. Guayaquil The winner of Guayaquil Startup of the Year award for 2021 is... Sabroso Online platform for LatAm's enterprises to order low-cost meals Jundiaí The winner of Jundiaí Startup of the Year award for 2021 is... Sintecsys Sintecsys offers a fast and effective detection, reducing losses and costs with fire brigades. Minas Gerais The winner of Minas Gerais Startup of the Year award for 2021 is... Rizoflora Biotechnology Rizoflora Biotechnology is a producer of biological product designed for nematodes control. São Caetano Do Sul The winner of São Caetano Do Sul Startup of the Year award for 2021 is... Wevo 1 iPaaS in Latam - Enabling companies to be truly digital companies with APIs, systems and data integrated into a single platform Canoas The winner of Canoas Startup of the Year award for 2021 is... ContaÁgil ContaÁgil facilitates and reduces bureaucracy in accounting routines of companies. Chile The winner of Chile Startup of the Year award for 2021 is... Unight Unight is the future of nightlife social media. Israelândia The winner of Israelândia Startup of the Year award for 2021 is... Matchpool Matchpool is a platform that creates human connections. La Plata The winner of La Plata Startup of the Year award for 2021 is... Pixivus Pixivus offers a community-based application that enables its users to collect, store, and share pictures of events. Novo Hamburgo The winner of Novo Hamburgo Startup of the Year award for 2021 is... Devorando Devorando offers an online food ordering system and menus available in restaurants based in Brazil. Pernambuco The winner of Pernambuco Startup of the Year award for 2021 is... Redu Redu is a distant learning platform which is built on a social networking structure. Providencia The winner of Providencia Startup of the Year award for 2021 is... # TrainFES TrainFES is a medical Devices for the rehabilitation of people with paralysis. Ribeirão Prêto The winner of Ribeirão Prêto Startup of the Year award for 2021 is... AllyHub Ally is a sales distribution channel technology that connects Schools and Service Providers with Education Agencies. Santa Cruz De La Sierra The winner of Santa Cruz De La Sierra Startup of the Year award for 2021 is... Mobi Latam Mobi Latam is a clean energy startup that focuses on transportation systems based on electric mobility. Santana De Parnaíba The winner of Santana De Parnaíba Startup of the Year award for 2021 is... MercadoLivre.com is an e-commerce technology company providing solutions to individuals and companies buying, selling, and more online. MercandoLivre.com More Information If you’re a winner, please answer ! If you’re a reader, participant, just a curious individual, consider answering one of our interviews . this interview here Read the FAQs about or . Startups here here To see all of the winners you may visit , pick any city and view the name that appears at the top. this site If you’re interested in partnering with us, we invite you to look through some of these or reach out to our business department. unique sponsorship options Perhaps creating your very own tickles your fancy or maybe you have a whole new idea for how we can partner! writing contest Thank you to all of our sponsors! We truly appreciate your contribution to the tech world and thus the future! The Startups Awards are sponsored by: , , , , , , , , , , Blockster Brex FreeCodeCamp LaunchDarkly Coil Udacity Udemy Vercel Asia Pacific Transgender Network Bybit Everscale Network This post was written/compiled by Shreya Kundu and Katarina Andrejević! If you have any questions or concerns or would like to report a discrepancy please email ellen@hackernoon.com.

Meet the Winners of Startups in South America

SQL stands for Structured Query Language. SQL is used to communicate directly with the database. It is pronounced as "ess-que-el" or "see-que-el". For managing databases, it is the standard language set by the American National Standards Institute (ANSI). What do we do with SQL? Like our web page depends on HTML, CSS, JavaScript to function: SQL is used to modify, update, implement changes to the database. SQL Server, Microsoft Access, Informix, Oracle, Sybase are a few database management systems that work with SQL. Commanding a database doesn't need complex scripting. Most of the scripts are hardcoded beforehand and pushed as rules with the database management system (DBMS). We use simple commands such as "Update", "Select", "Insert", "Delete", "From", "Like", "Where" etc. followed by question marks (?) for regular interactions with the database. What is SQL injection? We know what SQL is, and attacking with the same knowledge or misleading the tools to gain an unfair advantage would be something that we can call an SQL attack. is what we named SQL injection. Injecting malicious SQL script into a database The attack is quite common and has been executed for a very long time. It leads to a sitewide control, and the attacker would have the ability to do whatever purpose the data is accessed for. The crime is serious. If the codebase is not secure, testing functions are live on the real-world database, inputs aren't satanized adequately, then a web server is prone to SQL injection. There are plenty of other weaknesses that a web application may have. Talking with a database uses command as we know, and it is almost plain English. It's not a feature that made SQL injections more viable, but this is the way, and it has existed for many years. We are going to discuss in-depth details and ways to prevent An attacker can obtain user information, even admin login credentials, via a SQL attack. SQL injections throughout the article. This simple command line on the database is used to find a specific item. The general user perspective can be the search bar where the "keyword" is being used. It looks exactly like the image, depending on the IDE used from an injector or a database manager prospect. Here, we modified the code a bit to check what our server responds to the query. We changed the keyword inside the single quote marks to see how our server or target responds. And a part of our syntax became grey. We can find out the type of database management system used in this particular server. And there are plenty of ways to do so. Our grey indication puts out that the server used . An insecure database spits out all the information just by this simple command. MySQL Tempering with the delay function can quickly reveal which DBMS has been used. In the code above, after the keyword, we put a delay function. On MySQL, the delay function is "SLEEP." So, we put the delay function for a few seconds. After the 10 second interval we specified, the server sends out information. And this is how we can determine the type of SQL server used. MySQL uses the "SLEEP" function, and Oracle uses DBMS_SESSION.SLEEP or DBMS_LOCK.SLEEP. Yes, it is pretty normal to find out certain aspects easily just by its delay or time management behavior. SQL injection evolution Understanding how we gradually managed to find loopholes developed solely for our good is a slight brainteaser. We have databases that store information. Or the website that is hosted on a remote server. If we want to access it, we use credentials and request data. The same way we insert data into the webserver. Like product info, price update, stock numbers, and more. We gradually improved our technical knowledge, and at the same time, technology evolved. Hackers request data from the database. And this data is not permissible to access by an outsider. While the invention is pretty incredible, the attacker misuses the data and tries to implement changes on the input terms that give out different results. But we have indeed come a long way since the 19070s, where IBM researchers developed and used SQL for the first time. Top 5 ways to prevent SQL injections There are many ways to temper with the SQL database; there are more ways to make sure that these don't go unnoticed. We are going to point out the most UpToDate ways to prevent SQL injections. 1. Prepared Statement Experienced developers don't leave this one unchecked, as preparing statements is one of the primary and most important rules to prevent SQL injections. Parameterized queries are sometimes referred to as prepared statements. Prepared statements work with a variable bind. Variable bind and dynamic queries work hand in hand. But they are simpler to write and eventually implement in the database. What a prepared statement does to a database is that it defines SQL query before passing parameters. As a result, the query becomes subtle and not changeable by attackers. Here are some of the different types of Prepared statements by different programming languages. Parameterizing queries makes it hard for an attacker to insert a query. We have previously stated the commands used in the SQL injection. Each language has its way to use parameterizing quarries. As we can see, PHP variables are already set just like every other function in a code. Every assignation of variables like username, user id, password, email function has already been declared in our script. What we need to do now is, rule the specific variables to work on the given roles. Compared to SQL execution, prepared statements talk directly with the database to have advantages like reduced parsing time and cuts away SQL injection vulnerability. It takes single parameters while working with it rather than the whole query. Here is another statement that falls under the prepared statement and parameterized queries. It is a safe way to proceed with coding the SQL database. Parameterized statements are one of the vital parts of protection against SQL injections. 2. Input Validation Input validation is one of the primary defenses that work with SQL injection prevention methods on the front line. In simple words, whatever input is there, the validation process dissects if the input type is allowed or not. And even what kind of user has permission to use this type of inputs. Inputs are integers (whole number, both positive and negative), plain text (simple words), floats (numbers with decimal points). Outside of that parameter or a specifically structured function gets skipped, and that works as input validation. input validation or OWASP WebGoat is a simplified platform that teaches the general practice of input validation. There is a considerable number of input fields other than we mentioned above. File or document uploader, modern websites that work with AI has different sorts of input fields. These are values predefined by buttons or inputs with multiple-choice options. Input validation only accepts input that is predefined hence removes misuse of the database. A rule of thumb for input validation is whitelisting regular expressions rather than blacklisting. Validation includes general user information like name, age, or zip code, etc. There should be a set of fixed cases. OWASP In this PHP snippet, we mentioned a worldly example of actual code. "Mode" here defines the basic theme of an interface. The input takes in user data and transforms the website accordingly. Here, modes are "Light" and "Dark." It is widespread among most web applications today. This input should be defined beforehand of which setting to change and how it impacts the database. Rather than that, it shouldn't have the power to change any other functions. This one is radio button input. Similar goes for the blank space inputs. What our goal is to define functions as precisely as possible. 3. Escaping Whenever we request data from a database, it looks for the easiest and the "fastest" way to analyze the query. The complication is how we defined the query, what we want to access and how the SQL server handles the execution. One of the significant ways an attacker can perform an SQL injection is by utilizing this common mistake. Escaping all character functions may make the system a bit choppy, but hey, we didn't choose SQL management for the fastest solution there is. Instead, we decided on SQL for being user-friendly, secure, and accurate with our data. A simple escaping method is adding a single quote followed by an escape character ('\). For Database Management System (DBMS), we recommend escaping user-defined characters. What differentiates between the escaping and non-escaping part is, it doesn't confuse outside data with the admin command. If prepared statements work correctly, escaping every character is not necessary. It's an important note not to mention. Because parameterized characters already contain some escape of characters. 4. Firewall & Administrative Privilege A standard method to gain sensitive information via SQL injection is capturing the admin account itself. The administrator account holds all the right to delete, modify and insert data. Also, it can add an outsider with enough privilege to do as much as the admin account because it has the root access. Our recommendation is not to use an administrative account in the database. Other accounts with fair privileges as the administrator account hold similar threats. Each application should have its database for the safety of the whole web application. When creating accounts with more minor features, don't take away the privilege ticks; instead, give ticks that are solely important for the task. This way, it would be easy to monitor and maintain a steady and secure system. Firewalls are also vital to protect against SQL injections because they guard the database and the system even in the absence of human contact—predefined rules and procedures set by the standard SQL injection method help the firewall stay updated. Web Application Firewall ( ) monitors traffic and, most importantly, puts a barrier that works as a shield against low-level threats. It is easy to add policies and rules that bypass the firewall without prompting a false alarm. An excellent firewall solution is . They also roll out regular updates on what's new in the firewall department. The firewall generally blocks out SQL injections, cookie capture, parameter tampering and gives real-time analytic of the traffic data. WAF PTSecurity 5. Union & Password Hash keys are pretty important when it comes to SQL injection prevention methods. Summing up two or more queries in a single result is the work of the union key. These queries belong to the union row. Suppose A U B is a function. A has a set of {1,2,3} & B consists of {4,5}. If we use the general union formula, then it becomes {1,2,3,4,5}. This general principle can combine with more rows to give out the desired result, like in row 5, column 8. Yes, with this kind of accuracy, the union works. We can implement multiple queries in one union. Union On the other hand, to access a database, we need a password. The more secure the password, the harder it is to crack for an attacker. Simple passwords can be cracked concisely by brute-forcing, phishing, keylogging, and more ways. Though they need to be changed periodically, most of its definition depends on strength. Hashing password is kind of like encrypting. Various ways we can hash passwords, sh256, caching are some of the better ways. These are some of the primary ways to protect against SQL injections. Safe database management, placing dummy functions such as "dual" for testing purposes should be removed. Testing kits are for making things easy before live implementation. Also, server pinging should be off; it can be used as a attack rather than a SQL injection. But it benefits both simultaneously. DDoS Conclusion Certain aspects of protection against SQL injection welcome the safe practice of doing stuff. These can be maintaining awareness, employ verified mechanisms, automation blocking, and more. An attacker can quickly push multiple SQL injection sequences in a python script that runs very fast and cramp up more data than you think in a single sitting. Those codes are available in for testing and learning purposes only. These run tests only on permitted applications as a penetration tester or learning on your own VM. GitHub Allowing the most minorly privileged roles and listing inputs for validations would strongly argue against unethical injection. Also, this goes without saying, scanning for vulnerabilities alongside bug fixes is a typical task to stay protected against SQL injections. But the points we mentioned earlier in bold are the most important and primary ones. Using only the required applications to handle a task such as WAF can easily protect against SQL injections.

Top 5 Ways To Prevent SQL Injections

Elementor Page Builder is the very ultimate tool that enables anyone to create a website. In fact, the allows to build a professional website with no coding involved. So if you want to make a decent site in no time, then get on board! website creator . Read also previous Elementor Compatible Design Assets Collection Certainly, is compatible with a lot of useful plugins, which can make the process of building a site even easier. Today we are going to take a look at some of the . Shall we begin? Elementor best plugins for Elementor Element X MORE INFO Price: $11 This very plugin will equip you with dozens of widgets and templates that will make your website functional and pretty. The addon has such useful elements as Contact Form 7, Instagram, Price Menu, and many more. Besides, it is easy to work with, which is also a great advantage. Circle Progress MORE INFO Price: $17-39 (depending on the price plan you choose) Circle Progress is a plugin that will help you create fancy animations on your website. Besides, this Elementor addon will also be useful while working on your site’s background. Finally, Circle Progress comes with 41 JetElements widgets, which altogether makes it a perfect choice. JetElements MORE INFO Price: $17 JetElements is the ultimate bestseller and for a good reason. The plugin will provide you with multiple elements such as Advanced Carousel, Pricing Table, Countdown Table, and many more. Also, it is WooCommerce integrated. What else do you need for building a cool website? Animated Text MORE INFO Price: $17 It’s not a surprise that Animated Text widget will help you animate your text. This very plugin will allow you to add fancy animation effects to the text on your website. So make your site fancy with Animated Text. JetReviews MORE INFO Price: $15 Would you like to add a product review section to your website? Then JetReviews is the very plugin you need. This addon will equip you with top-notch review widgets for all types of websites. In addition to that, JetReviews is quite easy in use, which means that you can work with it by yourself. Smart Slider 3 MORE INFO Price: $35-250 Smart Slider 3 is a pretty useful Elementor plugin for those who want to make their website truly fancy. The plugin will help you create a unique and trendy design for your site. Besides, it has a lot of great customer reviews. JetWooBuilder MORE INFO Price: $15 JetWooBuilder is the way to go for those of you who need a decent e-commerce plugin. In fact, this very addon will allow you to create a decent online shop with no coding involved at all. The plugin comes with lots of WooCommerce widgets as well as various page layouts. What can be better for an online store? Unlimited Elements MORE INFO Price: $29.99-59.99 If you want to add more functionality to your website, Unlimited Elements is surely the way to go. The plugin comes with a great library that holds hundreds of useful widgets. Besides, all the elements are easy to customize according to your needs. JetEngine MORE INFO Price: $17 JetEngine is a perfect tool for adding and editing dynamic content. This very addon has such widgets as Dynamic Image, Dynamic Repeater, Dynamic Terms, and many more. So liven up your site with JetEngine plugin. HT Mega MORE INFO Price: free HT Mega is a package that holds over 80 unique elements and a pretty decent set of features. For instance, it comes with 360 blocks, more than 80 widgets, over 15 landing pages, blog and portfolio layouts. To cut long story short, HT Mega has pretty much everything for building a professional website. JetBlog MORE INFO Price: $15 Every decent website must have a blog and JetBlog plugin is the way to do that. Whether you want to add a blog to your corporate site or create a personal blog website, this very plugin will work perfectly for you. Equipped with Text Ticker, Video Playlist, and Smart List, JetBlog will help you create a stunning blog. Progress Bar MORE INFO Price: $17-39 Progress Bar is a useful Elementor plugin that will help you show progress values on your website. So make your site stylish and informative with Progress Bar addon. JetPopup MORE INFO Price: $15 JetPopup is a plugin that has the power to make your site fancy. In particular, it will help you create cool popups with special deals, important notifications, or ads. Besides, the plugin is easy to work with and highly customizable, so the user experience is going to be fun. Namogo MORE INFO Price: 26-128€ Namogo is an Elementor compatible plugin that will equip you with lots of widgets for your website. For instance, the tool comes with such widgets as Slide Menu, Video Player, Age Gate, and many more. So build a fully functional website with Namogo addon. JetBlocks MORE INFO Price: $15 Last, but surely not least, JetBlocks plugin. This very Elementor addon will enable you to create unique headers and footers. Besides, it has a great set of widgets including Login Form, Site Logo, Registration Form, and many more. Create a perfect website with JetBlocks addon! Final Thoughts Creating a decent website is actually a lot of work. Luckily, Elementor Page Builder is here and always ready to back you up. With Elementor you can easily and quickly build a professional website with no coding involved at all. Besides, there is a vast variety of great Elementor Page Builder addons that will help you create a truly fancy site. Disclaimer: I do not have a vested interest in any of the projects mentioned above.

Elementor Page Builder Addons [15+ Picks]

I have entered my credit card information hundreds of times on the internet. The credit card. I’m tired of pulling out my wallet every time I buy something so here’s a plea to the eCommerce world: please stop making me. same In this article, I’m going to make the case for allowing alternative payments with and Metamask for no cost to your business except the time to set it up. You should hear me out because and I’m sure it is currently costing you many. Ethereum payment processing shouldn’t cost you a dime was about logging into any website without passwords using Ethereum and Metamask — I suggest you read that one first. Note that while this article focuses on eCommerce, you can stick these payment buttons on any website (perhaps a tip box for your art blog?) and they will only be seen by Metamask users. Your mainstream audience won’t notice a difference. My last article Why Payment Processors Suck This shouldn’t be a surprise to anyone, but payment processors are businesses that exist to make money. Here are some reasons to not like them: They charge fees (usually 2–5%) They have high rates of fraud (e.g. customers charging back after receiving goods) It takes days for your funds to reach you Users need to fill in credit card information (come on guys, it’s 2017) still Your account can be frozen at any time (and it will be if, for some reason, they suspect you’re up to no good) Too bad you have to use them because there isn’t an alternative. Oh wait, there is! Why Ethereum is Awesome Just like any other , Ethereum can be used as a medium of exchange with Ethereum can actually do much more than be a medium of exchange, but that’s a topic for another day. cryptocurrency no central authority, settlement in seconds, no chargebacks, and 0% fees for the party receiving payment . Okay I hope you’re interested. Let’s write some code. You can follow along in this repo , where I have built a simple checkout component. How to use Ethereum as a Payment Processor Remember ? We’re going to set up a webpage displaying a super secret checkout that . Again, this is because Metamask injects into your browser. Everyone else will continue seeing your normal website, none the wiser that you have become hip to web 3.0. Metamask only users with a Metamask plugin will see web3 render(){if (web3){return (<metamaskCheckout/>);} else {return (<checkout/>);};} All we’re doing so far is rendering a component if we detect web3 in the browser. If not, we render the regular checkout, which looks like this: metamaskCheckout As I mentioned in my previous article, an Ethereum address can be used as a sort of username. Whenever the user signs a transaction of any kind, they are proving ownership of that address. This will come in handy later. components/MetaPay.jsx let { pay } = this.props;return (<Row><Col md={4}></Col><Col md={4}><center><h2>Checkout</h2><h5>Horray! You're a Metamask user.</h5><p>We'll give you the good stuff.</p><div><form><br/><FormGroup><FormControl type="text" value={pay.name} onChange={this.updateName.bind(this)}/>Name<FormControl type="text" value={pay.address} onChange={this.updateAddress.bind(this)}/>Address<FormControl type="text" value={pay.city} onChange={this.updateCity.bind(this)}/>City<FormControl type="text" value={pay.country} onChange={this.updateCountry.bind(this)}/>Country</FormGroup></form><br/><Button bsStyle="primary" bsSize="large" onClick={this.sendTxn.bind(this)}>Pay ${this.props.pay.usd_amt}</Button></div></center></Col></Row>); This component will render a form asking for the user’s physical address (this can be pre-filled via if the user has shopped with you before — bonus feature!). this.props When the user clicks pay button, it formats an Ethereum transaction and sends that to Metamask for the user to sign in their browser. The amount of ether to send will be based on the spot price of ether at the time (e.g. if ether is $50 and the product is $20, the transaction would read 0.4 ETH). Here’s what it looks like for the user: this Of course if the user doesn’t have enough ether, they won’t be able to pay you. ¯\_(ツ)_/¯ They buy ether though… can …with a credit card (oh, the irony). Anyway, note that the user pays a transaction fee of 1–10 cents to send ether and you pay nothing to receive it. You can find out why the user pays a fee if you’re interested. flat here actions/metaPay.js sendTxn(web3, ether, nonce) {return (dispatch) => {let user = web3.eth.accounts[0];let wei = ether * Math.pow(10, 18);let gasPrice = 3 * Math.pow(10, 9);let gasLimit = 30000;let rawTx = {nonce: `0x${nonce.toString(16)}`,gasPrice: `0x${gasPrice.toString(16)}`,gasLimit: `0x${gasLimit.toString(16)}`,from: user,to: this.owner_address,value: `0x${wei.toString(16)}`};web3.eth.sendTransaction(rawTx, (err, txHash) => {if (err) { console.log('Error sending txn:', err); }// Save the transaction hashyourAPI.saveOrder(rawTx, txHash);})}} Once the user signs the transaction, a callback is invoked that takes the transaction hash and stores it in your database for later use. It also stores the street address so the user doesn’t need to fill anything in next time. At this point, the user is done! No billing address. No credit card info. Just one click of the “Accept” button. Before Shipping It’s probably worth noting that while chargebacks are not possible, you need to make sure the transaction actually made it into the Ethereum . This usually takes 10–30 seconds, but I think a nice process would be to simply check before printing a shipping label (usually done minutes to hours later). do blockchain To get a transaction by its hash, you can use the Etherscan API (or, if you want to be a good Ethereum citizen, run your own node). Maybe I’ll cover more on how to interact with Ethereum in a later article — I don’t want to lose too many readers over it yet. Feel free to ping me if you’re implementing this and get stuck. admin/shipping.jsx function printMetamaskShippingLabel(order_id) {// Get the order info related to this transaction from your systemvar order = api.getOrder(order_id);// Make sure the transaction is on the blockchain and is legitvar on_chain_order = api.getMinedOrder(order.txHash);if (!order || order.value != on_chain_order.value) {return (<txNotMinedComponent>);} else {// Record that you printed the shipping labelapi.logShipment(data);// Show screen that can be printedreturn (<div>format your shipping label here...</div>);}} function render() {var id = this.props.order_id;var metamask_order = this.props.metamask_order;if (metmamask_order) {return printMetamaskShippingLabel(id);} else {return printShippingLabel(id);};} This component is seen by whomever is preparing the shipment. To prevent any fraud, your shipper will see a warning if the transaction isn’t mined yet or if it sent the wrong amount of ether (remember, your system logged the correct amount before). Otherwise, the shipping details are displayed as they normally would be. At this point, you can be 100% sure you got paid and you can display the label, print it, and ship your product. And the best part? No middleman cut into your profits. But what do I do with this Ether stuff? That’s a fair question. You may have noticed that you aren’t getting paid any dollars — you’re getting paid in ether. You may also know that cryptocurrencies are notoriously . volatile While I personally would recommend taking your payments in ether (See: ) I understand that everyone’s risk tolerance is different. historical ether price This is why companies exist that allow you to accept cryptocurrencies and get paid in dollars. Unfortunately, those companies also charge high fees and there’s really no reason to use them unless they bring in lots of new customers. . But remember, I told you this would be free It turns out you don’t actually need to use one of those services. You can do this yourself for very little work and almost no cost. And that’s the topic of my next article. Stay tuned! — If you enjoyed this article, or come join the community at You should also check out my company, , because we do awesome stuff. follow me on Twitter https://reddit.com/r/ethereum. ConsenSys Also, if you implement anything I’ve been talking about, tweet at me and I’ll let the community know. — P.S. While you’re waiting for my next article, I suggest getting your Metamask plugin at metamask.io and heading over to etherplay.io for some arcade games. No sign up is required and if you beat the high score, you make money! And in case you’re wondering, I don’t work on either of these products. “Pay With Metamask” image credit to Vlad Todirut

Add Secure, Fee-less, One-Click Payments to Any Website for Free

Scientific American, Volume XXXVI., No. 8, February 24, 1877 by Various, is part of the HackerNoon Books Series. You can jump to any chapter in this book . Annual Reports of the Patent Office here ANNUAL REPORT OF THE PATENT OFFICE. The annual report to Congress of the Commissioner of Patents, for the year 1876, has made its appearance. The amount received on applications for patents, reissues, designs, extensions, caveats, disclaimers, appeals, trade marks, labels, copies, etc., was $757,987.65. The amount paid for salaries was $425,930; other expenses, $226,612. Total payments, $652,542. Number of applications for patents during the year 1876 21,425 Number of patents issued, including reissues and designs 15,595 Number of applications for extension of patents 2 Number of patents extended 3 Number of caveats filed during the year 2,697 Number of patents expired during the year 814 Number of patents allowed but not issued for want of final fee 3,353 Number of applications for registering of trade marks 1,081 Number of trade marks registered 959 Number of applications for registering of labels 650 Number of labels registered 402 Of the patents granted there were to— Citizens of the United States 16,239 Subjects of Great Britain 511 Subjects of France 104 Subjects of other foreign governments 172 ——— Total 17,026 The number of applications for patents was a little less than during the previous year. The Commissioner suggests that Congress should appropriate $50,000 to promote the printing of the old patents; that additional examiners be employed, and more clerks, for the purpose of expediting the business of the office; that the price of the Official Gazette be reduced, also the fee for trade mark registration; that the library fund be increased; that more space be provided for models, and for the transaction of business. In respect to the Centennial, the value of new improvements, and the service of the Patent Office in stimulating discovery, the Acting Commissioner speaks as follows: "The display made at the Exposition by the Patent Office was creditable in every respect, and excited general attention. About 5,000 models of inventions, representing the leading branches of the arts and manufactures, were exhibited in suitable cases, and properly labeled, the various publications of the Office were displayed, its practice fully explained to all inquirers, and copies of the Patent Laws and the Office regulations and forms freely distributed. The knowledge of our patent system thus imparted to foreigners and all others unable to visit Washington has more than repaid the small cost attendant upon the representation. The exhibits were sent from and returned to the Office with scarcely any damage being suffered. "But the array of models, etc., made by the Patent Office at the Exposition was not needed to illustrate the value of our patent practice. The wisdom of that system was demonstrated in the most practical and triumphant manner in nearly every branch of that munificent enterprise. Not only in the grand display of labor-saving machinery, but in the vast collection of manufactured articles, and even in the department of fine arts, were seen the fruits of that provision in our Constitution giving to Congress the power 'to promote the progress of science and the useful arts by securing for limited times to authors and inventors the exclusive right to their respective writings and discoveries.' "Whatever persons may do in a 'perfect condition of society' in sharing, without price, the fruits of their labors with others, it must be apparent to the dullest observer that the wonderful growth of the useful arts in this country is due, thus far, to the protection given by our Government to property in inventions—a property as sacred as any other class of property, and whose value is determined by the same general law of supply and demand. "It may be safely said that two thirds of the manufacturing interests of the country are based upon patents, and the welfare of all such interests are intimately connected with the welfare of the patent system. During the past seven years a larger number of applications for patents were filed and patents granted than during the entire seventy-eight preceding years, reaching back to the enactment of the first patent law. The needs of the Office have advanced in proportion to this sudden and vast increase of work, but have been but partly supplied. Nay, in fact, its already scanty force and accommodations have been actually reduced at a time when most required. If these vast interests, and the future promotion of science and the useful arts are to be encouraged, a liberal recognition must be made of the wants of this Office. "The Examining Corps, the duties in which are most arduous and exacting, comprises gentlemen of legal, as well as scientific, attainments. It should be re-inforced by more of the same character. They should be relieved, by legislation, of continual embarrassment by reason of meager salaries and fears of removal incident to merely political changes. The Office would then be spared the continual loss of its most experienced and efficient men." About HackerNoon Book Series: We bring you the most important technical, scientific, and insightful public domain books. This book is part of the public domain. Various (2006). Scientific American, Volume XXXVI., No. 8, February 24, 1877. Urbana, Illinois: Project Gutenberg. Retrieved https://www.gutenberg.org/cache/epub/19406/pg19406-images.html This eBook is for the use of anyone anywhere at no cost and with almost no restrictions whatsoever. You may copy it, give it away or re-use it under the terms of the Project Gutenberg License included with this eBook or online at , located at www.gutenberg.org https://www.gutenberg.org/policy/license.html

ANNUAL REPORT OF THE PATENT OFFICE

Of the Greek philosophers in Alexandria; and how I had discourse with Philo the Alexandrine

HUSBANDS AND WIVES

In addition to being the CEO of Zelwin, Ph.D., founded Private Business Club for VCs and angel investors. Nikolay Shkilev, Over the years, he has distinguished himself as a leading innovator in the blockchain industry, participating in dozens of multi-million dollar projects worldwide, helping crypto projects as a strategic advisor and mentor, and serving as an honorary speaker at many international events. Nikolay has grown into a vast ecosystem that helps startups at all stages. Zelwin It was not easy to find free time with Mr. Shkilev for an interview, but I still managed to do it. Mr. Shkilev, let me thank you for honoring my invitation. I would like to start with a question about the Private Business Club if you don't mind. Sure, no problem First of all, tell us about your Private Business Club - is it a DAO? Private Business Club is a club for VCs, founders, and C-Level only. In the club, you have people from different spheres: VCs, exchanges, bankers, investment companies, Rolls-Royce members, family offices, and many others. It is where owners, founders, CEO, and top management of companies can speak freely without any spam or ads. With free advice and suggestions. We offer investment ideas beyond classic wealth management and these have to do with global networking (EU, Asia, USA, CIS, LatAm, Mena, etc.), best IT & blockchain projects, advisory & mentoring services, Investments with a faster exit strategy and projects with the highest ROI directly from owners. Who is qualified to be a member of the Club? In our Private Business Club, there are more than 500 team members in total. Some of the team members from Curve, Black Dragon, GDA Capital, Huobi, KuCoin, Gate_io, Kraken, MEV Capital, Cointelegraph, Afford Capital, French Blockchain Federation, FH Capital, Oddiyana Ventures, Lavaliere Capital, Mensis Capital, Olymp Capital, Allied Venture Partners, BitForex, Da Vinci Capital Partners, Infodriver Capital, Royal Family Offices from UAE and Kingdom of Bhutan, and many more. And as we are constantly expanding our list, we make a very strict selection so that only the right people are in the club. To join our Club you must be a VC, Investor, or big name in the crypto sphere. For DD and verification, you can send an inquiry to my personal Linkedin introducing yourself and your social networks and media. Quite impressive! Now, can you tell us about Zelwin? Zelwin is providing one-stop solutions for startups at different stages. We created ready-made products, such as MVP labs, a launchpad for pre-Sale/IDO, a marketing hub, and a fiat-crypto payment wallet, and we provide payment solutions, a crypto-friendly marketplace for goods, OTC deals (on-ramp, off-ramp), and fundraising and advisory services. What inspired you to build Zelwin? Thousands of startups are created every year, but most of them do not have the requisite experience, connections, and competent marketing. And as a result, 97% die before listing on any exchange (62% die after listing within 6-12 months). With Zelwin, we decided to provide a one-stop solution. Crypto projects no longer need to throw away their time and money into a black hole and look for hundreds of providers. We are helping to fill the market gap in three different ways. One, from idea to product. We test business hypotheses, build an MVP, help with development & graphics, check and create tokenomics, and White Paper, and we offer advisory services, strategy, etc. Two, helping with seed, which involves pre-sale, and IDO. This is where we do marketing boost, fundraising, and leverage our connections with VCs, 450 plus media outlets, 1000 plus KOLs & Influencers, and build community on social media. And three, listing on crypto exchanges. We fast-track listing on exchanges and verifications on main platforms. We also provide a fiat-crypto payment solution. I initially thought ZelWin Finance was only an IDO launchpad. How big is its ecosystem? Launchpad is an important but small part of our ecosystem. At the moment, we have more than 150 active customers or active project partners, if you like. But we plan to increase this number to several thousand projects annually. For so many projects, you will need a huge number of employees. That's right! We are creating a separate portal for Zelwin Agency, which is going to be a one-stop online store where our customers can immediately see hundreds of services, and thousands of bloggers, with prices and choose for themselves any service or services with delivery within 24-48 hours. In the crypto market, we do not yet have something like this, especially on such a massive scale. Separately, we launched the Ambassador Program, where there are already 35 people from all over the world, and we plan to expand our network to 300-400 ambassadors. And we are always! What is the Ambassador Program about? How to join you? Sure. Our rule and conditions are very simple: each ambassador receives from 10% to 15% of each deal closed. But to be eligible, he or she needs to sell our services and bring viable projects to Zelwin. And as for the training, there are instructors to guide our ambassadors, we provide free training, provide sales scripts, and help at all stages, including in groups, chats, and calls. https://www.youtube.com/watch?v=HwkyIQbsmrQ&embedable=true In terms of security, how are investors using Zelwin launchpad protected We protect all our investors in any project as an escrow agent! We allow crypto projects to send us their tokens before TGE (Listing). The projects can receive their investments only after TGE (Listing), but if a project doesn't get listed on the exchange(s)we partner with, we return all investment to our investors. We have had projects where a large chunk of the profit went to our participants. And how do you keep track of promising projects that are going to be listed on crypto exchanges? I highly recommend you subscribe and use our Smart Telegram Bot. This is where you will be able to receive all the news and announcements. Moreover, there you can play games, complete various tasks and receive nice bonuses and rewards from us. For example, we are now launching a large Trading Competition for a $200,000 prize pool. Only those who are subscribed to our Telegram Bot can receive rewards. We also regularly hold AMAs and other activities on our social networks on Telegram and Twitter. Thank you for your answers. I have learned a lot myself! What would you like to say to our readers? Never give up, and never invest in only one project. And remember that there are many opportunities in the world to earn money and our ecosystem allows investors, projects, and Ambassadors to do this. Take care of yourself and we are waiting for you!

Exclusive Interview With Zelwin CEO Nikolay Shkilev

HAWKINS IN FLORIDA

SECONDARY SEXUAL CHARACTERS OF MAN

They say, once you come to Georgia, you find yourself reluctant to leave. This stunning country – particularly attractive with sunny weather, scenic mountains, and of course, exceptional wine – has not only incredible nature and rich culture, but also all chances to become another cradle of fintech and blockchain. In 2020, Georgia 7 among 190 economies in the ease of doing business, which made over 50,000 tech specialists relocate here during the last couple of years. What’s far more exciting is that the Georgian government has a good attitude toward cryptocurrencies, and is already hard at work on a legal framework to support mass adoption. was ranked Today, thousands of crypto freelancers are working internationally from Georgia, and it’s therefore not surprising that Tbilisi finally became one more meeting point for investors, C-level executives, developers, and creators involved in Web3. They all flocked to , the first-ever international Web3 conference in the Caucasian region, on October 22-23. Presented to the wide audience as a combination of GameFi and DeFi, the event boasted a total of 8-panel discussions on its business agenda, over 70 speakers and industry experts as well as 50+ sponsors and exhibitors showcasing their innovative products. DeGameFi In this article, I’ll provide a deep look into what happened throughout these two days at the Sheraton Grand Metechi Palace hotel and highlight the most insightful events. Let’s buckle up! Overview of DeGameFi DeGameFi is the first Georgian community-based company with a goal of bridging the worlds of Web2 and Web3. DeGameFi’s team started with a monthly series of gatherings, such as meet-ups, hackathons, and workshops, aimed at popularizing blockchain technologies and helping traditional businesses transit to the new era of finance. And now, thanks to the growing interest in cryptocurrencies among Georgian companies and institutions, DeGameFi has grown to a large-scale conference attended by over 1,000 Web3 enthusiasts from different regions. Source: Twitter Combining the most engaging formats and activities for networking and knowledge sharing, the event offered to visit 6 main sections so that each participant could fully immerse into the Web3 environment: Conference hall; Exhibition floor for business; Tech room; NFT gallery; Start-up competition; VIP area. Apart from that, there were various gatherings, workshops, contests, and tech talks available during the conference. No matter whether you are a VC, entrepreneur, developer or artist, here you would find many promising opportunities and projects for mutual cooperation. Fun fact: DeGameFi even invited community members to join the conference online at the Decentraland. At DeGameFi, I caught up with a few fellows who I asked to share their impressions of the event. Among them were Konstantin Gorin, Head of Support at and , Elena Shiltseva, CPO at , as well as Mike Ermolaev and Gennadii Bazhukov from . They all agreed that the conference was organized at a very good level and laid the groundwork for a brand-new way of interaction between crypto supporters in Georgia and the CIS. Cryptopay NearPay Roketo Business Kikimora Labs “The Covid-19 pandemic and the ongoing international upheavals made us almost forget this wonderful atmosphere of face-to-face meetings where the most innovative ideas are born. DeGameFi reminded us how vital the offline events are in the crypto industry and the scale of the conference ideally suited to the establishment of fruitful connections,” notes Konstantin Gorin. Source: Twitter “It was really great to meet so many local guys at DeGameFi. Even the Bank of Georgia got on board and showcased its Web3 projects, which demonstrates that the technology is here to stay and regulators are keeping their hands on the pulse. The Georgian crypto community is developing at a rapid pace, and the conference has proven it true,” adds Elena Shiltseva. Gennadii, in charge of Business Development of Kikimora Labs, was struck with the geography of participating companies and individuals: “We ran into attendees not only from Georgia, but also from the USA, Great Britain, South Korea, and China. I’d like to separately note that the venue was selected perfectly, which contributed significantly to effective networking. I, personally, partnered with a few investors and found some interesting projects that are worth attention.” Mike, who is Head of PR & Content at Kikimora Labs, was impressed by the various interactives related to GameFi. “The NFT gallery was a wrap! An amazing place for artists to catch some inspiration, and I think that even those who still feel skeptical about NFTs couldn’t remain indifferent. Besides, the presence of brands promoting gamification was huge. The participants were welcomed to try various activities like playing blockchain-based games with underlying NFT economics to assess the potential themselves,” he shares. Source: Twitter But what really wowed everyone is the high quality of expert content delivered on the main stage and a stir around panel discussions devoted to trending topics in Web3. So let’s get to it. Speaker Lineup And Panels The two-day agenda was tailored to ingesting insights from multiple directions of the DeFi development: from crypto payments and decentralized marketplaces to metaverses, Web3 investment strategies and marketing specifics. Source: DeGameFi.io DeGameFi brought on stage the best and the brightest minds from both Georgia and global markets, including: Mikheil Didebulidze, partner at VNTR Capital, founder of DeGameFi; Tone Vays, analyst, derivatives trader, influencer and event producer; Levan Kobakhidze, CDO at Bank of Georgia; Max Krupyshev, CEO CoinsPaid & ; Cryptoprocessing.com Iouri Galitchenko, strategic partnership Binance Pay&Card; Colin Donohue, director of Startup Connect & Startup Grind; Eralp Hatipoglu, co-founder & CEO at CityPay, and more. “The quality of dialogue between the keynote experts and attendees was excellent. I was pleasantly surprised by a high level of speakers who shared their comprehensive views on the current Web3 trends and challenges. This once again demonstrated that Georgia as a crypto hub is full of forward-thinking individuals and entities,” says Gennadii Bazhukov. A peculiar feature of DeGameFi was a number of panel discussions featuring the most pressing issues that the DeFi and Web3 industry is facing today. I’d like to point out those panels that, from my point of view, were the hottest and the most buzzing. Web 3.0 payments from past to present: how are traditional banks keeping up? - Panel : George Gvazava (CryptX), Levan Kobakhidze (Bank of Georgia), Iouri Galitchenko (Binance Pay & Card), Eralp Hatipoglu (CityPay), Max Krupyshev (CoinsPaid) : Max Novak from MyNearWallet : The impact of regulations on the DeFi ecosystem; the prospects of CBDCs and stablecoins; the latest efforts to bridge banks and crypto made by payment giants like Mastercard; tokenization and interoperability; obstacles to mainstream adoption of DeFi; Web3 for businesses; metaverses and what banks can offer in this visual world. Panel: Web 3.0 payments from past to present: how are traditional banks keeping up? Experts Moderator Topics : David Chikhladze (OWNIC), Zeshan Ahmad (P360), Michael Holden (Maxihaxi) : Konstantin Gorin from NearPay and Cryptopay Panel: Sports 3.0 - new era for sports entities Experts Moderator : The driving force behind Web3 initiatives in sport; crowd communication models; integrating blockchain and web3 technologies to sports – collaboration or rivalry; engaging huge fan bases and adoption issues. Topics Sports 3.0 - new era for sports entities - Panel : Manuel Rensink (Fathom Protocol), Ioseb Bolqvadze ( , & OneSoft), Lasha Antadze (Rarify) : Maria Reshetnik from : Current and potential barriers to DeFi prosperity; emerging trends; risks posed by tightening regulations; the convergence between DeFi and TradFi; the most pressing real-life use cases that DeFi can bring. Panel: The evolution and the future of DeFi Experts Cryptal.com Cryptomat.com Moderator FutureComes Topics : Amirsan Roberto (Sinofy Group), Kirill Mishanin (Infodriver Capital), Vojta Rocek (Presto Ventures), Sergi Gvarjaladze (Kettari Foundation), Gvantsa Baidoshvili (Revenue Capital) : Maria Reshetnik from FutureComes : Investment trends and strategies in the crypto/blockchain segment; red flags during the investment process; investing in DAOs – pros and cons. Panel: A VC's guide: institutional decentralization and investments Experts Moderator Topics : Mikheil Didebulidze (VNTR Capital), Eralp Hatipoglu (CityPay), Colin Donohue (Startup Connect & Startup Grind), Levan Khomeriki (Two Point Zero) : Mike Ermolaev from Kikimora Labs : The reasons for decline of Web3 startup funding; the most popular areas of investment; the pitfalls of investing in the play-to-earn projects and metaverses; leading countries in Web3; investment DAOs; the role of crypto marketing in 2022-2023; the legitimacy of Web3. Panel: Web3 start-up ecosystem: current state Experts Moderator Topics Mike Ermolaev and Colin Donohue “The DeGameFi panels were always full houses. I moderated the discussion that was devoted to the Web3 start-up ecosystem and it definitely collected more than a hundred of viewers. The hall was packed; every seat was occupied and people had to stand behind. Unbelievable!” comments Mike Ermolaev. Tech Room, Afterparty And Side Events The agenda of the tech room, also positioned as an additional educational space, was focused more on technology-oriented speeches and presentations of infrastructure solutions. Elena Shiltseva who commanded the scene there shares her feedback on the host experience: “Except for participating at DeGameFi as a speaker of the main stage where I talked about the role of a CFO in the process of transiting from Web2 to Web3, I had a great pleasure to host the tech room section. The key benefit of this role was greeting many talented people in the blockchain industry on stage and gaining maximum knowledge about innovations that are emerging in this field. I’m still thrilled by the atmosphere, and of course, I’d like to say massive thanks to the organizers who made my job of hosting super easy!” Elena Shiltseva hosting the tech room section Elena also shared with me her own shortlist of the top 4 speakers who rocked the tech room with their valuable and fundamental reports. First, she mentioned Max Sultakov, CEO of Mover, who talked about technical and economic aspects of going cross-chain on high-performance L1s. Then Elena proceeded to Vladimir Prosvirkin, founder of Aspis, who explained why DAOs will replace legal entities and how to create a successful decentralized autonomous organization. Her other favorite was Avtandil Kutchava with a practical report on crypto regulations in Europe and Georgia. And finally, she got inspired by the speech of charismatic Alexander Wendt from Trend Vision who showed with real examples, why high-quality PR efforts are essential for start-ups and how not to fail when putting them into practice. “These were amazing applied reports, the perfect examples of how tech-related speeches should be prepared and presented,” Elena concludes. Today’s events cannot do without entertainment, thus maintaining the perfect balance between work and pleasure. DeGameFi partnered with the world’s biggest Web3 conference WOW Summit to give 100+ VIP ticket holders unforgettable emotions and exclusive networking opportunities at the end of the event. The afterparty took place at Axis Tower's Sky Bar where representatives of the international and local funds, CEOs of the most promising projects, and local state institutions enjoyed music, fine drinks, snacks, and enchanting panoramic views over the night Tbilisi. DeGameFi x WOW Summit Afterparty The list of side events also included VIP dinner and investor’s breakfast, sponsored by Kikimora Labs. The latter gathered together a few dozen people who are involved in the most promising niches, such as SpaceTech, or look for tech innovations to co-invest in, particularly on the Georgian market. “We connected with the global Web3 community, made a lot of networking pics and really had fun attending both the investor’s breakfast and the afterparty. The beauty of these events lies in their exclusive status that ensures the presence of your target audience, reliable partnerships and fantastic experience sharing. And let’s face it, talking business is much more enjoyable when getting together either over coffee or drinks,” says Mike Ermolaev laughing. Final Thoughts Driven by the mission to support the growth of the crypto community in Georgia, DeGameFi took the first step towards bridging traditional business and Web 3 in a solid and transparent way. Given that the country is currently in the process of making itself a fintech and crypto hub, the events under the DeGameFi brand will most likely become annual and will honor the progress achieved with attempts to foster blockchain adoption en masse.

DeGameFi Conference in Tbilisi: Introducing a New Crypto Hub to the Web3 Community

An Essay Concerning Humane Understanding, Volume I: Book II, Chapter XXVIII.

The Dark Side of Antri

El lado oscuro de Antri

Le côté obscur d'Antri

Antri . का डार्क साइड

アントリのダークサイド

O Lado Negro de Antri

Mặt tối của Antri

安特里的黑暗面

Second Treatise of Government: Chapter XIX

Second Treatise of Government by John Locke is part of HackerNoon’s Book Blog Post series. You can jump to any chapter in this book here . Chapter XI - Of The Extent of the Legislative Power Chapter XI: OF THE EXTENT OF THE LEGISLATIVE POWER THE great end of men’s entering into society, being the enjoyment of their properties in peace and safety, and the great instrument and means of that being the laws established in that society; the first and fundamental positive law of all commonwealths is the establishing of the legislative power; as the first and fundamental natural law, which is to govern even the legislative itself, is the preservation of the society, and (as far as will consist with the public good) of every person in it. This legislative is not only the supreme power of the commonwealth, but sacred and unalterable in the hands where the community have once placed it; nor can any edict of any body else, in what form soever conceived, or by what power soever backed, have the force and obligation of a law, which has not its sanction from that legislative which the public has chosen and appointed: for without this the law could not have that, which is absolutely necessary to its being a law,* the consent of the society, over whom no body can have a power to make laws, but by their own consent, and by authority received from them; and therefore all the obedience, which by the most solemn ties any one can be obliged to pay, ultimately terminates in this supreme power, and is directed by those laws which it enacts: nor can any oaths to any foreign power whatsoever, or any domestic subordinate power, discharge any member of the society from his obedience to the legislative, acting pursuant to their trust; nor oblige him to any obedience contrary to the laws so enacted, or farther than they do allow; it being ridiculous to imagine one can be tied ultimately to obey any power in the society, which is not the supreme. Sect. 134. (*The lawful power of making laws to command whole politic societies of men, belonging so properly unto the same intire societies, that for any prince or potentate of what kind soever upon earth, to exercise the same of himself, and not by express commission immediately and personally received from God, or else by authority derived at the first from their consent, upon whose persons they impose laws, it is no better than mere tyranny. Laws they are not therefore which public approbation hath not made so. Hooker’s Eccl. Pol. l. i. sect. 10. Of this point therefore we are to note, that such men naturally have no full and perfect power to command whole politic multitudes of men, therefore utterly without our consent, we could in such sort be at no man’s commandment living. And to be commanded we do consent, when that society, whereof we be a part, hath at any time before consented, without revoking the same after by the like universal agreement. Laws therefore human, of what kind so ever, are available by consent. Ibid.) Though the legislative, whether placed in one or more, whether it be always in being, or only by intervals, though it be the supreme power in every commonwealth; yet: Sect. 135. First, It is not, nor can possibly be absolutely arbitrary over the lives and fortunes of the people: for it being but the joint power of every member of the society given up to that person, or assembly, which is legislator; it can be no more than those persons had in a state of nature before they entered into society, and gave up to the community: for no body can transfer to another more power than he has in himself; and no body has an absolute arbitrary power over himself, or over any other, to destroy his own life, or take away the life or property of another. A man, as has been proved, cannot subject himself to the arbitrary power of another; and having in the state of nature no arbitrary power over the life, liberty, or possession of another, but only so much as the law of nature gave him for the preservation of himself, and the rest of mankind; this is all he doth, or can give up to the commonwealth, and by it to the legislative power, so that the legislative can have no more than this. Their power, in the utmost bounds of it, is limited to the public good of the society. It is a power, that hath no other end but preservation, and therefore can never have a right to destroy, enslave, or designedly to impoverish the subjects.* The obligations of the law of nature cease not in society, but only in many cases are drawn closer, and have by human laws known penalties annexed to them, to inforce their observation. Thus the law of nature stands as an eternal rule to all men, legislators as well as others. The rules that they make for other men’s actions, must, as well as their own and other men’s actions, be conformable to the law of nature, i.e. to the will of God, of which that is a declaration, and the fundamental law of nature being the preservation of mankind, no human sanction can be good, or valid against it. (*Two foundations there are which bear up public societies; the one a natural inclination, whereby all men desire sociable life and fellowship; the other an order, expresly or secretly agreed upon, touching the manner of their union in living together: the latter is that which we call the law of a common-weal, the very soul of a politic body, the parts whereof are by law animated, held together, and set on work in such actions as the common good requireth. Laws politic, ordained for external order and regiment amongst men, are never framed as they should be, unless presuming the will of man to be inwardly obstinate, rebellious, and averse from all obedience to the sacred laws of his nature; in a word, unless presuming man to be, in regard of his depraved mind, little better than a wild beast, they do accordingly provide, notwithstanding, so to frame his outward actions, that they be no hindrance unto the common good, for which societies are instituted. Unless they do this, they are not perfect. Hooker’s Eccl. Pol. l. i. sect. 10.) Secondly, The legislative, or supreme authority, cannot assume to its self a power to rule by extemporary arbitrary decrees, but is bound to dispense justice, and decide the rights of the subject by promulgated standing laws, and known authorized judges:* for the law of nature being unwritten, and so no where to be found but in the minds of men, they who through passion or interest shall miscite, or misapply it, cannot so easily be convinced of their mistake where there is no established judge: and so it serves not, as it ought, to determine the rights, and fence the properties of those that live under it, especially where every one is judge, interpreter, and executioner of it too, and that in his own case: and he that has right on his side, having ordinarily but his own single strength, hath not force enough to defend himself from injuries, or to punish delinquents. To avoid these inconveniences, which disorder men’s propperties in the state of nature, men unite into societies, that they may have the united strength of the whole society to secure and defend their properties, and may have standing rules to bound it, by which every one may know what is his. To this end it is that men give up all their natural power to the society which they enter into, and the community put the legislative power into such hands as they think fit, with this trust, that they shall be governed by declared laws, or else their peace, quiet, and property will still be at the same uncertainty, as it was in the state of nature. Sect. 136. (*Human laws are measures in respect of men whose actions they must direct, howbeit such measures they are as have also their higher rules to be measured by, which rules are two, the law of God, and the law of nature; so that laws human must be made according to the general laws of nature, and without contradiction to any positive law of scripture, otherwise they are ill made. Hooker’s Eccl. Pol. l. iii. sect. 9. To constrain men to any thing inconvenient doth seem unreasonable. Ibid. l. i. sect. 10.) Absolute arbitrary power, or governing without settled standing laws, can neither of them consist with the ends of society and government, which men would not quit the freedom of the state of nature for, and tie themselves up under, were it not to preserve their lives, liberties and fortunes, and by stated rules of right and property to secure their peace and quiet. It cannot be supposed that they should intend, had they a power so to do, to give to any one, or more, an absolute arbitrary power over their persons and estates, and put a force into the magistrate’s hand to execute his unlimited will arbitrarily upon them. This were to put themselves into a worse condition than the state of nature, wherein they had a liberty to defend their right against the injuries of others, and were upon equal terms of force to maintain it, whether invaded by a single man, or many in combination. Whereas by supposing they have given up themselves to the absolute arbitrary power and will of a legislator, they have disarmed themselves, and armed him, to make a prey of them when he pleases; he being in a much worse condition, who is exposed to the arbitrary power of one man, who has the command of 100,000, than he that is exposed to the arbitrary power of 100,000 single men; no body being secure, that his will, who has such a command, is better than that of other men, though his force be 100,000 times stronger. And therefore, whatever form the commonwealth is under, the ruling power ought to govern by declared and received laws, and not by extemporary dictates and undetermined resolutions: for then mankind will be in a far worse condition than in the state of nature, if they shall have armed one, or a few men with the joint power of a multitude, to force them to obey at pleasure the exorbitant and unlimited decrees of their sudden thoughts, or unrestrained, and till that moment unknown wills, without having any measures set down which may guide and justify their actions: for all the power the government has, being only for the good of the society, as it ought not to be arbitrary and at pleasure, so it ought to be exercised by established and promulgated laws; that both the people may know their duty, and be safe and secure within the limits of the law; and the rulers too kept within their bounds, and not be tempted, by the power they have in their hands, to employ it to such purposes, and by such measures, as they would not have known, and own not willingly. Sect. 137. Thirdly, The supreme power cannot take from any man any part of his property without his own consent: for the preservation of property being the end of government, and that for which men enter into society, it necessarily supposes and requires, that the people should have property, without which they must be supposed to lose that, by entering into society, which was the end for which they entered into it; too gross an absurdity for any man to own. Men therefore in society having property, they have such a right to the goods, which by the law of the community are their’s, that no body hath a right to take their substance or any part of it from them, without their own consent: without this they have no property at all; for I have truly no property in that, which another can by right take from me, when he pleases, against my consent. Hence it is a mistake to think, that the supreme or legislative power of any commonwealth, can do what it will, and dispose of the estates of the subject arbitrarily, or take any part of them at pleasure. This is not much to be feared in governments where the legislative consists, wholly or in part, in assemblies which are variable, whose members, upon the dissolution of the assembly, are subjects under the common laws of their country, equally with the rest. But in governments, where the legislative is in one lasting assembly always in being, or in one man, as in absolute monarchies, there is danger still, that they will think themselves to have a distinct interest from the rest of the community; and so will be apt to increase their own riches and power, by taking what they think fit from the people: for a man’s property is not at all secure, tho’ there be good and equitable laws to set the bounds of it between him and his fellow subjects, if he who commands those subjects have power to take from any private man, what part he pleases of his property, and use and dispose of it as he thinks good. Sect. 138. But government, into whatsoever hands it is put, being, as I have before shewed, intrusted with this condition, and for this end, that men might have and secure their properties; the prince, or senate, however it may have power to make laws, for the regulating of property between the subjects one amongst another, yet can never have a power to take to themselves the whole, or any part of the subjects property, without their own consent: for this would be in effect to leave them no property at all. And to let us see, that even absolute power, where it is necessary, is not arbitrary by being absolute, but is still limited by that reason, and confined to those ends, which required it in some cases to be absolute, we need look no farther than the common practice of martial discipline: for the preservation of the army, and in it of the whole commonwealth, requires an absolute obedience to the command of every superior officer, and it is justly death to disobey or dispute the most dangerous or unreasonable of them; but yet we see, that neither the serjeant, that could command a soldier to march up to the mouth of a cannon, or stand in a breach, where he is almost sure to perish, can command that soldier to give him one penny of his money; nor the general, that can condemn him to death for deserting his post, or for not obeying the most desperate orders, can yet, with all his absolute power of life and death, dispose of one farthing of that soldier’s estate, or seize one jot of his goods; whom yet he can command any thing, and hang for the least disobedience; because such a blind obedience is necessary to that end, for which the commander has his power, viz. the preservation of the rest; but the disposing of his goods has nothing to do with it. Sect. 139. It is true, governments cannot be supported without great charge, and it is fit every one who enjoys his share of the protection, should pay out of his estate his proportion for the maintenance of it. But still it must be with his own consent, i.e. the consent of the majority, giving it either by themselves, or their representatives chosen by them: for if any one shall claim a power to lay and levy taxes on the people, by his own authority, and without such consent of the people, he thereby invades the fundamental law of property, and subverts the end of government: for what property have I in that, which another may by right take, when he pleases, to himself? Sect. 140. Fourthly, The legislative cannot transfer the power of making laws to any other hands: for it being but a delegated power from the people, they who have it cannot pass it over to others. The people alone can appoint the form of the commonwealth, which is by constituting the legislative, and appointing in whose hands that shall be. And when the people have said, We will submit to rules, and be governed by laws made by such men, and in such forms, no body else can say other men shall make laws for them; nor can the people be bound by any laws, but such as are enacted by those whom they have chosen, and authorized to make laws for them. The power of the legislative, being derived from the people by a positive voluntary grant and institution, can be no other than what that positive grant conveyed, which being only to make laws, and not to make legislators, the legislative can have no power to transfer their authority of making laws, and place it in other hands. Sect. 141. These are the bounds which the trust, that is put in them by the society, and the law of God and nature, have set to the legislative power of every commonwealth, in all forms of government. Sect. 142. First, They are to govern by promulgated established laws, not to be varied in particular cases, but to have one rule for rich and poor, for the favourite at court, and the country man at plough. Secondly, These laws also ought to be designed for no other end ultimately, but the good of the people. Thirdly, They must not raise taxes on the property of the people, without the consent of the people, given by themselves, or their deputies. And this properly concerns only such governments where the legislative is always in being, or at least where the people have not reserved any part of the legislative to deputies, to be from time to time chosen by themselves. Fourthly, The legislative neither must nor can transfer the power of making laws to any body else, or place it any where, but where the people have. About HackerNoon Book Series: We bring you the most important technical, scientific, and insightful public domain books. This book is part of the public domain. Locke, John, 2003. Second Treatise of Government. Urbana, Illinois: Project Gutenberg. Retrieved April 2022 from https://www.gutenberg.org/files/7370/7370-h/7370-h.htm#CHAPTER_XI This eBook is for the use of anyone anywhere at no cost and with almost no restrictions whatsoever. You may copy it, give it away or re-use it under the terms of the Project Gutenberg License included with this eBook or online at www.gutenberg.org , located at https://www.gutenberg.org/policy/license.html .

Second Treatise of Government: Chapter XI 

Second Treatise of Government: Chapter VII 

Second Treatise of Government: Chapter VI 

In a I was explaining the basics of setting up GO application for REST API. Now I'll go into details by first creating configurable server, adding http router (mux) and some DB interaction. Let's get (the party) started! previous post indoors The application is now running in docker, can respond to code changes and reload for instant feedback. For handling http requests I will add another dependency, http router (mux). You can read more about it . here This is a lightweight, high performance HTTP request router that is easy to use and has everything most api's will need. $ go get -u github.com/julienschmidt/httprouter Time to create the server. I'll place it in directory as it could potentially be reused: pkg/ server ( ) Server {
	srv *http.Server
} { &Server{
		srv: &http.Server{},
	}
} {
	s.srv.Addr = addr s
} {
	s.srv.ErrorLog = l s
} {
	s.srv.Handler = router s
} { (s.srv.Addr) == { errors.New( )
	} s.srv.Handler == { errors.New( )
	} s.srv.ListenAndServe()
} { s.srv.Close()
} package import "errors" "log" "net/http" "github.com/julienschmidt/httprouter" type struct * func Get () Server return * func (s *Server) WithAddr (addr ) string Server return * func (s *Server) WithErrLogger (l *log.Logger) Server return * func (s *Server) WithRouter (router *httprouter.Router) Server return func (s *Server) Start () error if len 0 return "Server missing address" if nil return "Server missing handler" return func (s *Server) Close () error return As usual, function returns pointer to our server instance that exposes some public methods that are pretty self explanatory. It will become more obvious when I put this server to work in the main program. Get Server will need routes and handlers to communicate with outside world. I'll add that next: router ( ) {
	mux := httprouter.New()
	mux.GET( , getuser.Do(app)) mux
} // cmd/api/router/router.go package import "github.com/boilerplate/cmd/api/handlers/getuser" "github.com/boilerplate/pkg/application" "github.com/julienschmidt/httprouter" * . func Get (app *application.Application) httprouter Router "/users" return getuser ( ) { {
		fmt.Fprintf(w, )
	}
} // cmd/api/handlers/getuser/getuser.go package import "fmt" "net/http" "github.com/boilerplate/pkg/application" "github.com/julienschmidt/httprouter" . func Do (app *application.Application) httprouter Handle return func (w http.ResponseWriter, r *http.Request, ps httprouter.Params) "hello" I define all my routes in and call handlers by explicitly passing application configuration so that each handler has access to things like database, configuration with env vars and more. router.go I keep my handlers separate from router and group them under sub folders . One reason is that handler will have corresponding test file. It will also have multiple middleware files that will also have tests and there can be a lot of handlers. If not grouped correctly, it can get out of hand very fast. cmd/api/handlers/{handlerName} Now there are few more building blocks: server, router, logger. Let's assemble it all in the main program: main ( ) { err := godotenv.Load(); err != {
		logger.Info.Println( )
	}

	app, err := application.Get() err != {
		logger.Error.Fatal(err.Error())
	}

	srv := server.
		Get().
		WithAddr(app.Cfg.GetAPIPort()).
		WithRouter(router.Get(app)).
		WithErrLogger(logger.Error) {
		logger.Info.Printf( , app.Cfg.GetAPIPort()) err := srv.Start(); err != {
			logger.Error.Fatal(err.Error())
		}
	}()

	exithandler.Init( { err := srv.Close(); err != {
			logger.Error.Println(err.Error())
		} err := app.DB.Close(); err != {
			logger.Error.Println(err.Error())
		}
	})
} // cmd/api/main.go package import "github.com/boilerplate/cmd/api/router" "github.com/boilerplate/pkg/application" "github.com/boilerplate/pkg/exithandler" "github.com/boilerplate/pkg/logger" "github.com/boilerplate/pkg/server" "github.com/joho/godotenv" func main () if nil "failed to load env vars" if nil go func () "starting server at %s" if nil func () if nil if nil New things to mention is that I assemble the server by chaining method calls and setting properties on the instance. One interesting thing is , this is just to instruct the server to use my custom logger for consistency. WithErrLogger(logger.Error) I start the server in separate go routine so that can still run and gracefully handle program shutdowns. contains 2 instances of standard library Logger. is printing out messages to and to . I could have used some fancy logger like or any other but I was planning to keep it simple. exithandler pkg/logger Info os.Stdout Error os.Stderr logrus Next let's take care of the databases. I use migration tool written in GO that can be used as CLI or as a library. You can read more about it and find installation instructions . After installing it, let's create few migration files. As seen from above, I'll be operating on resource so it's natural I'll have table: here /users users $ migrate create -ext sql -dir ./db/migrations create_user This will generate 2 migration files in , and for user table. All files are empty so let's add some sql. db/migrations up down Up: public.users
( PRIMARY ,
    username ( ) ); -- db/migrations/${timestamp}_create_user.up.sql CREATE TABLE IF NOT EXISTS id SERIAL KEY VARCHAR 100 NOT NULL UNIQUE And down: public.users -- db/migrations/${timestamp}_create_user.down.sql DROP TABLE Pretty simple, but that's how it should be, right? Before running migrations, let's use library and create a program to simplify this process. This will also work nicely in CI/CD pipelines as it will let us  skip the installation of cli as a separate step of the pipeline build. For that to happen I'll add yet another dependency: golang-migrate golang-migrate $ - github. /golang-migrate/migrate/v4 go get u com I'll name my program : dbmigrate main ( _ _ ) {
	godotenv.Load()
	cfg := config.Get()

	direction := cfg.GetMigration() direction != && direction != {
		log.Println( ) }

	m, err := migrate.New( , cfg.GetDBConnStr()) err != {
		log.Printf( , err) } direction == { err := m.Up(); err != {
			log.Printf( , err) }
	} direction == { err := m.Down(); err != {
			log.Printf( , err) }
	}
} // cmd/dbmigrate/main.go package import "log" "github.com/boilerplate/pkg/config" "github.com/golang-migrate/migrate/v4" "github.com/golang-migrate/migrate/v4/database/postgres" "github.com/golang-migrate/migrate/v4/source/file" "github.com/joho/godotenv" func main () if "down" "up" "-migrate accepts [up, down] values only" return "file://db/migrations" if nil "%s" return if "up" if nil "failed migrate up: %s" return if "down" if nil "failed migrate down: %s" return Quick overview of what's happening here. First of all I load env vars. I then get pointer to instance of config that will give me easy access to all vars I need with some helper methods. You might have noticed that there's a new method. It will simply return or string to instruct my program if it should migrate database up or down. You can see latest changes . GetMigration up down here Now since I have this tool in place I can put it to work. Best place I found for it is By running it there I'm avoiding common "oh, I forgot to run migrations" issue. Updated version of : scripts/entripoint.dev.sh entrypoint.dev.sh -e

go run cmd/dbmigrate/main.go

go run cmd/dbmigrate/main.go -dbname=boilerplatetest

GO111MODULE=off go get github.com/githubnemo/CompileDaemon

CompileDaemon --build= -- =./main #!/bin/bash set "go build -o main cmd/api/main.go" command What's happening here? First run of will use all default values from .env file, so it will run the migrations up against db. In second run I pass so that it does the same but against db. Next I'll start my app with clean state: dbmigrate boilerplate -dbname=boilerplatetest boilerplatetest docker container rm -f $(docker container ps -a -q) docker volume prune -f docker-compose up --build # remove all containers # clear volumes # start app If all the above has worked, we should see table in both and databases. Let's check that: users boilerplate boilerplatetest docker -it $(docker ps --filter name=pg --format ) /bin/bash psql -U postgres -W \l \c boilerplate
\dt \c boilerplatetest
\dt # connect to pg docker container exec "{{.Names}}" # launch psql cli # ensure both DBs still present # connect to boilerplate database and list tables # do same for boilerplatetest # in both databases you should see users table This is what I see when the above commands are run: And sure thing it's all as expected. Now what if we add new migrations while application is running in docker. I'm pretty sure it's not very convenient to stop docker-compose and rerun the command again for changes to take place. Well, program is capable of handling this scenario. In new terminal tab: dbmigrate go run cmd/dbmigrate/main.go \
  -migrate=down \
  -dbname=boilerplatetest \
  -dbhost=localhost go run cmd/dbmigrate/main.go \
  -migrate=up \
  -dbname=boilerplatetest \
  -dbhost=localhost # migrate boilerplatetest db down # you can now repeat steps from above to connect to pg container # and ensure that users table is missing from boilerplatetest DB. # now bring it back up One thing to mention here is . This is because we connect to pg container from our host machine. Within docker-compose we can refer to same container by service name, which is , but we can't do same from host. -dbhost=localhost pg I hope you have learned something useful. In part 3 I'll go through simple CRUD operations for our users resource. It will include middleware usage, validations and more. You can also see the whole project and follow the progress . Stay safe! here

Stories, News & Mentions about INFOPRICE

Infoprice’s Stories on HackerNoon