Tables

Listings To assemble the sequence of historic entries for a property, you should find all historic entries sharing thesame UARN and sort them into ascending List Alteration Date. Entries that are alterations have HistoricFrom and To Dates. Entries that revise alterations will not. You can then add the current entry for the sameUARN to complete … Read more

Data Architecture

A data architecture is the foundation of any data strategy. It is the “how” when implementing a data strategy. In this article, we’ll look at: Business agility Data architecture Architecture components Data standards The shift to new architecture Data schemas The architecture is responsible for setting the data standards that define what kinds of data will … Read more

SQL/MySQL/SQLite/NoSQL

MySQL is a fully featured RDBMS. An example would be enterprise system or websites. SQLite is also a RDBMS but a lightweight one, it doesn’t require it’s own process, clustering or user management unlike MySQL or others RDBMS. SQLite consist of a single file and a library to make your application interact with it. The … Read more

Flat File

Exasperated? That’s how your customers feel when they’re trying to get their data to you. If only they could see the value of your product faster; instead, they’re stuck importing spreadsheets and fixing formatting errors in Excel. Here are the top CSV import issues that can cause major headaches File size One of the most … Read more

API

7 skills and experience to look for in API developers 1. Cross-platform development 2. API design 3. Front-end development 4. Different coding languages 5. Integration knowledge 6. API orchestration skills 7. Programming tools (Postman)

IoT

The Internet of things describes physical objects with sensors, processing ability, software, and other technologies that connect and exchange data with other devices and systems over the Internet or other communications networks. Hex, along with decimal and binary, is one of the most commonly encountered numeral systems in the world of electronics and programming. It’s … Read more

Lean Architecture (PHP, Python)

Lean Architecture is the ongoing process of rethinking and improving architectural methodology.  It is the pursuit of better work by applying Lean principles to every aspect of practice. It is about smarter information flow and understanding how we perceive and process information in order to be better communicators amongst ourselves and to the users of … Read more

Draw.io

diagrams.net (previously draw.io[2][3]) is a free and open source cross-platform graph drawing software developed in HTML5 and JavaScript.[4] Its interface can be used to create diagrams such as flowcharts, wireframes, UML diagrams, organizational charts, and network diagrams.[5] diagrams.net is available as online as cross-browser web app, and as offline desktop application for Linux, macOS, and Windows.[5] Its offline application is built using the Electron framework. The web app does not require online login or registration and can open … Read more

Power BI

7 reasons to use Power BI How do you know whether Microsoft Power BI is right for your organization? Here are seven reasons to choose Power BI — and one reason you may want to choose something else: A quick start. You’ll be able to get insights quickly with an uncomplicated setup, no required training, … Read more