C++

Learn To Quickly Use NoSQL With MongoDB And FireDAC In Delphi And C++Builder

By
November 12, 2016
In CodeRageX there were two sessions around MongoDB. The first session is the basics and the second session is more advanced topics dealing with MongoDB.MongoDB is an open-source NoSQL document database. The first session covers a MongoDB overview, JSON and BSON, the FireDAC MongoDB API wrapping classes, and the FireDAC MongoDB datasets.The second session covers indexing, query options…
Read more
News

10 Quick Tips & Tricks for SQL Server Developers

By
July 8, 2015
Author: Embarcadero USA Here are 10 quick SQL Server tips and tricks for database developers compiled by SQL Server expert Pinal Dave. For inefficient query plans: Check for issues with bad cardinality estimates. The maximum degree of parallelism can be limited server-wide…
News

Rapid SQL XE6 / 8.7.5 is Now Available

By
June 2, 2015
Author: Embarcadero USA Rapid SQL XE6 version 8.7.5 is now available. EmbarcaderoRapid SQL is the integrated SQL development environment for IBM DB2, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, Sybase and Teradata database systems. Rapid SQL is your fast path to higher productivity whether you’re programming in SQL, PL/SQL, Transact-SQL or HTML. Customers with current maintenance…
Read more
News

Beginning Joins with SQL

By
January 22, 2015
Author: mahdy M7244 Introduction When we are talking about relational database, we are usually talking about many different tables and the relationships between them. We define relationships with various keys like primary key, foreign key, etc. When we have to retrieve data…
News

Top 2 Errors When Working with Datetime Conversions

By
December 9, 2014
Author: jpro51 Working on universal applications has its own challenges. Often I have seen developers resort to unwanted conversions inside the database based on application needs. I am a firm supporter that databases are not the place to play with date and time conversions. Databases are a great source for storing and retrieving data based on your needs. It has to be treated like this for most…
Read more
News

3 Cool SQL Server TSQL Snippets for Productivity

By
October 27, 2014
Author: Tim DelChiaro Nobody would want to shy away from some help. This is second to human nature and we never try totalk it out explicitly. When at work, if we can surely get help from our colleagues when it comes to driving the deadlines and completing it ahead of…
C++

Developer Direct 2014 Mobile School: Lesson 3 Slides and Replays

By
July 14, 2014
Author: Wayne S8181 Monday, July 14, 2014: Lesson 3 – Accessing Local Storage and Data In this lesson, we explore local storage covering a range of options including using INI files and local document storage. This lesson will also show how to use FireDAC database access components to connect to and use local SQLite, InterBase IBLite and IBToGo. You will understand the core concepts when…
Read more