database

Before you start: You need some experience with php, Apache Servers, OkHttpUtils, Lists, Maps and JSON structures. This is an updated example of how to - communicate with a apache server via OKHttpUtils calling a php script - doing MySQL data requests (Insert, Update and Delete) using...

Hola a todos: Estoy empezando a full con B4X... ya hice 3 cursos, y la verdad es que vá de pelos !!... Y en cuanto al pedido este, nunca me animé a registrarme y pedir ayuda... No sé, como que pensé que no me darían mucha bola... (perdón por la expresión :) ) Dispongo de un foro, hecho en php...

I often use Sqlite for my apps and I came across "DB Browser". It's a free tool to browse and edit SQlite databases and tables. Download it from here: http://sqlitebrowser.org/ For B4J apps I recommend you to use the latest sqlite-jdbc-3.21.0.jar file. Get it from here...

Hi! I'm trying to use SQLite as local / remote DB. I have successfully downloaded sqlite-jdbc-3.21.0.jar from the proper server: https://bitbucket.org/xerial/sqlite-jdbc/downloads/ Now arises the question: Where should I put the .jar file in order to get use of it? I haven't found the...

DDL code: [entrCreate] INT NOT NULL DEFAULT (strftime('%s','now') *1000) Make sure that the expression (strftime('%s','now') *1000) is enclosed in brackets.

I've written a tutorial about database modelling and how long queries in a good designed db environment should take. This is a example about using huge databases. What it does: - creates two tables (customers and orders) - inserts 1 million customers and 5 orders per customer = 5 million orders...

This tutorial is about db modelling with a small example. Of course this is just an overwiew and there is much more. I assume you know how to create tables and Co. Databases A db is a collection of related data and it contains tables. Mostly it's called database system like (SQlite or MySQL...

This is a first version of the BindingNavigator Library, which wants to somehow reproduce the corresponding BindingNavigator of VB.NET. What is needed? I want to get something similar to the tools available on VB.NET to link the views to the DB. As in the pictures. A DataSet Class is...

This new library is used to add some functions to the already precious SQL library. Insertion, updating and reading of images in fields of type BLOB. Functions to add a table, a field. Update a field. Delete a row or table. List of tables, fields and typos of the fields contained in the...

How to I set and Get correct DBVersion in SQL Browser and my application. From the sample code below, I get result as 1 meanwhile, in building the database, I set user version as 15. Screenshot below What am i doing wrong. Also included example project If...