Search found 83 matches: isam

Return to advanced search

Re: Advantage Database Server

Apparently this is a database engine developed by Alaska Software to emulate ISAM style functionality for xBase++. It looks like people are considering using PgDBE instead of ADS (Advantage Database Server), but they are having performance issues. You mentioned ...
by ferilmagic
Fri Nov 03, 2023 7:44 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Advantage Database Server
Replies: 32
Views: 3402

Re: who use PostgreSQL with Fivewin ?

... i must "update" else Data will be "corrupt" for Xbase++ Apps using PgDBE but the Main work is : how to emulate ISAM Style Concept of Xbase++ PgDBE have a lot of Overhead so i look for a harbour / Fivewin Way --- when build TPQServer LIB there is a File rddcopy.c ...
by Jimmy
Wed Sep 27, 2023 8:44 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: who use PostgreSQL with Fivewin ?
Replies: 13
Views: 991

Re: METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?

...     cQuery += " __record     serial  NOT NULL, " other like "__rowversion" or "__keyversion" are use by Xbase++ ISAM-Emulation with need some TRIGGER      cQuery += " __rowversion integer NOT NULL DEFAULT 0, "      cQuery += " __keyversion integer ...
by Jimmy
Sun Aug 06, 2023 12:44 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: METHOD SavePQQ() need "id" or how to use own PRIMARY KEY ?
Replies: 21
Views: 706

Re: how to handle License for MySQL, PostgreSQL & Co ?

... to connect to Backend Alaska want me NOW to "buy" a License to use PGDBE which is Alaska Way to connect to Backend using ISAM Style
by Jimmy
Fri Jun 16, 2023 3:19 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: how to handle License for MySQL, PostgreSQL & Co ?
Replies: 9
Views: 523

Re: MariaDb delete

... [ WHERE <cond>] was discussed in his other post. I say this because I notice people using Maria and MySQL but continue to use ISAM while loosing a great opportunity to start learning SQL. If you are referring to MySql ISAM vs InnoDB, all our users are using InnoDB but not ISAM.
by nageswaragunupudi
Fri Jun 02, 2023 4:04 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: MariaDb delete
Replies: 6
Views: 372

Re: MariaDb delete

... DELETE FROM <tablename> ;   Suppose you want to extract certain records from the table based on certain condition. With our traditional ISAM you would do this: WHILE !odbf:eof()  //or some other condition    if <condition>  //another condition          tbl2:Seek( odbf:KeyValue ...
by reinaldocrespo
Fri Jun 02, 2023 2:55 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: MariaDb delete
Replies: 6
Views: 372

Re: Consulta Urgente

Mi recomendación la tabla que contendrá las imágenes usar isam en lugar de innodb.
by carlos vargas
Fri Dec 02, 2022 7:46 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Consulta Urgente
Replies: 8
Views: 779

Re: ADS - The future is <sadly> now so where do you go ?

hi Tim, Alaska have made PgDBE using PostgreSQL PgDBE does have ISAM "Emulation" so you "only" change DBE ( = RDD) that is what Advertising say ... :roll: --- even when change from NTX to CDX it was a lot of Work. ADO seem a Solution ...
by Jimmy
Fri Apr 22, 2022 2:37 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADS - The future is <sadly> now so where do you go ?
Replies: 26
Views: 2722

Re: Advantage Database Server

hi, Alaska have create PgDBE for Xbase++ to emulate ISAM Style People want to use it instead of ADS while they "think" that Alaska found "Wonder-Pile" i have "testdrive" early Version of PgDBE and Concept seems "interessing" ...
by Jimmy
Mon Jan 24, 2022 7:04 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Advantage Database Server
Replies: 32
Views: 3402

Re: Advantage Database Server

hi, there are RDD for MySQL and PostgreSQL but it need OOP Syntax is like using a Db-Server or ADO. Alaska have made PgDBE to "simulate" ISAM Style like SKIP or GOTO ... SEEK they want to use it instead of ADS :roll: but PgDBE Concept of "Index" is very strange as it use "internal" ...
by Jimmy
Fri Jan 21, 2022 7:55 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Advantage Database Server
Replies: 32
Views: 3402

Re: Advantage Database Server

... of application as well as margin from ADS for sale of ADS products. PROS: Rock solid. No index maintenance is needed. Takes full advantage of both ISAM (for browses) and porting legacy code and at the same time SQL of RDMS with the great power for complex queries. Calculations are done on the server ...
by Otto
Thu Jan 13, 2022 7:30 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Advantage Database Server
Replies: 32
Views: 3402

Re: strategies

... of current native app and learn a lot more. By simply switching to ADS RDD you have already begun on the way to learn RDB with SQL white keeping ISAM that you already know and love so much. Yes, there is still a learning curve. When I begun learning SQL back in 2004 with ADS, I kept most of my ...
by reinaldocrespo
Sun Feb 24, 2019 6:32 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: strategies
Replies: 34
Views: 8023

Re: Temp table for ADS

... temp. Temporary tables exist only to the DD connection and are lost upon disconnection or when you drop the table. If you want continue using your ISAM code, which is probably 100 times slower than an actual #temp table, then think that you need to delete the table from the DD before creating a ...
by reinaldocrespo
Thu Dec 13, 2018 11:05 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Temp table for ADS
Replies: 10
Views: 2486

Re: Example Business Object (Customer)

... those of us who have being using dbfs for so long, it could be a little bit challenging to forget about that. We are so used to the navigational ISAM model, GOing TOP, SKIPing until EOF that all that sounds a little bit weird in the begining. Back to ORM, the most complete ones have 2 types of ...
by Carlos Mora
Wed Nov 21, 2018 8:25 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Example Business Object (Customer)
Replies: 32
Views: 8490

Re: PHP with dbase

... Advantage using open protocol oData: http://jdmullin.blogspot.com/2010/09/advantage-web-api.html Keep in mind Advantage is fully ISAM as well as SQL. Most web development languages are only SQL. What I'm trying to say is that you will probably have to learn some SQL in order to ...
by fraxzi
Fri Aug 10, 2018 1:39 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: PHP with dbase
Replies: 10
Views: 1899
Next

Return to advanced search

cron