Dimensional Data

Processing of data is the soul of computing. Almost every single computer ever invented was designed so that human beings could take information in the form of data and manipulate it in one way or another either through visualizations or to use in other ways to make decisions about our lives, work and future. If data processing is the soul then the pieces of data itself are the bones we use to build the body of computing. In this article we’re going to take you on a tour of different ways to access, manipulate and master those building blocks. What do people mean when they call something a database? According to Oracle who specialize in the field, a Database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS) which makes it easier to create, and generally control the database’s data and the programs which make the database work. Together, the data and the DBMS, along with the applications that are associated with them, are referred to as a database system, often shortened to just database. The evolution of the database The 1960s: Navigational databases such as the hierarchical database (which relied on a tree-like model and allowed only a one-to-many relationship), and the network database (a more flexible model that allowed multiple relationships), were the original systems used to store and manipulate data. Although simple, these early systems were inflexible. The 1980s: Relational databases became popular. The 1990s: Object-oriented databases became popular. The 2000s – Now: NoSQL databases came about as a response to the growth of the internet and the need for faster speed and processing of unstructured data. Today, cloud databases and self-driving databases are breaking new ground when it comes to how data is collected, stored, managed, and utilized. What types of databases are there? To make a better decision about the types of databases you need, first, you need to learn more about the different kinds of databases. Below are some common types of databases you may encounter either during your personal life or in your business, as collected by Indeed Editorial Team: Centralized database Cloud database Commercial database Distributed database End-user database Relational database NoSQL database Graph database Object-oriented database Open-source database Operational database Personal database Why use Python for working with databases? Python is perfectly fine for most applications for creating database clients. Python provides a vast set of libraries to work with an extensive variety of databases. Python is good for rapid prototyping. Read more here, to see “How Python is Ideal for Handling Data Intensive Tasks”: Delphi adds powerful GUI features and functionalities to Python In this tutorial, we’ll build Windows Apps with extensive Database capabilities by integrating Python’s Database libraries with Embarcadero’s Delphi, using Python4Delphi (P4D). P4D empowers Python users with Delphi’s award-winning VCL functionalities for Windows which enables us to build native Windows apps 5x faster. This integration enables us to create a modern GUI with Windows 10 looks and responsive controls for our Python Database applications. Python4Delphi also comes with an extensive range of demos, use cases, and tutorials. We’re going to cover the following… How to use SQLite, SQLAlchemy, pymongo, mongoengine, redis-py, and FireDac Python libraries to interact with databases All […]

Website metrics are very important for webmasters to analyze and judge the efficacy and usefulness of their websites. Typically the metrics will show the ranking information, indexing information, spam ranging and many more information to get an idea about the page. The downside is that many website metrics APIs have results pages which are either tricky to get to directly or you wish to consolidate and visualize the data in different ways to the pre-made versions. We’re going to show you how to add the ability to obtain the data behind the website metrics in your desktop and mobile apps so they can be more easily viewed offline and how to get that data to the point where it could be extracted into a database. Why are website metrics so important? According to the metrics, you can take decisions about the future direction the website’s content and the areas on which to focus or tweak. Also URL metrics are very important for link building. Links from outside websites are viewed by most search engines as a form of endorsement. The more good quality external links you have pointing to your site the more the search engines may consider your site notable or worth boosting in the search ranking. URL metrics is a clear indication of how your website and its content is viewed and consumed by the rest of the world and, with that, the relative importance searchers may place upon you. What is Moz? Moz is a good friend of SEO Engineers. They offer all in one tools for a successful SEO. It will help to find the barriers for indexing your site like broken links, missing important tags and many more issues. It will summarize all matrices into a charts and you will get an idea at a glance. They can track your ranking over time and show it in a chart. Backlinks are very important for SEO, with Moz you can get reliable backlink metrics. Ranking with the wrong keyword doesn’t do any good for your website. With Moz, you can do the correct keyword research. How to get URL metrics of your website? Moz provide an easy to use API for URL metrics. It will give you more than fifty metrics about the domain / URL you provide. They offer you a free trial with more than enough API request for small scale projects. They you just have to make a REST request with the API Access ID, Secret Key and the URL you going to get matrices. Both Request and response is in JSON format. How to get URL metrics to a Delphi / C++ Builder application? Delphi provide an easy way to get Moz URL metrics. You can generate GUI components by the FREE Embarcadero tool called “Embarcadero REST debugger” and paste it in to your Delphi or C++ builder application. It will copy REST components and components for memory database and you can paste those directly into your form. First, run the Embarcadero REST debugger and set the parameters as following. Note that: you have to set the Moz “Access ID” and “Secret Key” as username and password for BASIC authentication in Authentication tab. How to add REST components to your Delphi or C++ app Now you can check everything by sending a […]

