Re: storing binary data in a "memory" database

2022-06-05 Thread Bob Sneidar via use-livecode
ent from my iPhone > >> On Jun 3, 2022, at 6:56 PM, Bob Sneidar via use-livecode >> wrote: >> >> Hi Doc thanks for the response. I am using aes256 encryption so an ascii >> hash is not viable. If this were a file based sqLite database I could >> perhaps cha

Re: storing binary data in a "memory" database

2022-06-04 Thread Brian Milby via use-livecode
t; hash is not viable. If this were a file based sqLite database I could perhaps > change the encoding. Maybe I can with a :memory: database too! Here's my > code. I have posted this before, it's an incredibly useful handler. If you > provide pDBID it will ADD or REPLACE a tab

Re: storing binary data in a "memory" database

2022-06-03 Thread Bob Sneidar via use-livecode
Hi Doc thanks for the response. I am using aes256 encryption so an ascii hash is not viable. If this were a file based sqLite database I could perhaps change the encoding. Maybe I can with a :memory: database too! Here's my code. I have posted this before, it's an incredibly useful h

Re: storing binary data in a "memory" database

2022-06-03 Thread doc hawk via use-livecode
A couple of lines of code with declarations, storing, and retrieving would probably help. There also might be a UTF issue (which would be beyond me)—a hash should be in good old 6.5 bit ASCII, not something newfangled with eight or more bits. ___ us

Re: storing binary data in a "memory" database

2022-06-03 Thread doc hawk via use-livecode
bob bobbled, > How should I define a column in sqLite that is going to properly store and > retrieve a password hash? Simply using a BLOB type doesn't do it. You shouldn’t need a BLOB for a hash. Either CHAR(), VARCHAR(), or TEXT. With the first two, you need to specify a long enough length.

Re: storing binary data in a "memory" database

2022-06-03 Thread Bob Sneidar via use-livecode
Right now I am querying for the hash directly from the source database when I need it. Just curious why sqLite cannot handle storing an encrypted string. Bob S > On Jun 3, 2022, at 14:29 , Bob Sneidar via use-livecode > wrote: > > Hi all. > > I have set up a kind o

storing binary data in a "memory" database

2022-06-03 Thread Bob Sneidar via use-livecode
Hi all. I have set up a kind of database caching method where I take currently selected data in my display form and save it in a :memory: database. Everything works EXCEPT that the value for the encrypted hash is getting corrupted. It's not coming back the way it was stored. It looks li

Re: Property mapper and a s script database

2022-02-22 Thread Bob Sneidar via use-livecode
Whatever you do, DO NOT google Quordle. Bob S > On Feb 19, 2022, at 02:41 , Neville Smythe via use-livecode > wrote: > > OT: All this would have been ready days ago if I hadn’t been diverted by the > wordle craze - it’s all too tempting to use LC to quickly cobble together > versions for

Property mapper and a s script database

