|
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
|
|
|
|
|
what is the name of designer program like fruity loops or another multimedia programs because I feel is not visual basic or another programing known
|
|
|
|
|
I want to create data notation (like JSON is used).
1) Is it good enough to use languages built-in features (types, notation etc), extend it (e.g. with another types), and output some JSON?
2) Or should I build it from scratch and parse all built-in features and add my additions then output it into JSON?
By using 1) I don't have to implement core things. If there are fixes - then it's good. If there are changes that I don't like I can deal with them from case to case... I guess.
Howerer I'm tied to a programming language - so users had to use the programming language (instead library).
By using 2) I have to build everything but I'm not tied to one particular language.
Maybe I can mix it ( 1) for the language, 2) for other languages).
What are your toughts on this topic.
ps. I was thinking about using the Red ( red-lang.org/ ). It's in alpha but I don't think it will change a lot.
|
|
|
|
|
Why reinvent the wheel?Both JSON and XML provide everything you could need already. And they are both supported by nearly all major programming languages.
|
|
|
|
|
JSON and XML and YAML and ... Isn't the whole bunch of them wheel reinventions? When everybody else are creating new wheels which are better suited for the purpose than all the old ones, why shouldn't I do the same? 
Now I have personally come to one conclusion, in particular from many years of exposure to XML: Data description languages are for computers, not for humans. This kind of stuff you, a human, do not handle better than a computer does. You make typos, you do not structure it according to the rules, in brief: You mess it up. So keep humans out of it!
The best way of doing that is to make it unreadable. Binary. I know that is a highly Politically Uncorrect statement; yet I think that what humans should not mess up, should not be made available for messing up - especially not with as simple tool as a plain text editor. You can also mess up by using a binary generator (/editor), but that takes a lot more deliberate action. The mess comes from "You asked for it, you got it" - not from "Ooooops!"
So when I need to store data for my own applications (and there are no requirements for sharing the data files with other applications), I do it as binary files. Always in a Tag-Length-Value format, evading all sorts of escape mechanisms. No need to search for the end of the field. Arbitrary binary data. Space allocation for the value can be made before it is actually read. Parsing the file is extremely fast. The space overhead is quite moderate.
Details of how you do the TLV format may vary slightly. E.g. in some applications, there will never be more than a couple hundred distinct tags, so it is stored in 15 bits; the "sign bit" is a flag indicating that the Value is in fact a sequence of TLV values. If values are small, the length is 16 bits, too. If there is any risk at all of overflow, I use the BER style of variable length handling: The length of the enclosing TLV is 0, each member carries its own length; the member sequence is terminated by and all zero TLV. (Then you cannot preallocate space for the entire structure without reading it, but usually a composite value won't be stored as a single unit anyway.)
Like all class definitions have a ToString, they have a ToTLV. And a FromTLV. The "Schema" is represented by these ToTLV funcitons. If any other application needs data in, other formats, adding ToXML, ToJSON, ToYAML, ... alongside with ToString and ToTLV is straigtforward. But for the application's private file, the binary ToTLV is used.
|
|
|
|
|
My book discusses the advantages of TLV over text-based encodings. The latter typically require more space and processing time. Readability is touted as an advantage of text, but it's often as you say.
Text's advantage is in interoperability between big and little endian systems. If that's a requirement, TLV is a non-starter unless all the fields are the same length. A protocol standard has to consider this, but a proprietary system can standardize on one endianism and use TLV more freely, although it still has to maintain protocol backward compatibility unless it's OK to shut down the entire network during an upgrade.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
