|
If you think state is data, chances are you are committing the cardinal sin and just doing CRUD over HTTP. State is about more than data, it helps to represent a state machine telling you not just what the current state is, but if you use HATEOAS, it tells you what operations you can do next.
|
|
|
|
|
It is as though somebody meant ESTABLISHED were free market dynamics for information networking, but although they never caught up with handshaking, many cases are logged trying to find out if OPTIONS was really a communist ideal.
|
|
|
|
|
I have made a simple C# web scraping application, strictly for personal use, that searches car rental websites and then combines the results into a single html-webpage. Now I would like to take this one step further and have the following features:
1. Make this accessible in my Android mobile phone as well, in addition to on my Windows computer.
2. Add GUI components (buttons, checkboxes, comboboxes, etc for filtering, sorting, mark favorites, etc) that can call client-side functions/methods (btw, there is no server).
What's the recommended way to accomplish this? I think it's kind of convenient to keep it as an html-webpage because I get some things for free (e.g. text search, print to a printer, copy-and-paste, etc) but it seems it's not possible to make the GUI-components in an html-webpage trigger client-side functions. I expect to add features as time goes by so it would be nice if those changes are as similar as possible in both the Android app and the Windows application. If I am allowed to choose, then I would prefer a programming language as similar to C# as possible because that's what I'm most experienced in.
|
|
|
|
|
Load all your "stuff" into a cloud drive; for all intents it's static content you're outputting. Then you can "browse" it with all your mobiles / PC's.
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
Let's assume my web scraping applications find 100 rental cars and then it creates an html-document containing those 100 rental car offers. Now, let's assume I want to filter to only show the 10 cheapest cars, where would this be done? Would the cloud drive create a new, smaller html-file or could the html-file do this by itself somehow when I click a button?
|
|
|
|
|
How can a "cloud drive" manipulate data if it is "serverless"? (i.e. dumb)
Any filtering / sorting would have to happen on the client; so to get "10", you need to download the whole "100" first.
"Serverless" is an illusion; like the future.
(Better yet, store CSV's one can open and manipulate in Excel)
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
What different programming languages, triggered from a button within html, can perform the sorting/filtering on the client side?
|
|
|
|
|
And language that can consume the DOM: C, C#, C++, VB, VB.NET, Java, Excel (VBA), blah and blah.
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
Could you please provide some example code or refer me to a beginner's guide (on the Internet) on how to implement the client-side Filter-10-Lowest-Prices-button event handler so that it ends up calling a method in C# that then modifies the html? What are the steps necessary in between?
|
|
|
|
|
In your case, since Excel runs on Android and Windows, all you need is an Excel spreadsheet with your "100 cars" to support "roaming data"; anything else would be over-kill. Add some VBA for a "smart document".
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
Ok, so you're suggesting I abandon the thought of using a webbrowser+html-file and use an Excel-sheet instead?
|
|
|
|
|
Based on your requirements, use Excel. Your initial "solution" was premature.
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
It seems Excel on Android doesn't support VBA...
|
|
|
|
|
Office Scripts: The future is here
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
Please correct me if I'm wrong, but Office Scripts appears to be introduced in Office 365 and to get Office 365 I would need to sign up for a subscription (I can't buy it once and be done paying money to Microsoft for Office 365)?
|
|
|
|
|
This goes beyond "design and architecture". I'll stop now.
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
|
Good evening,
This is a very broad question, and if somebody deems it be moved to another board then please feel free.
I am am Filemaker developer - love the platform - has lots of great features... except the price. For me to host a database - for say 20 simultaneous clients - it will cost me (well, the client) a fortune. Cost prohibitive really for this setup.
I'd like to see what other people think of various platforms to use to draw up databases on a Linux box, and have a browser at the front end - suitable for mobile devices too.
As I say, this is a broad question, so I am open to all (polite  ) suggestions.
I'm not stranger to coding and able to learn new languages.
Can I get some opinions please?
Thanks in advance.
Greg
|
|
|
|
|
You want something that matches Filemaker, and then some. I suspect few people know what Filemaker does (4GL?). You're better off stating what Filemaker does that you need (without necessarily mentioning the product at all).
That's a tool stack: like LAMP (Linux, Apache, MySQL, PHP), Windows (.NET), etc.
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
Good morning,
My apologies if using a product name breached the rules, but I needed a point of comparison for my requirements.
In short, I need to code a database and front-end that works on multiple platforms, and can be developed on Mac OS. I am liking the look of Python so far, some say tying that in with Flask might be a good combination - but I'm no expert in either.
Cheers,
Greg
|
|
|
|
|
You can mention a product; you just shouldn't assume people know what it does.
Filemaker runs on multiple platforms; hard to recommend an alternative when that is your requirement.
Quote: Not only does FileMaker work seamlessly on Macs and PCs, but it is also accessible on iOS and Android mobile devices and all types of Web browsers thanks to the power of FileMaker Go and FileMaker WebDirect.
As for the cost factor: pay me now or pay me later (with time learning a new development platform).
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
modified 30-Jul-20 6:34am.
|
|
|
|
|
I have sql server database insert operation is very slow. I am moving data from stage tables--> temporary tables-->Master tables --> Data warehouse tables. Loading the data from stage tables to master tables it is very slow due primary key, foreign key constraints and non clustered index.
I am trying to drop the non clustered index before loading the data but there is no use. I am trying to drop the primary key getting issue with foreign key.
|
|
|
|
|
Be very sure you are only doing and insert, not an update.
We created a stored proc that removed all indexes except the PK on the destination tables. applied the insert and then rebuilt the indexes.
CAVEAT your data MUST be clean as you lose all referential integrity checking.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP
|
|
|
|
|
If i drop non clustered index will i any benefit on insertion? If i found matched record i am updating otherwise insert.
|
|
|
|
|
kali siddhu wrote: If i found matched record i am updating otherwise insert
Right there is your problem, for every record you are checking for an existing record and when you do the update the system has to check referential integrity.
Split your data into 2 set, those to be inserted and those to be updated. OR delete the records to be updated and insert all records. This may not be viable as it will break existing RI.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
