Request for ideas

General
1

Marc Zeedar and I are discussing the possibility of me writing a regular database column. If you have any ideas or suggestions that you would like me to cover please PM me. I will entertain any idea.

Thanks

2 Likes
2

Start with the basics and get into the more complicated later

  • the classes in Xojo: Database, PreparedStatement, RecordSet, RowSet, DatabaseCursor: who does what
  • Create/Open SQLit database, create a field, add a record and read it later.
  • Connect to mySQL, Postgres, MS SQL, ODBC database. How it works.
  • Connect to other databases via MBS Plugin :slight_smile:
  • How do prepared statements work. Differences for different databases.
  • How transactions work
  • How to use indexes in SQL
  • Advanced SQL commands with e.g. subqueries, SQL functions
  • Calling stored procedures
  • Various data types in SQL, their limits, what to use.
  • What is NULL? Why to use, caveats and consequences.
  • Handling errors, avoiding pitfalls.

Okay. That may do for the first 2 years.

3

about this database, everything is better to be written lowercase at design^^
Postgres have “returning” that is very nice to return the id from new record at insert.
Postgres have large objects (oid) to store images or files.

4

As well as the technical stuff mentioned already I think a series of tutorials/articles about best practice on how to design your UI - listboxes, lazy loading, etc.

5

Just a suggestion, name your series “The Blob: article title.” A three way reference to the movie "The Blob,” play on the word “Blog” and the obvious reference to database terminology.

2 Likes
6

Sounds cool. Love that movie. The original.

1 Like
7

in some time you have to deal with migrations and ORM, please take a look on ActiveRecord and ARGen

if you think about it and is ambitious, you need is a form of persistent storage, with new services like NoSQL and web-services, how about one API for all this forms of persistence?

8

Agree - was going to suggest a practical example of using ARGEN given that it has very recently been open-sourced.

9

Only if I can get a compiled version. I don’t feel like messing around with doing that.

10

@Vince_Du_Beau messing around with what ?

11

Having to compile it myself.