... what is possible with the ZXDB, and to enable interested parties ... to learn how to implement zxdb themselves."

Um, so ... technology demonstration for Einar's database, which is fine, but it ...

@Einar Saukas

Sorry for the hijack. You have 3 sql scripts in your dropbox.
Which one should I run in a local database of mine to have the ZXDB up and running?

Does it include only the structure? info? screenshots?

... in a local database of mine to have the ZXDB up and ... ?[/quote]

You want zxdb-latest. There is also a ... need a mySQL or Maria database. It's just the data ...

... in a local database of mine to have the ZXDB up and ... screenshots (files). Notice that ZXDB is just a database (meta-data), not ... a repository (files). It means ZXDB stores ...

... were generated from the SPOT database?[/quote]

Just a ... User reviews to the ZXSR database, I used the Infoseek API ... (Crash, etc) from ZXSR to ZXDB? Also we should consider storing ... links to ZXSR in ZXDB if that's useful...

... also stored this information in ZXDB also (as comments in "supports ... for this is in a database...

Note that I ...

...
JGameaBase has already a database for Zx Spectrum and ZX81 ... to the Sql script of ZXDB

... (Crash, etc) from ZXSR to ZXDB? Also we should consider storing ... not worth storing that in ZXDB to save some space, entirely ... to match to an Infoseek/ZXDB record. Unfortunately Excel has truncated ... be large. The entire ZXSR database is over 300Mb and is ...

... add all these links to ZXDB!


[quote ... to an Infoseek/ZXDB record.[/quote]

ZXDB is supposed to ... be large. The entire ZXSR database is over 300Mb and is ... your entire site content into ZXDB...


[quote=" ...

... this new information into other ZXDB tables. I have also ... auxiliary tables to help improve database searches. For instance, right ... better to cache the entire database into memory and perform all ... use the database, I might as well help them! Whenever ZXDB is ...

... all these missing entries to ZXDB database. You can now use the ...

[quote="AndyC;892849"]
If you can ... for the day-to-day database, but there're some niches ...

... should be similar to ZXDB except for additional administrative ... kinda like "aux_entrytitles" in ZXDB. Although you cannot use it ... JOINs. Even if the database caches all these results ... mentioned will invalidate both database cache results and cache ...

... a normal user) to a database about software, hardware, magazines, books ... most users actually search the database per day (the current WOS ... . Of course, the data in ZXDB has been processed and extra ...

[quote="AndyC;893007"][quote="Einar Saukas; ... .

The internal database cache does everything automatically. But ... have been affected by the database changes.

The ... , simply caching the entire database content in memory and ignoring ...

[quote="AndyC;893034"] Even with queries that ... /> And the rest of us? ZXDB is not aimed to serve ...

[quote="JSilva;893117"][quote="AndyC;893034"] Even with queries that ... /> And the rest of us? ZXDB is not aimed to serve ... />
[quote="JSilva;893117"][quote="AndyC;893034"] Even with queries that ... /> And the rest of us? ZXDB is not aimed to serve ...

... handle something a small as ZXDB and they really do make ... do everything outside of the database because they believe "it's ... the reference instance of the ZXDB, and would implement exactly your ... ]anything[/I] on top of ZXDB, it's how I'd ...

[quote="AndyC;892940"][quote="Einar Saukas ... />

[quote="AndyC;892940"][quote="Einar Saukas;892938 ... />

[quote="AndyC;892940"][quote="Einar Saukas;892938 ... work better than database caching anyway, since database caching would not ...

... level is caching the entire database as a data structure in ... memory, without ever hitting the database or interpreting complex query results ... 'm inclined to agree with @AndyC. I don't think that ...

[quote="AndyC;893452"]If I was going ... ]anything[/I] on top of ZXDB, it's how I'd ...

... programs would combine the entire database into an indexed view or ... 150,000 magazine references) in ZXDB. Are you sure that's ... at querying as a SQL database. And the UPDATES/INSERTs are ... and widely scoped data than ZXDB holds, yet it copes fine ...

... by constructing suitable database indexed views/cache tables ... optimization" made the database instantaneous, the communication ... database won't help either.


[quote="AndyC ... ;893647"]In addition, by leaving it in the database ...

... meantime... I uploaded another ZXDB update [url="https://www.dropbox ... like to load ZXDB into a different database (such as PostgreSQL ... you just want to load ZXDB into MySQL or MariaDB, ... choose...

This ZXDB update also contains a description ...

... question. How does updating the database every hour work with the ... "]And how long is the database disabled for whilst you are ... of thousands of queries, the database will only need to execute ... ).

I export entire ZXDB to a file called "ZXDB_latest ...

... , everything would be loaded from database at once. While this information ... from the write model into the read only model which means you ...

... , everything would be loaded from database at once. While this information ... from the write model into the read only model which means you ... with OUTER JOINs, the entire database easily fits into memory, and ...

Sorry I didn't have time to post about AndyC's solution yet. I plan to do it next week.

In the meantime, there's a minor ZXDB update [url="https://www.dropbox.com/sh/bgtoq6tdwropzzr/AAAknv_0PeJGhn36dLJZfGASa"]here[/url].

... ]

Is there any database collation that recognizes VNN and ... a separate auxiliary table (like ZXDB) or auxiliary column (like old ... titles anyway.

In ZXDB, using an auxiliary table (with ... enough reason. I will modify ZXDB accordingly!

[quote="AndyC;895150"]Yeah, I tend to ... there are some codes in ZXDB that definitely need case sensitive ...