Story Category: SQLite

1

VOTES


VOTE

Delphi Tip of the Day: Prevent SQLite Date Headaches by using a GetDateAs_YYYYMMDD Function

Michael Riley Michael Riley Working with Date data can be very tricky. I recently encountered an “Invalid argument to date encode”, error while trying to update a SQLite database table.This placed a value of 0000-00-00 into the date field… … Read more 7 months ago in Delphi, SQLite, tip-of-the-day 0

1

VOTES


VOTE

This Is How To Use ADO And FireDAC With Databases

Softacom Information Softacom Information From this article, you will learn the difference between working with databases via the ADO technology and the FireDAC library. Using the right database technology is often a critical part of designing your apps, particularly… … Read more 2 years ago in ADO, database, database components, Delphi, firedac, ms-access, programming, SQL, SQLite, Tech Partner, Windows Application Development 0

1

VOTES


VOTE

Why You Should Know About SQLite For Your Windows Apps

Muhammad Azizul Hakim Muhammad Azizul Hakim Do you want to add the full power, functionalities, and flexibilities of SQL to your Python GUI App, without installing external libraries? You can build it easily by combining SQLite-a built-in DB-API 2.0 interface for…… … Read more 3 years ago in cbuilder, database, dataset, Delphi, delphi vcl, GuiProgramming, Learn Python, orm, programming, Python, python gui, python4delphi, RAD Studio, SQL, sqlalchemy, SQLite, windows, windows app 0

2

VOTES


VOTE

Extract, Transform, Load – The Magic Behind HeidiSQL

Ian Barker Ian Barker HeidiSQL is a wildly successful open source database management tool. Apart from being extremely useful in the management of MySQL, SQL Server, PostgreSQL and SQL Lite databases it is also open source – and that… … Read more 3 years ago in Code, Delphi, ETL, IDE, MSSQL, MYSQL, RAD Studio, SQL, SQLite 0

1

VOTES


VOTE

Using a Common C++ Library with C++Builder and TwineCompile

Jonathan Benedicto Jonathan Benedicto One of the many big advantages to using C++ for applications and projects is the access one has to the vast library of C++  libraries and frameworks available. Basically, there is a C++ library for… … Read more 3 years ago in C++, Clang, Jobs, learn c++, multi-core, News, parallel, parallel compilation, programming, SQLite, TwineCompile 0

1

VOTES


VOTE

Incredible Database Development And Visualization Tool Is Built In Delphi

Embarcadero Admin Embarcadero Admin Navicat is a powerful database development tool which supports many database servers and cloud database platforms and it is built in Delphi. They have a number of different versions of Navicat with each version supporting… … Read more 4 years ago in amazon aurora, amazon rds, Azure, database, Delphi, google cloud, mariadb, MongoDB, MYSQL, navicat, object pascal, Oracle, oracle cloud, PostgreSql, programming, Showcase, SQL Server, SQLite, windows 0

1

VOTES


VOTE

Easily Connect To SQLite Using FireDAC And LiveBindings In Delphi

Konstantin Tomov Konstantin Tomov This sample shows the use of FireDAC database connection using SQLite. Also, it shows how to use a TBindNavigator control. Location You can find the FMGettingStarted project at: Start | Programs | Embarcadero RAD Studio Sydney | Samples and then navigate to: Object… … Read more 4 years ago in android, Code, database, Delphi, firedac, ios, linux, macos, object pascal, programming, RAD Studio, SQLite, windows 0

1

VOTES


VOTE

Learn How To Use The Powerful In-Memory FireDAC Local SQL Engine In Delphi

Konstantin Tomov Konstantin Tomov The xDBMS sample shows you how use the TFDLocalSQL class to implement a cross-DBMS query application. To this end, each queryable dataset must be registered with the Local SQL engine using the DataSets collection property.Note: The Local SQL feature allows executing SQL commands, where… … Read more 4 years ago in android, Code, Delphi, firedac, ios, linux, macos, object pascal, programming, RAD Studio, SQL, SQLite, windows 0

1

VOTES


VOTE

Powerful Python GUI Feature Brings Over 20 Different Databases To Your Python Windows GUI Apps

Python GUI Admin Python GUI Admin How about wrapping your Delphi Objects to Python Objects with a single line of code? Sounds Interesting? Yes, Python4Delphi has the flexibility to do that using a TPyDelphiWrapper component. This benefits Delphi Developers easily to…… … Read more 4 years ago in C++, database, Delphi, firedac, GuiProgramming, MSSQL, MYSQL, object pascal, Oracle, PostgreSql, programming, Python, python gui, python4delphi, SQLite, TPyDelphiWrapper, windows 0

1

VOTES


VOTE

Hands-on with Delphi: FNC Maps: Cross-framework, Cross-platform, Cross-service Mapping Component Library

Holger Flick Holger Flick (Available on Amazon .COM .CA .DE .CO.UK .FR .IT .ES .CO.JP) Learn to build modern Delphi applications for multiple platforms with maps and geographic focus by example! Delphi comes with native compilers for Windows, Linux, Apple macOS, iOS, and Android. TMS Software has… … Read more 4 years ago in android, Azure Maps, Bing Maps, Books, cross-platform, Cross-service, Directions, FireMonkey, FNC, GeoJSON, GIS, Google Maps, GPS, GPX, Here Maps, KML, MapBox, Mapping, Markers, Mobile, OpenLayers, Reporting, REST, SQLite, TMS FNC Maps, TomTom, vcl, Web Services, XData 0

1

VOTES


VOTE

Image Organizer

FPiette FPiette  I have created a nice application using Delphi and I provide full source code on GitHub at https://github.com/fpiette/OvbImgOrganizer OvbImgOrganizer is an application written with Delphi that maintain an index of your images, allow searching with… … Read more 4 years ago in Delphi, Direct2D, opensource, SQLite 0

1

VOTES


VOTE

Delphi – SQLite Sample Projects

Michael Riley Michael Riley I’ve been exploring SQLite within Delphi. There are several sample SQLite applications that come with Delphi if you selected to install the samples during setup. I’ve put together the list of SQLite samples that are… … Read more 4 years ago in SQLite 0

1

VOTES


VOTE

Using sqlite.net with POCO classes

Sean Sean SQLite has become one of the most pervasive embedded databases around.  It’s built into Android, iOS and OSX and is a part of many applications.  It has also become the recommended client side database for… … Read more 11 years ago in .NET, C++, database, SQLite, sqlite.net 0