For those fortunate enough to have access to a pool all that splash-time fun comes at the price of a not inconsiderable amount of effort. Pools, on the face of it, seem to be not a huge amount more than fancy holes in the ground filled with water. When you accidentally own a swamp The reality is though that water is a delicate little ecosystem which can very quickly go from a place of enjoyment to the source of a broad range of diseases. It takes a very finely tuned collection of chemicals which must be in just the right balanced quantities. If you get that balance wrong you might find yourself responsible for streaming, stinging eyes for your swimmers or be greeted one day by a green pond of foul-smelling swamp slime. Delphi to the rescue! New Zealand based company Select Chemicals Limited have cleverly used the cross-platform power of RAD Studion Delphi and the FireMonkey framework to create a totally beautiful yet practical mobile app which takes the hard work out of calculating the correct chemical balances to make sure that your pool oasis remains a place you retreat to – not recoil from! The app looks effortlessly beautiful thanks to RAD Studio themes SCL recently updated the app recently to use one of Delphi’s gorgeous custom professionally designed user interface themes. This, combined with Delphi’s ability to interact natively with the mobile device’s Bluetooth communications means the app is a great tool for its users without a huge learning curve for the developers. According to the developer, “The SCL Bluetooth Control is used to control a wide range of Smart products from Select Chemicals Ltd: SmartDoser – A versatile general purpose chemical doser, pHydroMate – A pH correction controller using a pH probe. PoolMate – A pool management controller dosing managing both Disinfectant and pH correction using a combination pH and ORP probe.” Google Play SCL Bluetooth Control Screenshot Gallery Reduce development time and get to market faster with RAD Studio, Delphi, or C++Builder. Design. Code. Compile. Deploy. Start Free Trial   Upgrade Today    Free Delphi Community Edition   Free C++Builder Community Edition

There are a huge number of desktop software development tools available on the market. However, not all of them can boost productivity effectively. So, choosing the right one can be tricky. In this post, you will find 7 of my favorite desktop software development tools. They have enabled me to enhance my productivity significantly. Let’s take a look at them. 1. Delphi Delphi is an advanced IDE for developing cross-platform applications on a variety of platforms, including Windows, macOS, iOS, Android, and Linux. It enables you to develop native apps rapidly. Thanks to the powerful designing tools and features. The visual designing menu enables you to drag and drop components to the pallet easily. Also, Delphi supports highly optimized compilers for quickening lengthy compiles. Besides, it helps you to code quickly and accurately by utilizing Code Insight™. Overall, it’s a complete desktop software development productivity tool. 2. RAD Studio RAD Studio is a powerful IDE for building high-performance applications in both Delphi and modern C++. It offers a comprehensive set of tools for streamlining and simplifying the desktop software development lifecycle. You can create user interfaces quickly by dragging and dropping components from Tool Palette to the form. Also, it auto-generates a significant portion of your application codes as soon as you start the project. Besides, UML modeling helps you to improve the performance of your app. So, with the RAD Studio, you get all the productivity features in a single place. 3. REST Debugger REST Debugger helps you to explore and integrate RESTful web services conveniently. You can use it to perform testing across the application development cycle. REST Debugger enables you to test and understand RESTful web services. You can dive right into REST data with filterable JSON blobs to analyze how everything is working. Also, you can copy and paste components from the REST Debugger to Delphi, C++ Builder IDE, and RAD Studio. You don’t have to write any code. So, it can boost your software development productivity. 4. FireDAC FireDAC is a powerful universal data access library. It provides you with all the features to build data-intensive applications conveniently. FireDAC offers high-performance data access. The Live Data Window mode enables you to navigate through large datasets quickly. With Cached updates mode, you can track correlated changes for different datasets easily. Also, FireDAC comes with a powerful data access engine, which you can use with the desktop applications directly. Besides, it supports a unified API for helping you to code without worrying about the subtle differences between different database management systems. 5. Low Code Wizard Low Code Wizard helps you to boost your productivity by generating the framework of an already working application with basic functionalities. So, you don’t have to start from scratch. Once installed, the tool runs a wizard, which guides you through the process of generating basic functionalities quickly. There are a variety of options to choose from, including User Account and Application routines. You can configure the Settings screen to change the theme to light/dark. Also, Low Code Wizard enables you to add more screens to your application with less code. 6. LiveBindings LiveBindings helps you to visualize live data efficiently. You get the creative freedom of presenting the information more intuitively. LiveBindings helps you to bind objects to dataset fields. You can […]