2022-02-19 Thread Neville Smythe via use-livecode
, because of the limitation in LC about stack names. So I have put together a script database management stack/standalone in which one can install as many copies of stacks as you like, and search their scripts. You can save favourite code snippets (eg a UTC timestamp handler, or Jacque's r

ios app: "Error opening database: cannot set file protection"

2021-10-26 Thread Mike Kerner via use-livecode
Well, this is a new message that I can't seem to find a reference to: I have an app that I've been working on for months. I did the first build of it that I've done in a bit, and got that message: Error opening database: cannot set file protection After hitting "OK", t

Re: Stuck on native database functions

2021-07-13 Thread Bob Sneidar via use-livecode
ttps://quality.livecode.com/show_bug.cgi?id=23074 > > It was also tricky for me until I found out how to quote variables and > arrays that point to data when sending data to my mySQL database as the > documentation was not quite up to the point. > &

Re: Stuck on native database functions

2021-07-13 Thread R.H. via use-livecode
@Bob Sneidar Hello Bob The documentation bug was resolved in the latest version: https://quality.livecode.com/show_bug.cgi?id=23074 It was also tricky for me until I found out how to quote variables and arrays that point to data when sending data to my mySQL database as the documentation was

Re: How do I get the ID of a database?

2021-07-12 Thread Bob Sneidar via use-livecode
That's what I ended up doing. I am so used to using sqlYoga, so the standard API took a little getting used to. Bob S > On Jul 9, 2021, at 19:30 , Tom Glod via use-livecode > wrote: > > Hey Bob I don't understand the problem. Why don't you just store the ID > in a persistent place? i th

Re: How do I get the ID of a database?

2021-07-09 Thread Tom Glod via use-livecode
misunderstanding the problem. On Fri, Jul 9, 2021 at 8:03 PM Bob Sneidar via use-livecode < use-livecode@lists.runrev.com> wrote: > Something like put revdb_databaseNamed(":MEMORY:") into tDBID. > > But thinking about it more, it's kind of irrelevant. Opening a datab

Re: How do I get the ID of a database?

2021-07-09 Thread Bob Sneidar via use-livecode
Something like put revdb_databaseNamed(":MEMORY:") into tDBID. But thinking about it more, it's kind of irrelevant. Opening a database isn't like loading the information into some variable. The cursor is the actual data that needs to have housekeeping done on it. Bob S

Re: How do I get the ID of a database?

2021-07-09 Thread Mark Wieder via use-livecode
On 7/9/21 4:35 PM, Bob Sneidar via use-livecode wrote: Yeah thanks Rick, I know I can store the database id, I was hoping to simply call a function that could tell me what database name the ID belonged to, but apparently that is not a persistent thing. How would you reference the database to

Re: How do I get the ID of a database?

2021-07-09 Thread Bob Sneidar via use-livecode
Yeah thanks Rick, I know I can store the database id, I was hoping to simply call a function that could tell me what database name the ID belonged to, but apparently that is not a persistent thing. I stored it in a script local variable in the card that creates the database, then I have a

Re: How do I get the ID of a database?

2021-07-09 Thread Rick Harrison via use-livecode
Hi Bob, When you open the database with revOpenDatabase you assign the whole thing to yourDatabaseID. Look it up in the dictionary towards the end and you’ll find what I’m referring to. yourDatabaseID will be an integer and you will use that to refer to your database for other functions

How do I get the ID of a database?

2021-07-09 Thread Bob Sneidar via use-livecode
Hi all. I am getting more into MEMORY sqLite databases, and perusing the dictionary, I find no way to close a database or find the ID of a currently open database. I know I can store the ID somewhere, but I am finding that after troubleshooting and tracing my code I have a lot of database

Re: Stuck on native database functions

2021-07-09 Thread Bob Sneidar via use-livecode
Okay, so here's an updated version of my ArrayToSQLITE function. It takes an array, and as the name suggests, converts it to an sqLite database and returns the Database ID. Of note is that it now works with EMBEDDED ARRAYS! If it detects that a key is an array in the supplied array, it

Re: Stuck on native database functions

2021-07-09 Thread Bob Sneidar via use-livecode
Okay I found out what I did wrong. The array variable needs to be enclosed in quotes. I remember now some time in the past looking at that and saying, "Why are their quotes around the array variable? That won't work!" So I removed them and subsequently shot myself in the foot. For the record,

Re: Stuck on native database functions

2021-07-07 Thread Mark Smith via use-livecode
Yes, using the numeric placeholders will do that for you. > On Jul 7, 2021, at 4:43 PM, Terence Heaford via use-livecode > wrote: > > It also seems to do the escaping for you as it handled text containing commas > in the description ___ use-livecod

Re: Stuck on native database functions

2021-07-07 Thread Terence Heaford via use-livecode
It also seems to do the escaping for you as it handled text containing commas in the description All the best Terry > On 7 Jul 2021, at 16:40, Terence Heaford via use-livecode > wrote: > > The routine I have working is > > put "uniqueID,date,type,description,amount,balance,category" into t

Re: Stuck on native database functions

2021-07-07 Thread Terence Heaford via use-livecode
Mark, it certainly helps me. The routine I have working is put "uniqueID,date,type,description,amount,balance,category" into tFields put merge("INSERT INTO [[tAccountName]] ([[tFields]]) VALUES(:1,:2,:3,:4,:5,:6,:7)") into tSQL revExecuteSQL dbGetID(), tSQL, "tValues[uniqueID]", "tValues[date]

Re: Stuck on native database functions

2021-07-07 Thread Mark Smith via use-livecode
Currently I have this working (Content of tSQL :) INSERT into TABLE1 ("complete", "todo", "itemDate", "category", "purgeDate", "dgOrder") values(:1, :2, :3, :4, :5, :6) revExecuteSQL gConnectID, tSQL, "ptheRowA[complete]", "ptheRowA[todo]", "ptheRowA[itemDate]", "ptheRowA[category]", "ptheRowA

Re: Stuck on native database functions

2021-07-07 Thread Terence Heaford via use-livecode
Out of interest and not sure if it is relevant but I have received this error: "table myTable has 8 columns but 7 values were supplied" Yes the table has 8 columns in total but the first column is recID integer primary key autoincrement Surely it should not give this error because I do not prov

Re: Stuck on native database functions

2021-07-07 Thread Terence Heaford via use-livecode
Just tried this method revExecuteSQL myID, "insert into mytable values(:1,:2,:1)", "valueX",”valueY" It did not work put merge("[[quote]][[tUniqueID]][[quote]],[[quote]][[tDate]][[quote]],[[quote]][[tType]][[quote]],[[quote]][[tDescription]][[quote]],[[quote]][[tAmount]][[quote]],[[quote]][[tBa

Re: Stuck on native database functions

2021-07-07 Thread Terence Heaford via use-livecode
I have now tried your method with the tValues array directly and by deconstructing the array as below and it does not work. I have a recollection of not being able to get this to work with an array which is why I did the way I did. All the best Terry put q(tAccountName) into tAccountName pu

Re: Stuck on native database functions

2021-07-06 Thread Terence Heaford via use-livecode
Here’s an example I have been using, not sure whether it will help: function dbAddTransaction tAccountName,tValues put q(tAccountName) into tAccountName put q(tValues["uniqueID"]) into tUniqueID put q(tValues["date"]) into tDate put q(tValues["type"]) into tType put q(tValues["description"])

Re: Stuck on native database functions

2021-07-06 Thread Rick Harrison via use-livecode
Hi Bob, Some quick questions: 1. What version of LiveCode are you using? 2. Are you on Mac or Windows or Linux? 3. Are you using MySQL or PostgreSQL? Have you ever tried using the free version of Valentina Studio to help you with managing your databases? It’s quite nice! Let us know! Rick >

Re: Stuck on native database functions

2021-07-06 Thread Bob Sneidar via use-livecode
So I checked out the lessons. I do not find anything there for using substitutions like :1, :2. I am getting records inserted but with empty data. Really frustrating. I could use literal data, which I tested, and which works, but my real data contains commas, and in the future may contain any

Re: Stuck on native database functions

2021-07-06 Thread Bob Sneidar via use-livecode
Well that won't work. How does it know I want to insert the data in aRecordData? Also I put quotes around the column names but got the same results. Bob S > On Jul 6, 2021, at 16:14 , Devin Asay via use-livecode > wrote: > > revExecuteSQL “aRecordData” > > Not tested, but I’m pretty sure

Re: Stuck on native database functions

2021-07-06 Thread Devin Asay via use-livecode
Bob, A couple of things: You should either be passing variable names, not variable contents, so put your variable names in quotes. revExecuteSQL “tDBID", “tInsertSQL", “tControlName”, etc OR you should be passing the name of an array variable, whose keys are numeric: revExecuteSQL “aRecordDa

Stuck on native database functions

2021-07-06 Thread Bob Sneidar via use-livecode
Hi all. I assemble an SQL statement that looks like this: insert into ObjectProperties (recordid,rect,controlname,owner,visible) VALUES (:1,:2,:3,:4,:5) I then execute this statement: revExecuteSQL tDBID, tInsertSQL, aRecordData I get records but with no data in them. I checked aRecordData

Re: Anyone able to connect to a PostgreSQL database with lc server?

2021-02-12 Thread Andre Garzia via use-livecode
ne here was able to connect to a > postgresql database server using LiveCode Server? > > I'm getting a hard crash here. The server is exiting with Signal 11 > (segmentation fault?) on the call to revOpenDatabase. The arguments passed > to the server are correct. The same app (us

Anyone able to connect to a PostgreSQL database with lc server?

2021-02-12 Thread Andre Garzia via use-livecode
Hi Folks, Before I escalate this to HQ, did anyone here was able to connect to a postgresql database server using LiveCode Server? I'm getting a hard crash here. The server is exiting with Signal 11 (segmentation fault?) on the call to revOpenDatabase. The arguments passed to the serve

Re: sqLite delete memory database

2020-05-01 Thread JB via use-livecode
I think SOLite intentionally fills the memory with garbage as part of its secure deletion when the database is closed. JB > On May 1, 2020, at 12:39 PM, Phil Davis via use-livecode > wrote: > > Is there an LC function that clears trash from memory? Does "hasMemory"? If

Re: sqLite delete memory database

2020-05-01 Thread Phil Davis via use-livecode
e 3 using the command line interface and it looks to me like SQLite is designed to securely delete the memory of the database automatically after it closes the database. I could be wrong but if you can’t read the memory it is probably already securely deleted when the database was closed. JB On Apr

Re: sqLite delete memory database

2020-05-01 Thread Tom Glod via use-livecode
JB via use-livecode < use-livecode@lists.runrev.com> wrote: > I have been testing SQLite 3 using the command line interface and it > looks to me like SQLite is designed to securely delete the memory of > the database automatically after it closes the database. > > I could be wrong b

Re: sqLite delete memory database

2020-05-01 Thread JB via use-livecode
I have been testing SQLite 3 using the command line interface and it looks to me like SQLite is designed to securely delete the memory of the database automatically after it closes the database. I could be wrong but if you can’t read the memory it is probably already securely deleted when the

Re: sqLite delete memory database

2020-04-30 Thread JB via use-livecode
I am not saying I know how to do it but are you able to read the memory like you can with a regular variable? If so maybe you can just assign each block of memory a null character. If you actually can get the memory address of the data it would be easy to delete it using C code. JB > On Apr 30

sqLite delete memory database

2020-04-30 Thread Bob Sneidar via use-livecode
I can create memory databases, but how do I delete it once created? revdb_disconnect still leaves it in memory. revCloseDatabase is just a synonym of revdb_disconnect. Bob S ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit th

Re: Best relational database for IOS / Android

2020-04-29 Thread doc hawk via use-livecode
Rick remanded, > Nice! Not just nice, but necessary for consistency—if I have a variable change which also causes two more to change, it is absolutely critical that either all three change, or that the whole thing fail. You just can’t do that without begin/end, AFAIK, unless you have a follow

Re: Best relational database for IOS / Android

2020-04-29 Thread Alex Tweedly via use-livecode
plore LiveCloud. It is a cloud based database by Canela Software that allows for both cloud and Local- to the device- database. http://canelasoftware.com/ I am developing and testing for a while. -Original Message- From: use-livecode On Behalf Of Skip Kimpel via use-livecode Sent: Wednesday,

Re: Best relational database for IOS / Android

2020-04-29 Thread Rick Harrison via use-livecode
Nice! > On Apr 29, 2020, at 12:15 PM, doc hawk via use-livecode > wrote: > > I recoded for Postgres from mysql a few years ago simply because, at the time > at least, livecode can send a compound transaction to Postgres, and only > single transactions to mysql. __

Re: Best relational database for IOS / Android

2020-04-29 Thread doc hawk via use-livecode
Rick rejoined, > I have a preference for PostgreSQL. I recoded for Postgres from mysql a few years ago simply because, at the time at least, livecode can send a compound transaction to Postgres, and only single transactions to mysql. ___ use-livecod

Re: Best relational database for IOS / Android

2020-04-29 Thread Rick Harrison via use-livecode
ning, > > In your opinion, what is the best relational database to use for an IOS / > Android application? > > Being a PC guy and always living in the Microsoft world, I always default > to SQL, however, with my latest discoveries of the complexities involved > and lack of su

RE: Best relational database for IOS / Android

2020-04-29 Thread Ralph DiMola via use-livecode
For a DB local on the device I use SQLite and it holds up well with very complex multi table queries. For a remote database I have had no problems with MySQL and it's open source brother MariaDB. Ralph DiMola IT Director Evergreen Information Services rdim...@evergreeninfo.net -Ori

Re: Best relational database for IOS / Android

2020-04-29 Thread Mike Kerner via use-livecode
do you mean for c/s? if it's client-only, then sqlite and mysql are perfectly integrated into lc for ios. On Wed, Apr 29, 2020 at 9:55 AM Skip Kimpel via use-livecode < use-livecode@lists.runrev.com> wrote: > Good morning, > > In your opinion, what is the best relational da

RE: Best relational database for IOS / Android

2020-04-29 Thread Clarence Martin via use-livecode
You may want to explore LiveCloud. It is a cloud based database by Canela Software that allows for both cloud and Local- to the device- database. http://canelasoftware.com/ I am developing and testing for a while. -Original Message- From: use-livecode On Behalf Of Skip Kimpel via use

Best relational database for IOS / Android

2020-04-29 Thread Skip Kimpel via use-livecode
Good morning, In your opinion, what is the best relational database to use for an IOS / Android application? Being a PC guy and always living in the Microsoft world, I always default to SQL, however, with my latest discoveries of the complexities involved and lack of support in LC I don't

Re: Using ODBC to connect to a MSSQL database

2020-03-24 Thread Bob Sneidar via use-livecode
NVM I was able to connect using revOpenDatabase(). Now my trouble is getting sqlYoga to make the connection, but I am close. > On Mar 24, 2020, at 4:39 PM, Bob Sneidar wrote: > > Hi all. > > I read in a thread a long while ago that someone was currently connecting to > a

Using ODBC to connect to a MSSQL database

2020-03-24 Thread Bob Sneidar via use-livecode
Hi all. I read in a thread a long while ago that someone was currently connecting to a MSSQL database via ODBC. Reading the dictionary, MSSQL is NOT one of the types of databases revOpenDatabase() can communicate with. I am right on the verge of creating an ODBC agent, but have hit this snag

Re: Documentation on Low Level Database Access

2019-04-11 Thread Dalton Calford via use-livecode
a use-livecode wrote: > > Hi all, > > > > I am looking at the git repositories, the widget documentation etc., > > looking for a solid guide on how livecode accesses database engines. > > > > For example, if I wanted to add low level support for another open sou

Re: Documentation on Low Level Database Access

2019-04-11 Thread Mark Wieder via use-livecode
On 4/11/19 9:12 AM, Dalton Calford via use-livecode wrote: Hi all, I am looking at the git repositories, the widget documentation etc., looking for a solid guide on how livecode accesses database engines. For example, if I wanted to add low level support for another open source database that

Re: Documentation on Low Level Database Access

2019-04-11 Thread Dalton Calford via use-livecode
Hi Richard, Thanks for the pointer. I will look that up this weekend. The database I am looking at is called firebird (www.firebirdsql.com). It has embedded and standalone libs. Supports windows, linux, osx and ios along with android. It is opensource and has native support for c++, c, pascal

Re: Documentation on Low Level Database Access

2019-04-11 Thread Richard Gaskin via use-livecode
Dalton Calford wrote: > I am looking at the git repositories, the widget documentation etc., > looking for a solid guide on how livecode accesses database engines. > > For example, if I wanted to add low level support for another open > source database that is available on all the

Documentation on Low Level Database Access

2019-04-11 Thread Dalton Calford via use-livecode
Hi all, I am looking at the git repositories, the widget documentation etc., looking for a solid guide on how livecode accesses database engines. For example, if I wanted to add low level support for another open source database that is available on all the same platforms as livecode, is there

Re: Database data & emoji's

2018-08-14 Thread Stephen MacLean via use-livecode
Unfortunately, this looks to be an issue with the revDatabaseColumnNamed() not getting the proper data, even when using a variable in the command to get binary data: put revDatabaseColumnNamed(sRecSet,"tw_full_text","test”) <- should get either text or binary data with put test into fld "clea

Re: Database data & emoji's

2018-08-14 Thread Stephen MacLean via use-livecode
Hi Tore, Thanks, but I’ve already looked at and tried those. Even putting the data directly from the RecordSet to the field just results in question marks “?” where the emoji should be: put textDecode(revDatabaseColumnNamed(sRecSet,"tw_full_text")) into fld "cleaned_tw_content" of cd “twClean

Re: Database data & emoji's

2018-08-14 Thread Tore Nilsen via use-livecode
You should look up textEncode and textDecode in the dictionary. I think they may prove useful. Best regards Tore Nilsen --- This mail contains no viruses or bacteria as it is electronically produced and untouched by human hands. Once printed it may or may not contain various microorganisms

Database data & emoji's

2018-08-14 Thread Stephen MacLean via use-livecode
Hi All, So I have data (text) stored in a mySQL DB that is set for UTF8 and it stores unicode and emoji characters just fine. My problem is that when I pull a field from the record set and put it into a LC field, I don’t get the unicode or emoji, just the the usual strange characters. I know

Re: Examples of encryption for database access

2018-06-28 Thread prothero--- via use-livecode
Thanks, Brian, Actually, I think I know how to do it now, with iv sent along with the data. I’ll post what I come up with. Thanks so much for your input. Bill William Prothero http://earthlearningsolutions.org > On Jun 28, 2018, at 7:38 PM, Brian Milby wrote: > > I can write an LC example, bu

Re: Examples of encryption for database access

2018-06-28 Thread prothero--- via use-livecode
by c.mail.sonic.net (8.15.1/8.15.1) with ESMTPSA id w5SMruW6005477 >(version=TLSv1.2 cipher=DHE-RSA-AES128-SHA bits=128 verify=NOT) >for ; Thu, 28 Jun 2018 15:53:57 -0700 > Subject: Re: Examples of encryption for database access > To: Brian Milby via use-livecode > Refe

Re: Examples of encryption for database access

2018-06-28 Thread Mark Wieder via use-livecode
On 06/28/2018 01:49 PM, Brian Milby via use-livecode wrote: Random IV means that an attacker can not generate a dictionary in advance. Knowing it at the same time is not an issue since they cypher is not cracked. The other reason is that the IV seeds the AES encryption so that the first block

Re: Examples of encryption for database access

2018-06-28 Thread Brian Milby via use-livecode
Random IV means that an attacker can not generate a dictionary in advance. Knowing it at the same time is not an issue since they cypher is not cracked. The other reason is that the IV seeds the AES encryption so that the first block does not give anything away. If the first encrypted block for

Re: Examples of encryption for database access

2018-06-28 Thread prothero--- via use-livecode
Mark, Pardon me for being dense. But if you send an iv with the data, can’t a hacker obtain and use that iv to support hacking the encrypted data? What I understand, possibly erroneous, is that a Dictionary attack involves trying all possible combinations of a key. A 32 char key would have 2**(

Re: Examples of encryption for database access

2018-06-28 Thread Kee Nethery via use-livecode
On Jun 28, 2018, at 9:17 AM, William Prothero via use-livecode wrote: > Another question I have is the best way to process the input text to > eliminate injection type attacks. I have a series of functions that filter out everything but ... digitsOnly() <- deletes everything other than 0 thro

Re: Examples of encryption for database access

2018-06-28 Thread Mark Wieder via use-livecode
On 06/28/2018 09:17 AM, William Prothero via use-livecode wrote: I understand Mark’s comment about putting the key and IV vector in the .htaccess file. I will do this as soon as I figure out if I’ve destroyed my server by deleting all files in the /etc/httpd directory by mistake (I was trying

Re: Examples of encryption for database access

2018-06-28 Thread William Prothero via use-livecode
e of Bill's demo it works fine. For that matter, a > 16-bit iv won't get you very far either. I'd be inclined to generate a large > random iv and post it to the server with the encrypted data. But I'd also > worry about putting a database out in the open like this with

Re: Examples of encryption for database access

2018-06-26 Thread Mark Wieder via use-livecode
;t get you very far either. I'd be inclined to generate a large random iv and post it to the server with the encrypted data. But I'd also worry about putting a database out in the open like this without good security constraints. Of course, I have no idea what Bill has in mind here, so ymm

Re: Examples of encryption for database access

2018-06-25 Thread Brian Milby via use-livecode
One thing this misses is that the IV is not another private key/password. It should be random/different for every use of the key. https://en.m.wikipedia.org/wiki/Initialization_vector https://crypto.stackexchange.com/questions/3965/what-is-the-main-difference-between-a-key-an-iv-and-a-nonce htt

Re: Examples of encryption for database access

2018-06-25 Thread William Prothero via use-livecode
Mark: Thanks, that makes it a lot easier. I have been tearing my limited hair out over trying to set Apache environmental variables and deleted a load of files on my server, accidentally. This I can do. Best, Bill > On Jun 25, 2018, at 4:04 PM, Mark Wieder via use-livecode > wrote: > > On 0

Re: Examples of encryption for database access

2018-06-25 Thread Mark Wieder via use-livecode
On 06/25/2018 02:17 PM, William Prothero via use-livecode wrote: Mark: I’ve been exploring, Googling, and my Web Host Manager to figure out where to set the environmental variables for the security keys. It might be nice if I could set different values for different subdomains on my server, but

Re: Examples of encryption for database access

2018-06-25 Thread William Prothero via use-livecode
roperty of some non-related >> object... if you need to distribute a stack without password protection I >> don't think there's any way to be completely secure, but there are ways to >> at least pretend to hide the keys. >> >> >> [semi-relat

Re: Examples of encryption for database access

2018-06-25 Thread William Prothero via use-livecode
operty of some non-related > object... if you need to distribute a stack without password protection I > don't think there's any way to be completely secure, but there are ways to at > least pretend to hide the keys. > > > [semi-related isue] > > be careful wi

Re: Examples of encryption for database access

2018-06-25 Thread Mark Wieder via use-livecode
t'); Your test code should be fine, but if you're interacting with a database you'll want to scrub the input before acting on it. -- Mark Wieder ahsoftw...@gmail.com ___ use-livecode mailing list use-livecode@lists.runrev.com Please visi

Re: Examples of encryption for database access

2018-06-25 Thread William Prothero via use-livecode
Corrections to the posted code: I changed the code to encrypt the returned text. I also note that using openSSL in php returns base64 data. Bill temp, testing iv for encryption --To test this on your own server, upload the php script where you put cgi's -- and modify the myURL setting. //

Re: Examples of encryption for database access

2018-06-25 Thread William Prothero via use-livecode
t; use to test AES encryption for sending posts to interact with a mysql > database. > > This work is inspired by the excellent dbLib product of Andre Garza, that got > me to look into encryption a lot deeper than I had to date. > > Perhaps Andre would like to chime in her

Examples of encryption for database access

2018-06-24 Thread William Prothero via use-livecode
Folks: In case you are interested, or if you have any feedback, here is the code I use to test AES encryption for sending posts to interact with a mysql database. This work is inspired by the excellent dbLib product of Andre Garza, that got me to look into encryption a lot deeper than I had to

RE: Inclusions for database access?

2018-04-07 Thread Ralph DiMola via use-livecode
lliam Prothero via use-livecode Sent: Saturday, April 07, 2018 7:57 PM To: Use-livecode Use-livecode Cc: William Prothero Subject: Inclusions for database access? Folks: I’m accessing a mysql database using Andre Garza’s software, and it works perfectly in the IDE. (LC9.0.0, Mac OSX 10.13.3). Ho

Inclusions for database access?

2018-04-07 Thread William Prothero via use-livecode
Folks: I’m accessing a mysql database using Andre Garza’s software, and it works perfectly in the IDE. (LC9.0.0, Mac OSX 10.13.3). However, when I build a standalone, the call just seems to hang and nothing is returned. I am assuming that I’m making some mistake with inclusions? What might I

Re: Re: A suggestion for an in-memory database, following up on Richard’s experiment

2018-03-01 Thread Richard Gaskin via use-livecode
have a lot of records and each record is a separate file, unless you tune the file system from its defaults you're limited to roughly total-disk-kb/4 for the number of files (Ext4 and most others these days use a default 4k block size). > I'd be curious to see the performance

Re: A suggestion for an in-memory database, following up on Richard’s experiment

2018-03-01 Thread Tom Glod via use-livecode
. If you are on Business License, its less of an issue I'd be curious to see the performance of using LC Arrays as Database. On Thu, Mar 1, 2018 at 11:07 AM, Jonathan Lynch via use-livecode < use-livecode@lists.runrev.com> wrote: > This is a different idea from the ot

A suggestion for an in-memory database, following up on Richard’s experiment

2018-03-01 Thread Jonathan Lynch via use-livecode
the record and saves it to its file. In this way, LC operates as an in-memory database, which is supposed to be very fast, and Apache does the multithreading to back up each record in the background. Assuming a powerful server with lots of RAM, could this allow us to handle massive concurrency

Re: good tutorial about connecting LC desktop apps to MySQL without exposing the database

2018-01-23 Thread Tom Glod via use-livecode
This is a great resource... thank you. On Tue, Jan 23, 2018 at 11:24 AM, Bob Sneidar via use-livecode < use-livecode@lists.runrev.com> wrote: > I should have said the REST of the data in transit... > > Bob S > > > > On Jan 23, 2018, at 08:23 , Bob Sneidar > wrote: > > > > While I store important

Re: good tutorial about connecting LC desktop apps to MySQL without exposing the database

2018-01-23 Thread Bob Sneidar via use-livecode
I should have said the REST of the data in transit... Bob S > On Jan 23, 2018, at 08:23 , Bob Sneidar wrote: > > While I store important data in encrypted format using a seed only I know, > the data in transit ___ use-livecode mailing list use-liv

Re: good tutorial about connecting LC desktop apps to MySQL without exposing the database

2018-01-23 Thread Bob Sneidar via use-livecode
definitely want to implement as soon as possible, although it will require a refactoring of my database connection and query routines. Trevor Devore mention a few months back some possibility of updating sqlYoga to use this kind of connection. Since my routines are entirely dependent on sqlYoga

good tutorial about connecting LC desktop apps to MySQL without exposing the database

2018-01-23 Thread Matthias Rebbe via use-livecode
MySQL/MariaDB without the need to expose your database by using an api. The tutorial even includes an api, written completely in livecode server script, which can be downloaded for free. You´ll find it here https://www.hostm.com/tutorials/livecode/api-mariadb-mysql <https://www.hostm.

Questions re: Michael McCreary Database Wizardry from LCGlobal?

2017-12-13 Thread JOHN PATTEN via use-livecode
Hello all! I am trying to decipher Michael McCreary’s database wizardry form the Livecode conference. Starting by duplicating what he had created with his Notes cloud app, but just using my own on-rev account and my mysql db. His Notes app works fine when it is pointing to his on-rev/mysql db

Database Setup

2017-05-08 Thread Bob Sneidar via use-livecode
Sooo... having shared my Database Setup card with another user, which is an sqlYoga wrapper if you will for connecting to mySQL and sqLite databases, I'm thinking about posting this in some fashion so that others can have a look, refine it, skin it etc. Is there such a thing for end user

Re: Customer database stack for FastSpring, etc?

2017-03-23 Thread tbodine via use-livecode
sorted. I thought someone might have created a customer contact tool in Livecode that would be suitable. Thanks, Tom B. -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Customer-database-stack-for-FastSpring-etc-tp4713278p4713291.html Sent from the Revolution

Re: Customer database stack for FastSpring, etc?

2017-03-23 Thread Richard Gaskin via use-livecode
tbodine wrote: > Anyone know of a stack designed to import and manage customer data > from ecommerce services such as FastSpring and Plimus? I only quickly skimmed their dev sites, but it seems both offer REST APIs using Basic Auth with JSON payloads. What issues have you run into working wit

Customer database stack for FastSpring, etc?

2017-03-23 Thread tbodine via use-livecode
Hi Livecoders. Anyone know of a stack designed to import and manage customer data from ecommerce services such as FastSpring and Plimus? Thanks, Tom B. -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Customer-database-stack-for-FastSpring-etc-tp4713278.html

Looking for advice on database syncing

2017-01-30 Thread pink via use-livecode
I am working on a new section of my CouchDB library to synchronize a Couch database with a local array. Before I wade too far in, I wanted to get to see if my plan makes sense.. I have two questions I'm hoping for input on: 1. Can anyone think of a scenario I am missing? 2. Is there any

Re: Cloning a SQLite (or any SQL) database

2016-05-23 Thread Bob Sneidar
Not so. I use MySQLWorkbench from a remote computer to save the database locally on my laptop all the time. However, large SQL databases might be very time consuming to do remotely. I have a Database Setup card which is capable of copying the data from one SQL database to another using queries

RE: Storing and retrieving data from a SQL database

2016-05-23 Thread Ralph DiMola
een Information Services rdim...@evergreeninfo.net -Original Message- From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf Of Peter Haworth Sent: Sunday, May 22, 2016 1:24 PM To: How to use LiveCode Subject: Re: Storing and retrieving data from a SQL database Glad you

Re: Cloning a SQLite (or any SQL) database

2016-05-22 Thread Kay C Lan
On Mon, May 23, 2016 at 4:46 AM, Paul Dupuis wrote: > this app may use MySQL (or someday, possible other flavors of > SQL database) and I'd like to have a generalized routine that just > relies on LiveCode and "standard" SQL commands. > If you are using MySQL why not h

Re: Cloning a SQLite (or any SQL) database

2016-05-22 Thread et...@lish.net
Check out LiveCloud for LiveCodehttps://livecloud.io Addresses the cloning element but it's seems like a closed database architecture so you have to adopt their model I've played with it but yet to build anything production grade with it.  The team is extremely helpful and stays with

Re: Cloning a SQLite (or any SQL) database

2016-05-22 Thread et...@lish.net
Check out LiveCloud for LiveCodehttps://livecloud.io Addresses the cloning element but it's seems like a closed database architecture so you have to adopt their model I've played with it but yet to build anything production grade with it.  The team is extremely helpful and stays with

  1   2   3   4   5   6   7   >