Reputation
10,397
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
4 36 50
Newest
 Enlightened
Impact
~248k people reached

13h
answered Alternatives to cron jobs or other ways of improving scheduled task performance
13h
answered Are media queries really needed for software development on web side?
1d
comment Adding new features to software while keeping the same database
Adding columns and tables can be done on the existing db, it's called a migration. So at least for this use case there is no need to completely swap the database (not to mention the effort to write code that serves two databases at the same time). 'reinterpretation' of existing data may depend on what exactly that would mean and how much data needs to be processed and possibly changed. But still I would prefer to add a new table and limit the impact to this part of the db instead of moving around whole databases.
1d
answered Whats the differnce between server and site?
Sep
1
comment Monthly billing updated daily
There are things ilke 'commercial years' (360 days), 'commercial months' (30 days) and 'commercial rounding'. Not sure how exactly are these defined, but maybe lloking those up would help. At least here in Germany that's as far as I know how banks calculate interests and similar date related payments.
Sep
1
comment Monthly billing updated daily
Really a business problem. I would maybe just calculate roughly the number of remaining weeks, round down and then bill $2.50, $5.00, $7.50 or $10.00 and live with the fact to lose a few cents here and there. But maybe workplace.stackexchange.com can give you a better answer.
Aug
31
comment Why does databases use text?
Most/many of the 'text' data we store is too small for efficient compression (typical set of name, street, city, zip...). Also we want fast searches, so the db has to index it and for that needs the text anyway (and otherwise we would have to send around whole tables so your local computer can find a single row? not efficient at all). Also for some use case NoSQL/document store databases (and others like Postgres) allow to store data in serialized form, though they often still index the single elements). Depending on your exact use case you could find some db that's optimized for large text.
Aug
30
comment What is the problem will happen if I create auto generate ID without using mysql auto increase of mysql table by my self?
@Cambodiachannel with only 400 rows (or even a few thousands wouldn't make much of a difference) there won't be any issue with performance. Any serious database can handle that with ease. Just nobody here really understands why exactly you would want to do it, since it seems to only create extra work without many advantages to it. (unless maybe you would have some special way how you want things to be numbered). You run the risk that your self written solution may fail in the future when additional users are added or the project grows. If this is no concern to you it may be ok.
Aug
30
comment What is the problem will happen if I create auto generate ID without using mysql auto increase of mysql table by my self?
Most likely the database can also highly optimize generating a new key that's unique without having to find the record with the highest value or comparing against the index and instead simply keep some additional value together with the table that holds the information needed to generate a new key. So even when there is only a single writer it may still be more performant (if that is relevant)
Aug
28
comment How to *detect* if open source software is used in a commercial product?
If there are technical ways would very much depend on the type of code and used technology. But one rather common way how such things become known are disgruntled former employees or possibly competitors of a company.
Aug
26
comment Querying large number of timestamps
Without any information on amount of data and available hardware this would be difficult to answer. You say 'millions of timestamps' but is this 'millions per year, month, day second? There are databases that may be able to handle even large amounts of such data. Elasticsearch for example (would also have a nice query interface for the type of query you want to do). Otherwise maybe Redis would be worth looking into.
Aug
21
comment Automatically reverting commits that fail the build
Failed builds should never have reached master to begin with. That's what development & feature branches are used for. Those changes go then in something like an integration branch where you can test if all new features of several developers will work together and only if this is tested in can go into master. Or at least that's one possible workflow.
Aug
13
reviewed No Action Needed What's the best way to track updates when syncing data from MySQL remote server to local SQLite database?
Aug
13
reviewed Reviewed Calendar/Planning algorithm
Aug
13
reviewed No Action Needed Why don't “multi-infinite” list comprehensions work with lazy evaluation?
Aug
13
reviewed No Action Needed Simplifying Some Probabilistic If-Then Spaghetti Code
Aug
13
reviewed No Action Needed Calendar/Planning algorithm
Aug
13
reviewed No Action Needed Single import in a large file vs. multiple imports in smaller files. [Golang]
Aug
13
reviewed Leave Closed How to explain to PM that a task is too small to be shared
Aug
7
comment Designing CRUD part of an HTTP API
Though depending on your use case other features may still be of interest, like maybe sort.