Starcounter/Starcounter

Starcounter is a fusion of your C# VM and a ACID RAM DBMS

pal88

@pal88

oh.. can someone help me out... thanks..

Per Samuelsson

@per-samuelsson

yes, if u specify more precisely what u are after

pal88

@pal88

hi @per-samuelsson

i need to plot graphs using data acquired on a regular basis...

for eg - like plotting a graph of temperature variations over a week/month

Per Samuelsson

@per-samuelsson

i will forward this and see if someone can help u out

Marcin Warpechowski

@warpech

from the server side, you need to expose the data as a JSON array

and then on the client, you just bind to the data, preferably using a Web Component or some JavaScript charting library

Ivar Bergman

@ivarbergman

Hi! What is the recommended way to get the Location value (in Javascript)? I need to create a xhr call to a Handle, and thus need to set the Referer headers. Is there some method/property on the Puppet object I can use to fetch the Location value?

Ivar Bergman

@ivarbergman

I think I found it. Can you confirm that this seems like a OK way to pass the session/location in a xhr call:

xhr.setRequestHeader('X-Referer', puppet.network.remoteUrl.pathname);

Per Samuelsson

@per-samuelsson

hi @ivarbergman

sorry, this is totally not my area, I'll see if I can find someone that can pop in and comment on your findings :sparkles:

Tomek Wytrębowicz

@tomalec

Hi @ivarbergman , do you really need to make very custom XHR? there is a puppet.network.send method

Per Samuelsson

@per-samuelsson

thanks tomalec :+1:

Tomek Wytrębowicz

@tomalec

.send will take care on versioning, OT and all that stuff for you

in other case puppet.network.remoteUrl seems good way to go, but we have not tested it that way, and probably you will need to handle versioning manually

Ivar Bergman

@ivarbergman

Thanks! I will take a look at .send

Tomek Wytrębowicz

@tomalec

You can let me know directly if you find any problems with it

Marcin Warpechowski

@warpech

@ivarbergman is some pattern regarding the use of Puppet that we could further explain in the docs?

Ivar Bergman

@ivarbergman

Thanks for the feedback. Maybe I should explain what I am trying to do. (You might have a better suggestion on how to implement this):

We use html5 FileApi to upload large files to the server. Each file is divided into chunks. The client makes a http get request to check if the chunk already exists on the server. I the chunk needs to uploaded the client makes a http post call with the file chunk data. This is repeated until all chunks exists on the server.

We also thinking about wrapping the http://www.resumablejs.com/ into a web component with a starcounter handler backend.

Therefore I need to make a custom xhr call, to be able act on different http status, but I still need to make sure that the Session is intact. Have you done anything similar to this?

Ivar Bergman

@ivarbergman

Hi! Is there a way to get the current instance of the ServerConfiguration class? From within an application.

The reson is that I need to get the DatabaseDirectory property to perform a backup routine using ShadowSpawn as described in the Guide

Ivar Bergman

@ivarbergman

(One could argue that it is easier to make a bat-script with the path hard coded. But since the path is in the database config file it might be less administrative hassle to trigger the backup job from the application it self.)

Marcin Warpechowski

@warpech

since Administator deals a lot with reading server config, maybe you will find a way browsing the Administrator source? https://github.com/Starcounter/Starcounter/tree/develop/src/Starcounter.Administrator

I see there is some public method https://github.com/Starcounter/Starcounter/search?utf8=%E2%9C%93&q=GetServerInfo

Sufian Saory

@thesufian

This message was deleted

Praveen Kumar Prakash

@praveen-prakash

Hi I heard about startcounter and try to understand the same. I have downloaded the framework version 2.1.298 (Oct 28, 2015 9:18:11 PM). and trying to run your sample app "UserAdmin" from github. I tried to run but it fails due to this error
Probing location 'C:\Program Files\Starcounter\LibrariesWithDatabaseClasses\Starcounter.Node.exe' because this directory is in the search path.
Could you guys help me to run this sample
Thanks

Per Samuelsson

@per-samuelsson

hi @Prav962, sorry no one has answered this! i think it might be so that we have had the wrong chat/gitter setup, so we've missed this

is it ok with you if i create an issue out of this on github.com\starcounter\starcounter\issues issue tracker? and i'll try my best so that you get help!

Dan Skatov

@dan31

Hi @Prav962 @per-samuelsson This message is a duplicate of StarcounterSamples/UserAdmin#9. Please follow up in the issue!

Per Samuelsson

@per-samuelsson

ah, ok, super than, then this was not a missed support after all :clap:

rogrdat

@rogrdat

I'm looking to record iteration history -- every change to the database table (old value, new value), who made it, when it was made? Since this is mostly for reporting purposes., I would like to have a "trigger" write the most recent change to disk (and not memory). Can anyone describe an approach that I could use to accomplish this?

Dan Skatov

@dan31

Hi @rogrdat, thanks for your question! We have a mechanism called "commit hooks", which is similar to what is known as triggers in relational databases: http://starcounter.io/guides/transactions/commit-hooks/. Your "Who" might be the current user that you can select inside a hook, the "When" is just a timestamp of now, and "What" is a JSON-dump of an object. This data you can buffer and flush to text files on a disk on a scheduled basis, e.g. once per 15 minutes, or use some well-proven logging library for .NET.

To add here, in future releases, 2.4/2.5, we are shipping a new version of the kernel based on logopt storage architecture. Namely, it stores raw log entries with DB operations and enables to flatten them time to time into an optimised log representation. We are exploring use cases for leveraging this architecture, when one wants to retain certain log records from being flattened out and have the full story of changes in the data.

PatrickStudi

@PatrickStudi

Hi Starcounter, I'm looking at hosting options for running Starcounter on AWS. Any recommendation as to instance configuration?
Is it possible to run Starcounter on Linux+Mono currently?

Martin Törnwall

@mtornwall

Hi @PatrickStudi! I run Starcounter on Windows server hosted on Azure. My recommendation is that you get an instance with a respectable amount of memory (at least, say, 8 GB). Based on the benchmarking I've done, anything under 4 GB is likely to suffer under load.

As for Linux support, Starcounter doesn't run on Mono. The .NET parts might, but there's a lot of native code underneath. A release that will support the Linux+coreclr platform is supposed to be coming in 2016, but since I'm not a Starcounter employee I can't speak to when.

PatrickStudi

@PatrickStudi

thanks @mtornwall, I read up on SC github and realized mono support is in the 3.x milestone quite far down the road.
You run on a virtualized machine on Azure right? Any issues with that?

Dan Skatov

@dan31

@mtornwall thanks for an excellent follow-up :) @PatrickStudi, we have really exceptional users! To add to @mtornwall feedback, we recommend at least 2 cores and 8 GB RAM. We do not recommend 1-core instances for a real-world usage. Good default choice for a storage is HDD. Modern HDDs can burst terabytes of sequential writes in seconds. You can read more on that choice here: http://starcounter.io/guides/tools/run-starcounter-in-production/. However, in AWS the HDD doesn't come inside your instance, hence you might notice a need to move to SSD if you have write-intense applications with +70% writes.

Dan Skatov

@dan31

@PatrickStudi We target native Microsoft's dnx over Mono. Our plans on releasing a dnx version are tightly connected to their roadmap: https://github.com/aspnet/Home/wiki/Roadmap. Their decision this year is to let in more time to have all bits working together: https://blogs.msdn.microsoft.com/webdev/2016/02/01/an-update-on-asp-net-core-and-net-core/. Hence we will get back to you once the dnx roadmap is clarified and becomes less moving target. Currently we focus our development on features for our Windows users, such as a replication module, and numerous of usability improvements.

PatrickStudi

@PatrickStudi

@dan31 Thanks Dan, excellent info! For now running on Windows is not a problem but in the long run *nix support will matter.

Dan Skatov

@dan31

This message was deleted

Dan Skatov

@dan31

@PatrickStudi We are currently running a couple of AWS instances for our own things. We have t2.medium for app playgrounds and c4.xlarge for a download server. The latter we had to move to c4.xlarge since it prepares installers (not SC-related stuff, like packing, signing etc) and produces a considerable load on the machine. In order to make this preparations less a bottleneck and let tens of downloads simultaneously without a noticeable slowdown, we moved the original t2.large to c4.xlarge. However, we are considering to move our servers from AWS to several dedicated/VPS machines. In Sweden we have a provider called GleSYS who provides VPS and dedicated servers for a decent price in Stockholm and London. Going that path of "non-cloud" machine, one have to cater for backups and failover on his own, I don't see a problem with it, especially considering the forthcoming Windows Server 2016 with sync and async storage replica on board. We also have a successful usage cases of Hetzner dedicated servers among our customers, where you can have a Windows machine with 48 Gigs of ram + 4 Tb HHD + 30 Tb channel per month worth only 70 euros per month. Perhaps, a strong benefit of AWS when you should afford AWS costs is the ability to move instances easily between regions. When you need a machine in the US (to reduce latency for the local customers), it takes you 30 mins only on AWS to have a clone of your European instance. If you are going to utilise Starcounter in production in a long run, we recommend to use either dedicated server or your own server/colocation, it will pay back in a matter of a year. AWS/Azure machines work flawlessly as well, your only consideration is total cost of the machine ownership. More on tuning failover/backups today with Starcounter you can read on http://starcounter.io/guides/tools/run-starcounter-in-production/. In future versions we are going to provide simpler tools with Starcounter out of the box to handle these scenarios.

PatrickStudi

@PatrickStudi

Great! We use Glesys as well as Amazon so that gives me confidence we won't be locked in or trip up on the hardware. Thanks again

Martin Törnwall

@mtornwall

@PatrickStudi I haven't had any serious issues with Starcounter on Azure so far, but to be fair my serivces haven't been under any signficant load. Nevertheless they have been running flawlessly with acceptable uptime (~ 99.9%) in spite of my questionable software upgrade practices :)

There have been no instances whatsoever of downtime caused by Starcounter

Ersin Tarhan

@ersintarhan

Hello guys. How i can implement Sql's MERGE logic to Starcounter with best performed?

Ruslan Fomkin

@k-rus

Hi @ersintarhan MERGE can be implemented with SELECT statements and iterating the results and inserting new raws in C# code. The performance will mainly depend on your SELECT statements. There is performance penalty in mixing SQL and C# logic in Starcounter, since it is not an ORM. If you need more elaborated answer, welcome to submit your question on starckoverflow, where it suits well, or on our GitHub tracker.

O-lexey

@O-lexey

Dear friends, could you help me with Starcounter on Windows Server 2016? Everything works well on my desktop Windows 10. I have done a clean installation of Windows Server 2016 Standard. And then Starcounter, without any errors. But when I try to start: "ScErrNetworkGatewayTerminated (SCERR10021): The server detected that the network gateway executable (scnetworkgateway.exe) unexpectedly terminated."

Dan Skatov

@dan31

Hello @O-lexey! @alemoi, please have a look (I don't think we have any customers running on Windows Server 2016 yet), maybe this is something you are already aware of on fresh installations of Windows Server?

Where communities thrive

People

Repo info

Activity